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

  2. password

  3. documentation

  4. record lock

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

Record locking is a concurrency control mechanism that prevents conflicting simultaneous updates to the same database record. When one user acquires a lock on a record, other users must wait until the lock is released before they can modify that record. This prevents lost updates and ensures data integrity in multi-user database environments.

Multiple choice
  1. fields and columns

  2. rows and columns

  3. rows and cells

  4. none of the above

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

In relational database terminology, a table is organized as rows (also called tuples or records) and columns (also called attributes or fields). Each row represents a single complete entity or record, while each column represents a specific attribute or field that all records possess. This two-dimensional structure is the foundation of relational databases.

Multiple choice
  1. Caching

  2. Stratification

  3. Temporary intercession

  4. Function proxy

  5. NIO

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

In this technique, it would not be necessary to connect to the remote server next time that the document is requested, because it stores the retrieved document in a local file.

Multiple choice
  1. File processing

  2. Database

  3. Front-end-processor

  4. Direct processing

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

File processing refers to the systematic manipulation of data files, including updating a master file with new transaction data. This ensures that the permanent records (master files) accurately reflect the current state of the business or system.

Multiple choice
  1. Data acquisition

  2. Data bank

  3. Database system

  4. Database

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

A data bank is a large repository of information on a specific subject, often compiled from multiple sources. While the term database is more common in modern technical contexts, data bank specifically emphasizes the collection of data for a particular topic or field. Data acquisition refers to the process of gathering data, not the storage itself.

Multiple choice
  1. Vertical fragmentation

  2. Horizontal partitioning

  3. Summary data

  4. Duplicate data

  5. Functional dependency

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

This is the technique used for denormalisation in which the records are summarised in some summary columns. It reduces the number of records stored in a table.

Multiple choice
  1. Object database

  2. Dimensional

  3. Post-relational database

  4. Network data

  5. Hierarchical data

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

This model is a specialised adaption of the relational model. It is used to represent data in a data warehouse in a way that data can be easily summarised using OLAP queries.