Computer Knowledge

Database Management Systems

5,344 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 property is not used for field level validation?

  1. Name

  2. Validation Text

  3. Required

  4. Validation Rule

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

In database validation (such as Microsoft Access), Validation Rule defines the criteria, Validation Text displays the error message when the rule is violated, and Required ensures a field cannot be left empty. The Name property is merely an identifier for the field and does not perform any validation function.

Multiple choice

What is the structure of a data base called?

  1. Data Dictionary

  2. Schema

  3. Table

  4. DBMS

  5. Database Abstraction Layer
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Schema is the structure of a database system, described in a formal language supported by the database management system (DBMS). In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables.

Multiple choice

Which of these techniques used in database transactions is also called UNDO/REDO technique?

  1. Deferred update

  2. Immediate update

  3. Rollback

  4. Commit

  5. Phantom reads
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Immediate update also called UNDO/REDO, is also another technique used to recover/support transaction failures that occur due to operating system, power, memory or machine failures. When a transaction runs, any of the updates or alterations made by the transaction are written directly in to the database.

Multiple choice

Which of these properties do not characterize a data warehouse?

  1. Subject Oriented

  2. Integrated

  3. Nonvolatile

  4. Time Invariant

  5. Ad hoc queries
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In order to discover trends in business, analysts need large amounts of data. A data warehouse is time variant. A data warehouse's focus on change over time is what is meant by the term time variant.

Multiple choice

A host language is a _________.

  1. storage definition language

  2. query language

  3. the DML embedded in the general purpose language

  4. always an object oriented language

  5. always a non-procedural language
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A host language is the DML embedded in the general purpose language.