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 DBMS software modules processes and checks the specification of a database schema in the data definition language and stores that description in the catalog?

  1. Query and DML parser and verifier

  2. Query and DML compilers

  3. DDL compilers

  4. Query and DML optimizer

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

This DBMS software module processes and checks the specification of a database schema in the data definition language and stores that description in the catalog.

Multiple choice

Which of the following properties of database system ensures that even after a transaction is sucessfully complete, the changes it has made to the database persist, even if there are system failures?

  1. Atomicity

  2. Consistency

  3. Isolation

  4. Durability

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

This property of database system ensures that even after a transaction is sucessfully complete, the changes it has made to the database persist even if there are system failures.

Multiple choice

Which of the following types of data partitioning strategy in parallel systems is the one in which one or more attributes from the given relations schema are designated as the partitioning attributes?

  1. Round-robin

  2. Hash partitioning

  3. Range partitioning

  4. Open partitioning

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

This type of data partitioning strategy in parallel systems is the one in which one or more attributes from the given relations schema are designated as the partitioning attributes.

Multiple choice

Which of the following errors in transaction failure is the one in which the system has entered an undesirable state, as a result of which a transaction cannot continue with its normal execution?

  1. Logical error

  2. System crash

  3. System error

  4. Disk failure

  5. Compiler error
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This type of error in transaction failure is the one in which the system has entered an undesirable state as a result of which a transaction cannot continue with its normal execution.

Multiple choice

Which of the following modeling in data warehouses represents business processes within the enterprise and serves as a blueprint for operational database systems?

  1. E-R data modeling

  2. Dimensional modeling

  3. Logical data model

  4. Physical data model

  5. External data model
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This type of modeling in data warehouse represents business processes within the enterprise and serves as a blueprint for operational database systems.

Multiple choice

Which of the following transaction states in DBMS signals that the transaction has ended unsuccessfully and that any changes or effects that the transaction may have applied to the database must be undone?

  1. Begin_Transaction

  2. End_Transaction

  3. Commit_Transaction

  4. Rollback

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

This transaction state in DBMS signals that the transaction has ended unsuccessfully and that any changes or effects that the transaction may have applied to the database must be undone.

Multiple choice

Which of the following is a pair of bibliographic databases?

  1. EMBL and PDB

  2. PDB and Sequin

  3. Embase and EMBL

  4. BioOne and PDB

  5. BioOne and Embase
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

BioOne bibliographic database is an indexed and fully-searchable collection of abstracts that link to the fulltext articles available from the BioOne organization. Embase is a biomedical and pharmacological database containing bibliographic records with citations, abstracts and indexing derived from biomedical articles in peer reviewed journals and is especially strong in its coverage of drug and pharmaceutical research.

Multiple choice

Which of the following terms in DBMS refers to the replacement of relation schema by two or more relational schemas, all of which contain a subset of the attributes of the relation?

  1. Redundancy

  2. Decomposition

  3. Update anomalies

  4. Normalisation

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

This term in DBMS refers to the replacement of the relation schema by two or more relational schemas, all of which contain a subset of the attributes of the relation.

Multiple choice

Which of the following operations in DBMS is the one in which data from the operand relations is read into the main memory and processed in some way out to the disk, and read again from the disk to complete the operation?

  1. NUMA

  2. Scanning tables

  3. Shared disk

  4. Two-pass alogorithm

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

This operation in DBMS is the one in which data from the operand relations is read into the main memory and processed in some way out to disk, and read again from the disk to complete the operation.

Multiple choice

Which of the following forms of parallelism relates to the capacity to break up a query into various parts across various partitions of a partitioned database which may be on one single machine or several machines?

  1. Inter-partition parallelism

  2. Intra-partition parallelism

  3. Shared nothing architecture

  4. Degree of parallelism

  5. Parallel I/O
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This form of parallelism relates to the capacity to break up a query into various parts across various partitions of a partitioned database which may be on one single machine or several machines.