=========================================================== ===========
DBMS MCQ QUESTIONS
MODEL PAPER – 5
========================================================================
1. What is a database in the context of DBMS?
a. A collection of tables
b. A collection of files
c. A collection of records
d. A structured collection of data
Answer: d. A structured collection of data
2. Which of the following is the
primary purpose of a database management system (DBMS)?
a. Creating data
b. Organizing data
c. Analysing data
d. Generating data
Answer: b. Organizing data
3. What is the role of a database
schema in DBMS?
a. It defines the structure and organization of the database
b. It manages user access and security
c. It performs data analysis and reporting
d. It controls data processing algorithms
Answer: a. It defines the structure and organization of the database
4. Which component of DBMS
ensures data consistency and integrity in a relational database?
a. Query Optimizer
b. Data Dictionary
c. Transaction Manager
d. Database Administrator
Answer: c. Transaction Manager
5. In a relational database, what
is a primary key?
a. A key used for encryption
b. A unique identifier for a table's records
c. A key used for sorting records
d. A key used for indexing
Answer: b. A unique identifier for a table's records
6. What is the purpose of the SQL
language in DBMS?
a. Managing transactions
b. Querying and manipulating data
c. Controlling data redundancy
d. Establishing network connections
Answer: b. Querying and manipulating data
7. In DBMS, what is the function
of the Data Dictionary?
a. Managing database security
b. Storing user passwords
c. Storing metadata about the database
d. Executing SQL queries
Answer: c. Storing metadata about the database
8. What is the primary role of
the Database Administrator (DBA) in a DBMS?
a. Designing database schemas
b. Writing SQL queries
c. Managing user access and security
d. Executing database transactions
Answer: c. Managing user access and security
9. Which normalization form
ensures that there are no partial dependencies in a relational database?
a. First Normal Form (1NF)
b. Second Normal Form (2NF)
c. Third Normal Form (3NF)
d. Boyce-Codd Normal Form (BCNF)
Answer: c. Third Normal Form (3NF)
10. What is the purpose of the
indexing mechanism in a database?
a. Sorting records
b. Accelerating data retrieval
c. Encrypting data
d. Managing transactions
Answer: b. Accelerating data retrieval
11. In a relational database, what is a foreign key?
a. A key used for encryption
b. A key used for sorting records
c. A unique identifier for a table's records
d. A key that establishes a link between tables
Answer: d. A key that establishes a link between tables
12. What is the primary purpose
of a database transaction?
a. Retrieving data from the database
b. Inserting new records into the database
c. Updating existing records in the database
d. All of the above
Answer: d. All of the above
13. Which of the following is an
example of a NoSQL database model?
a. Relational Database Model
b. Hierarchical Database Model
c. Document-Oriented Database Model
d. Network Database Model
Answer: c. Document-Oriented Database Model
14. What is ACID in the context
of database transactions?
a. A database query language
b. A data encryption algorithm
c. A set of properties ensuring reliable transactions
d. A database management system
Answer: c. A set of properties ensuring reliable transactions
15. What is the role of the SQL
SELECT statement in a database query?
a. Inserting new records
b. Updating existing records
c. Retrieving data from the database
d. Deleting records from the database
Answer: c. Retrieving data from the database
16. In the context of database
design, what does denormalization involve?
a. Reducing redundancy by eliminating data duplication
b. Breaking down complex tables into simpler ones
c. Introducing redundancy for performance optimization
d. Normalizing tables to eliminate data inconsistencies
Answer: c. Introducing redundancy for performance optimization
17. Which of the following is a
key advantage of using a distributed database system?
a. Increased data security
b. Improved data integrity
c. Enhanced data availability and fault tolerance
d. Simplified data management
Answer: c. Enhanced data availability and fault tolerance
18. What is the purpose of the
GROUP BY clause in SQL?
a. Sorting records
b. Filtering records based on a condition
c. Grouping records based on specified columns
d. Joining tables
Answer: c. Grouping records based on specified columns
19. In database terminology, what
does CRUD stand for?
a. Create, Retrieve, Update, Delete
b. Control, Retrieve, Update, Duplicate
c. Compile, Retrieve, Update, Distribute
d. Copy, Retrieve, Update, Distribute
Answer: a. Create, Retrieve, Update, Delete
20. What is the primary purpose
of database indexing?
a. Sorting records
b. Accelerating data retrieval
c. Encrypting data
d. Managing transactions
Answer: b. Accelerating data retrieval
21. What is the purpose of the SQL JOIN operation in a database query?
a. Sorting records
b. Combining rows from two or more tables based on a related column
c. Filtering records based on a condition
d. Grouping records based on specified columns
Answer: b. Combining rows from two or more tables based on a related
column
22. Which of the following is a
characteristic of a NoSQL database?
a. Strict schema
b. Tabular data storage
c. ACID properties
d. Flexible schema
Answer: d. Flexible schema
23. What is the purpose of the
SQL INSERT statement in a database query?
a. Retrieving data from the database
b. Inserting new records into the database
c. Updating existing records in the database
d. Deleting records from the database
Answer: b. Inserting new records into the database
24. In the context of databases,
what does the term "normalization" refer to?
a. Introducing redundancy for performance optimization
b. Organizing data in a structured manner
c. Reducing redundancy by eliminating data duplication
d. Breaking down complex tables into simpler ones
Answer: c. Reducing redundancy by eliminating data duplication
25. Which of the following is a
type of NoSQL database model that stores data as key-value pairs?
a. Document-Oriented
b. Column-Family
c. Graph
d. KeyValue Store
Answer: d. KeyValue Store
26. What is the purpose of the
SQL UPDATE statement in a database query?
a. Retrieving data from the database
b. Inserting new records into the database
c. Updating existing records in the database
d. Deleting records from the database
Answer: c. Updating existing records in the database
27. In a relational database,
what is a view?
a. A virtual table based on the result of a SELECT query
b. A physical storage location for data
c. A unique identifier for a table's records
d. A key used for indexing
Answer: a. A virtual table based on the result of a SELECT query
28. Which of the following is a
disadvantage of using a distributed database system?
a. Improved data availability
b. Increased data security
c. Complex data management and coordination
d. Simplified data recovery
Answer: c. Complex data management and coordination
29. What is the purpose of the
SQL DELETE statement in a database query?
a. Retrieving data from the database
b. Inserting new records into the database
c. Updating existing records in the database
d. Deleting records from the database
Answer: d. Deleting records from the database
30. Which type of database model
represents data as nodes and edges, suitable for representing complex
relationships?
a. Relational Database Model
b. Hierarchical Database Model
c. Document-Oriented Database Model
d. Graph Database Model
Answer: d. Graph Database Model
31. In a relational database,
what is a stored procedure?
a. A query that retrieves data from multiple tables
b. A set of SQL statements that perform a specific task
c. A virtual table based on the result of a SELECT query
d. A unique identifier for a table's records
Answer: b. A set of SQL statements that perform a specific task
32. What is the purpose of the
SQL GROUP BY clause in a database query?
a. Sorting records
b. Filtering records based on a condition
c. Grouping records based on specified columns
d. Joining tables
Answer: c. Grouping records based on specified columns
33. Which of the following is a
benefit of database normalization?
a. Increased redundancy
b. Improved data integrity
c. Reduced data consistency
d. Simplified data retrieval
Answer: b. Improved data integrity
34. In a relational database,
what is the role of a unique constraint?
a. Ensures that each record has a unique identifier
b. Defines relationships between tables
c. Specifies default values for columns
d. Groups related records together
Answer: a. Ensures that each record has a unique identifier
35. What is the purpose of the
SQL HAVING clause in a database query?
a. Sorting records
b. Filtering records based on a condition
c. Grouping records based on specified columns
d. Joining tables
Answer: b. Filtering records based on a condition
36. In a relational database,
what is an attribute?
a. A table
b. A row
c. A column
d. A record
Answer: c. A column
37. What is the role of the
COMMIT statement in database transactions?
a. Initiates a transaction
b. Rolls back a transaction
c. Confirms the changes made in a transaction
d. Aborts the changes made in a transaction
Answer: c. Confirms the changes made in a transaction
38. In the context of database
security, what is the principle of least privilege?
a. Granting users the highest level of privileges
b. Granting users the least amount of privileges necessary
c. Allowing unrestricted access to all users
d. Granting privileges based on seniority
Answer: b. Granting users the least amount of privileges necessary
39. What is the purpose of the
SQL ORDER BY clause in a database query?
a. Filtering records based on a condition
b. Grouping records based on specified columns
c. Sorting records
d. Joining tables
Answer: c. Sorting records
40. Which of the following is a
key feature of a document-oriented NoSQL database?
a. Fixed schema
b. Flexible schema
c. ACID properties
d. Tabular data storage
Answer: b. Flexible schema
41. What is the purpose of the
SQL OUTER JOIN operation in a database query?
a. Combining rows from two or more tables based on a related column
b. Retrieving only the common rows between two tables
c. Including unmatched rows from one table in the result set
d. Grouping records based on specified columns
Answer: c. Including unmatched rows from one table in the result set
42. In a relational database,
what is a candidate key?
a. A key used for encryption
b. A key used for sorting records
c. A unique identifier for a table's records
d. A key that could potentially become a primary key
Answer: d. A key that could potentially become a primary key
43. What is the purpose of the
SQL TRUNCATE statement in a database query?
a. Retrieving data from the database
b. Inserting new records into the database
c. Deleting all records from a table
d. Updating existing records in the database
Answer: c. Deleting all records from a table
44. In a database system, what
does the term "concurrency control" refer to?
a. Ensuring data integrity in transactions
b. Managing multiple transactions concurrently
c. Performing complex queries
d. Creating and altering database tables
Answer: b. Managing multiple transactions concurrently
45. What is the purpose of the
SQL DISTINCT keyword in a SELECT query?
a. Sorting records
b. Filtering records based on a condition
c. Eliminating duplicate values from the result set
d. Joining tables
Answer: c. Eliminating duplicate values from the result set
46. In the context of database
transactions, what is the meaning of the acronym "ACID"?
a. A database query language
b. A set of properties ensuring reliable transactions
c. A database management system
d. A data encryption algorithm
Answer: b. A set of properties ensuring reliable transactions
47. Which of the following is a
type of NoSQL database model that stores data in a table-like structure?
a. Document-Oriented
b. Column-Family
c. KeyValue Store
d. Wide-Column Store
Answer: d. Wide-Column Store
48. What is the purpose of the
SQL UNION operator in a database query?
a. Sorting records
b. Combining rows from two or more tables
c. Filtering records based on a condition
d. Joining tables
Answer: b. Combining rows from two or more tables
49. In a relational database,
what is the role of a foreign key constraint?
a. Ensures that each record has a unique identifier
b. Defines relationships between tables
c. Specifies default values for columns
d. Groups related records together
Answer: b. Defines relationships between tables
50. What is the purpose of the
SQL LIKE operator in a database query?
a. Sorting records
b. Filtering records based on a condition
c. Grouping records based on specified columns
d. Joining tables
Answer: b. Filtering records based on a condition
==========================================================
===========
0 Comments