DBMS Theory and Query Questions

Which of the following is not a characteristic of a DBMS?

• Data Redundancy Control

• Data Security and Integrity

• Data Visualization

• Concurrent Access Management

What is the main purpose of a Transaction Log in DBMS?

• To store a backup of the database

• To maintain a history of all queries

• To ensure recoverability in case of failure

• To optimize query execution

Which of the following is true about a primary key?

• It can have duplicate values

• It uniquely identifies a record

• It can be null

• It is used for defining relationships only

In DBMS, which of the following is an ACID property of a transaction?

• Abstraction

• Consistency

• Incrementality

• Dependency

What does a foreign key represent in a relational database?

• A unique identifier for each table

• A link between two tables

• The main index of a table

• A duplicate entry in a table

How would you find the total number of rows in a table?

• SELECT COUNT(*) FROM table;

• SELECT TOTAL FROM table;

• SELECT SUM(*) FROM table;

• SELECT NUMBER(*) FROM table;

Which of the following is an example of a DBMS?

• MySQL

• Microsoft Excel

• Notepad

• Python

Which of the following is not a database model?

• Hierarchical

• Network

• Relational

• Object-Oriented Programming

What is a deadlock in DBMS?

• When a database is overloaded

• When two transactions wait for each other indefinitely

• When a transaction is completed successfully

• When the system crashes during a transaction

What does the term 'schema' refer to in a database?

• The actual data stored in the database

• The structure of the database

• The process of backing up data

• A table in the database