Computer Knowledge

Database Management Systems

5,543 Questions

Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.

E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database

Database Management Systems Questions

Multiple choice

Which of the following applications of distributed database is the one that reduces the amount of data transfer required between sites, when a transaction retrieves data from remote tables referenced in a distributed SQL statement?

  1. Location transparency

  2. Remote procedure calls

  3. Distributed query optimization

  4. Replication transparency

  5. System change number
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This application of distributed database is the one that reduces the amount of data transfer required between sites when a transaction retrieves data from remote tables referenced in a distributed SQL statement.

Multiple choice

Which of the following databases is the one in which idea of distribution of the data is considered and hierarchical approach in administration of data like Global administrator is incorporated?

  1. Centralized database

  2. Distributed database

  3. Duplicate database

  4. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This kind of database, having idea of distribution of the data, is considered and hierarchical approach in administration of data like Global administrator is incorporated.

Multiple choice

Which of the following schemes in distributed database management consists of locks that has one copy of each data item privilged and lock all the copies so that conflicts are discovered at the site where the primary copy resides?

  1. Primary copy locking

  2. Read - Write locks

  3. Majority locking

  4. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Primary copy locking is one that has one copy of each data item privilged and lock all the copies so that conflicts are discovered at the site where the primary copy resides.

Multiple choice

Which of the following is the first phase in distributed transaction where the Global Coordinator, asks participating nodes other than the commit point site to promise to commit or roll back the transaction, even if there is a failure?

  1. Commit phase

  2. Forget phase

  3. Prepare phase

  4. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the first phase in distributed transaction where the Global Coordinator, asks participating nodes other than the commit point site to promise to commit or roll back the transaction, even if there is a failure.