Q. In a multiuser database environment, what is a deadlock?
A.
A situation where two transactions are waiting for each other to release locks
B.
A method of data encryption
C.
A type of database backup
D.
A way to optimize queries
Show solution
Solution
A deadlock occurs when two transactions are waiting for each other to release locks, preventing both from proceeding.
Correct Answer:
A
— A situation where two transactions are waiting for each other to release locks
Learn More →
Q. In a multiuser database environment, what is a potential problem that can arise?
A.
Data redundancy
B.
Data inconsistency
C.
Data isolation
D.
Data normalization
Show solution
Solution
Data inconsistency can arise in a multiuser database environment when multiple users update the same data simultaneously.
Correct Answer:
B
— Data inconsistency
Learn More →
Q. In a multiuser database environment, what is the role of a DBMS?
A.
To manage user interfaces
B.
To provide data storage and retrieval services
C.
To perform data analysis
D.
To create reports
Show solution
Solution
The primary role of a DBMS in a multiuser environment is to manage data storage and retrieval services efficiently.
Correct Answer:
B
— To provide data storage and retrieval services
Learn More →
Q. What does the term 'concurrency control' refer to in a database system?
A.
Managing multiple database connections
B.
Ensuring data consistency during simultaneous transactions
C.
Optimizing query performance
D.
Backing up data regularly
Show solution
Solution
Concurrency control refers to the management of simultaneous operations on a database without conflicting, ensuring data consistency.
Correct Answer:
B
— Ensuring data consistency during simultaneous transactions
Learn More →
Q. What is the primary purpose of normalization in a database?
A.
To increase data redundancy
B.
To eliminate data anomalies
C.
To improve query performance
D.
To simplify database design
Show solution
Solution
Normalization is used to eliminate data anomalies and ensure data integrity by organizing data into related tables.
Correct Answer:
B
— To eliminate data anomalies
Learn More →
Q. What is the role of a database management system (DBMS)?
A.
To create hardware for data storage
B.
To manage data and provide an interface for users
C.
To perform data analysis only
D.
To ensure data is stored in a non-volatile manner
Show solution
Solution
A DBMS manages data and provides an interface for users to interact with the database.
Correct Answer:
B
— To manage data and provide an interface for users
Learn More →
Q. Which of the following is a common method for implementing concurrency control?
A.
Two-phase locking
B.
Data replication
C.
Partitioning
D.
Sharding
Show solution
Solution
Two-phase locking is a common method for implementing concurrency control to prevent conflicts between transactions.
Correct Answer:
A
— Two-phase locking
Learn More →
Q. Which of the following is NOT a property of transactions in the ACID model?
A.
Atomicity
B.
Consistency
C.
Isolation
D.
Durability
Show solution
Solution
All options listed are properties of transactions in the ACID model; however, the question asks for the one that is NOT a property, which is incorrect.
Correct Answer:
D
— Durability
Learn More →
Q. Which SQL statement is used to update existing records in a table?
A.
MODIFY
B.
UPDATE
C.
CHANGE
D.
SET
Show solution
Solution
The UPDATE statement is used to modify existing records in a table.
Correct Answer:
B
— UPDATE
Learn More →
Showing 1 to 9 of 9 (1 Pages)
