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
  1. Dominant entity

  2. Derived entity

  3. Subordinate entity

  4. Composite entity

  5. None of these

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This is the correct answer. There is no particular reason to explain this answer, because there is a name convention in DBMS. The members of strong entity set are called dominant entity set.So this is the correct answer.

Multiple choice
  1. RDBMS (Relational Database Management System) stores the data in tabular form.

  2. DBMS (Database Management System) does not follow normalization.

  3. RDBMS does not support client server architecture.

  4. All of the above.

  5. Only (1) and (2) are true

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Yes, all the three are the true statements.

Multiple choice
  1. Durability

  2. Atomicity

  3. Serializability

  4. Isolation

  5. Concurrency

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This property of transaction management requires that if a transaction is interrupted by a failure its partial results are not at all taken into consideration and the whole operation has to be repeated.

Multiple choice
  1. Oracle flashback database

  2. Incrementally updated backups

  3. Flash recovery area

  4. Disk topology and automatic performance tuning

  5. Automatic datafile creation

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is an area or automatic storage management disk group that serves as the default storage area for files related to recovery.

Multiple choice
  1. Recovery catalog database

  2. Standby database

  3. Duplicate database

  4. Media management application

  5. Recovery catalog schema

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This component of Recovery Manager is a copy of the primary database that is updated using archived logs created by the primary database.