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 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.

Multiple choice

Which of the following recovery mechanisms must ensure that the before image (BFIM) of the data item is recorded in the appropriate log entry, and that the log entry is flushed to disk before the BFIM is overwritten with the after image (AFIM) in the database on disk?

  1. Page Table

  2. Segmentation

  3. Overlays

  4. Write-ahead logging

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

This is a recovery mechanism which must ensure that the before image (BFIM) of the data item is recorded in the appropriate log entry, and that the log entry is flushed to disk before the BFIM is overwritten with the after image (AFIM) in the database on disk.

Multiple choice

Which of the following data storage components in DBMS ensures that the database remains in a consistent state despite system failures, and that concurrent transaction executions proceed without conflicting?

  1. Authorisation and Integrity manager

  2. File manager

  3. Buffer manager

  4. Transaction manager

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

This data storage component in DBMS ensures that the database remains in a consistent state despite system failures and that concurrent transaction executions proceed without conflicting.