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 is true?

  1. In Informational coupling, elements of modules are related to each other and are abstracted from real world.

  2. In stamp coupling modules interact through heterogeneous data structure, which include structure, unions, trees, graphs, etc.

  3. In import cohesion, one module is declared in another module for communication.

  4. In temporal cohesion, the elements in a module are related and they perform set of tasks.

  5. In logical cohesion, modules related to each other are used in same phase of program execution.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This statement is true, hence it is the correct answer.

Multiple choice

Which of the following is not correct regarding Data Flow Diagram?

  1. Two external agents in the system cannot be connected directly in a system.

  2. External agent and data store cannot be connected directly in a system.

  3. Two data store can be connected directly in a system.

  4. Data flow diagram are used to show the transformation of information.

  5. All basic notations should be properly connected with data flow then it will leads to specification error.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Two data store cannot be connected to each other therfore it is the correct answer.

Multiple choice

In which of the following classifications of degree of durability, a transaction commits and its commit log record is written to stable storage at the primary and the backup site?

  1. Two-very-safe

  2. One-safe

  3. RAID level 4

  4. Exclusive mode

  5. Detection of failure
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In this classification of degree of durability, a transaction commits and its commits log record is written to stable storage at the primary and the backup site.

Multiple choice

During which of the following phase, recovery manager constructs a sequence of RPCs that instruct the server sessions on the target database to perform the desired operations?

  1. Compilation phase

  2. Execution phase

  3. Shrinking phase

  4. Exclusive mode

  5. Registration
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

During this phase, recovery manager constructs a sequence of RPCs that instruct the server sessions on the target database to perform the desired operations.

Multiple choice

Which of the following services of database in DBMS must furnish a mechanism to ensure that both the data in the database and changes to the data follow certain rules?

  1. Recovery services

  2. Authorization services

  3. Integrity services

  4. Concurrency control services

  5. Transaction support
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

These services of a database in DBMS must furnish a mechanism to ensure that both the data in the database and changes to the data follow certain rules.

Multiple choice

Which of the following views in Three-Schema Architecture of DBMS is the information model of the enterprise that contains the view of the whole enterprise without any concern for the physical implementation?

  1. External view

  2. Conceptual view

  3. Internal view

  4. Users view

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

This view in Three-Schema Architecture of DBMS is the information model of the enterprise that contains the view of the whole enterprise without any concern for the physical implementation.