DATABASE & DBMS – 20 QUESTIONS
Question 1
DBMS stands for: (a) Data Base Management System
(b) Database Management System
(c) Data Binary Management System
(d) Digital Base Management System
Question 2
SQL stands for: (a) Structured Query Language
(b) Simple Query Language
(c) Standard Query Language
(d) Systematic Query Language
Question 3
Which of the following is a PRIMARY KEY? (a) A key that can have NULL values
(b) A key that uniquely identifies each record in a table
(c) A key that can have duplicate values
(d) A key used for sorting
Question 4
Which SQL command is used to retrieve data from a database? (a) GET
(b) FETCH
(c) SELECT
(d) RETRIEVE
Question 5
Norm alization is used to: (a) Increase data redundancy
(b) Reduce data redundancy and dependency
(c) Increase database size
(d) Slow down queries
Question 6
FOREIGN KEY is used to: (a) Delete records
(b) Establish relationship between two tables
(c) Create backup
(d) Sort data
Question 7
Which of the following is NOT a type of database? (a) Hierarchical
(b) Relational
(c) Network
(d) Sequential
Question 8
DDL stands for: (a) Data Definition Language
(b) Data Description Language
(c) Database Definition Language
(d) Data Design Language
Question 9
Which command is used to add new records in a table? (a) ADD
(b) INSERT
(c) APPEND
(d) CREATE
Question 10
ACID properties in DBMS stand for: (a) Atomicity, Consistency, Isolation, Durability
(b) Accuracy, Completeness, Integrity, Durability
(c) Addition, Consistency, Integrity, Data
(d) Atomicity, Completeness, Isolation, Data
Question 11
Which is the most widely used database model? (a) Hierarchical
(b) Network
(c) Relational
(d) Object-Oriented
Question 12
The JOIN operation combines: (a) Rows from one table
(b) Rows from two or more tables
(c) Columns only
(d) Database files
Question 13
Which SQL clause is used to filter records? (a) FILTER
(b) WHERE
(c) HAVING
(d) SELECT
Question 14
A VIEW in SQL is: (a) Physical table
(b) Virtual table based on SQL query result
(c) Backup table
(d) Temporary storage
Question 15
Which normal form eliminates transitive dependency? (a) 1NF
(b) 2NF
(c) 3NF
(d) 4NF
Question 16
Popular RDBMS software includes: (a) MySQL
(b) Microsoft Word
(c) Photoshop
(d) Chrome
Question 17
DML stands for: (a) Data Manipulation Language
(b) Data Management Language
(c) Database Manipulation Language
(d) Data Modeling Language
Question 18
Which command is used to delete a table? (a) DELETE TABLE
(b) REMOVE TABLE
(c) DROP TABLE
(d) CLEAR TABLE
Question 19
In SQL, the (*) symbol represents: (a) Multiplication
(b) All columns
(c) Comment
(d) Primary key
Question 20
MongoDB is an example of: (a) RDBMS
(b) NoSQL Database
(c) Spreadsheet
(d) Operating System
ANSWER KEY
| Q No. | Answer | Topic |
|---|---|---|
| 1 | (b) | DBMS Definition |
| 2 | (a) | SQL Definition |
| 3 | (b) | Primary Key |
| 4 | (c) | SELECT Command |
| 5 | (b) | Normalization |
| 6 | (b) | Foreign Key |
| 7 | (d) | Database Types |
| 8 | (a) | DDL |
| 9 | (b) | INSERT Command |
| 10 | (a) | ACID Properties |
| 11 | (c) | Database Models |
| 12 | (b) | JOIN Operation |
| 13 | (b) | WHERE Clause |
| 14 | (b) | VIEW |
| 15 | (c) | Normalization Forms |
| 16 | (a) | RDBMS Examples |
| 17 | (a) | DML |
| 18 | (c) | DROP TABLE |
| 19 | (b) | SQL Wildcard |
| 20 | (b) | NoSQL |