Database Systems Quiz

Which of the following is NOT a purpose of a database system?

• Data redundancy

• Data integrity

• Data inconsistency

• Data sharing

Which of these best describes a database?

• Collection of unrelated data

• Collection of programs

• Collection of data that can be processed manually

• Organized collection of related data

Which of the following is an example of a database application?

• MS Word

• Railway reservation system

• Photoshop

• Windows OS

Which application domain commonly uses real-time database systems?

• Social Media

• Banking

• Air traffic control

• Blogging

Which of the following is NOT a level in the three-level schema architecture?

• External level

• Conceptual level

• Internal level

• Physical level

What does the external level of a database system describe?

• Logical structure

• Physical storage

• User views

• Metadata

Which database language is used for defining the database schema?

• DML

• DCL

• DDL

• TCL

Which SQL command is used to retrieve data from a database?

• INSERT

• DELETE

• SELECT

• UPDATE

Which of the following components manages disk storage?

• Query processor

• Storage manager

• DDL compiler

• DML compiler

The software component that interprets and executes SQL queries is called:

• Buffer manager

• Transaction manager

• Query processor

• Compiler