DBMS MCQ QUESTIONS MODEL PAPER – 5

 =========================================================== ===========

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

 

========================================================== ===========

Post a Comment

0 Comments