DBMS MCQ

1. What is the primary function of a Relational Database Management System (RDBMS) such as Oracle or MySQL? A) Managing data storage on physical disksB) … Read more

1. What is the primary purpose of concurrency control in database management systems? a) To ensure consistency and isolation of transactionsb) To maximize throughput and … Read more

1. What is a transaction system?a) A system for handling financial transactions onlyb) A system for managing database operations that ensures ACID propertiesc) A system … Read more

1. What is normalization in database design? a) Organizing data in random orderb) Structuring data to eliminate redundancy and dependencyc) Adding random data to the … Read more

1. What is a tuple in a relational data model?a) A column in a tableb) A row in a tablec) A unique identifier in a … Read more

1. What is the primary difference between a database approach and a traditional file accessing approach?a) Database approach provides centralized data storage, while traditional approach … Read more