Database Management System Quiz

List the primary goal of a Database Management System (DBMS).

• To store and retrieve data efficiently

• To develop web pages

• To connect only to hardware devices

• To encrypt network data

Identify the component that ensures data consistency during a system crash.

• Transaction management

• Web server

• Cloud client

• File scanner

Explain why data abstraction is important in DBMS.

• It hides storage details from users

• It increases redundancy

• It slows down performance

• It deletes metadata

Select the view that provides only a partial perspective of the database.

• View level

• Logical level

• Physical level

• Schema level

Name the language used to retrieve and manipulate data in SQL.

• Data Manipulation Language (DML)

• Data Creation Language (DCL)

• Domain Modeling Language

• Dynamic Markup Language

State the type of DML that specifies what data is needed, not how to get it.

• Declarative

• Procedural

• Dynamic

• Imperative

Classify the relational model under the following category.

• Record-based data model

• Object-oriented model

• Semistructured model

• Graph-based model

Compare relational and hierarchical models.

• Relational uses tables; hierarchical uses tree structures

• Both use graph representations

• Relational uses recursion; hierarchical uses views

• Hierarchical supports SQL

Express the meaning of "schema" in a database context.

• Structural design of the database

• A runtime instance of the data

• A record of logs

• A network of disks

Discuss the importance of primary keys in a relational model.

• They uniquely identify tuples

• They provide redundancy

• They replace tables

• They model relationships