Computer Knowledge

Database Management Systems

5,344 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 is not a database?

  1. Ms-word

  2. File maker program

  3. Ms-Access

  4. Oracle
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

MS-Word is a word processing application, not a database management system. Oracle, MS-Access, and FileMaker are all database software.

Multiple choice

Which of the following recovery techniques that recovers from non-catastropic transaction failure, is the one that do not physically update the database on disk, until a transaction reaches its commit point?

  1. System log

  2. Deferred update

  3. Immediate update

  4. Rollback

  5. Savpoint
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is a recovery technique that recovers from non-catastropic transaction failure is the one that do not physically update the database on disk, until a transaction reaches its commit point.

Multiple choice

Which of the following operations of recovery manager signals a successful end of the transaction, So that any changes executed by the transaction can be safely committed to the database?

  1. Begin_Transaction

  2. Read or Write

  3. End_Transaction

  4. Commit_Transaction

  5. Rollback
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

This operation of recovery manager signals a successful end of the transaction, so that any changes executed by the transaction can be safely committed to the database.

Multiple choice

Which of the following functions in a distributed database environment is the ability to access remote sites and transmit queries, and data among the various sites via a communication network?

  1. Keeping track of data.

  2. Distributed transaction management.

  3. Distributed query processing.

  4. Replicated data management.

  5. Distributed data recovery.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This function in a distributed database environment is the ability to access remote sites and transmit queries, and data among the various sites via a communication network.

Multiple choice

Which of the following features of Oracle Open Gateways provides access to a non-Oracle database from an oracle server, is a procedural system like a messaging or a queuing system that is accessed by Oracle using PL/SQL remote procedure calls?

  1. Distributed transactions

  2. Global Query Optimisation

  3. Procedural Access

  4. Transparent SQL access

  5. Key Constraints
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This feature of Oracle Open Gateways that provides access to a non-Oracle database, from an Oracle server is a procedural systems like messaging or queuing systems that are accessed by Oracle using PL/SQL remote procedure calls.