DBMS Day 4

A top-to-bottom relationship among the items in a database is established by a_____

• Hierarchical schema

• Network schema

• Relational schema

• All of the mentioned

Collections of operations that form a single logical unit of work are called __________

• Views

• Networks

• Units

• Transactions

Execution of translation in isolation preserves the _________ of a database

• Atomicity

• Consistency

• Durability

• All of the mentioned

Which of the following is not a property of a transaction?

• Atomicity

• Simplicity

• Isolation

• Durability

Which of the following properties ensures that a transaction brings the database from one consistent state to another?

• Atomicity

• Consistency

• Isolation

• Durability

Which of the following properties ensures that concurrent execution of transactions does not interfere with each other?

• Atomicity

• Consistency

• Isolation

• Durability

What is a distributed database?

• A database that is stored across multiple physical locations or computer systems.

• A database that is optimized for handling large volumes of data

• A database that uses a hierarchical data model for organizing data.

• A database that is accessed by multiple clients through a server.

In a client-server database architecture, which component is responsible for managing and providing access to the database?

• Client

• Server

• Database management system

• Network