DBMS Concepts Quiz

Which of the following is a characteristic of a Database Management System (DBMS)?

• A) Provides concurrent access to data

• B) Stores data in a file system without any structure

• C) Does not support data security

• D) Uses a flat file format for data storage

Which of the following is NOT a type of database user?

• A) Database administrator

• B) Database programmer

• C) Database designer

• D) Database compiler

Which type of data can be stored in a relational database?

• A) Structured data only

• B) Semi-structured data only

• C) Unstructured data only

• D) Structured, semi-structured, and unstructured data

Which of the following is a major advantage of using a DBMS?

• A) Data redundancy is reduced

• B) Data retrieval speed is reduced

• C) It does not allow concurrent access to the database

• D) Data integrity is compromised

Which data model is used to represent data in a hierarchical structure with parent-child relationships?

• A) Relational model

• B) Network model

• C) Hierarchical model

• D) Object-oriented model

The Three Schema Architecture consists of which of the following levels?

• A) Internal, conceptual, and external

• B) Physical, conceptual, and logical

• C) External, logical, and physical

• D) Conceptual, logical, and external

Which of the following is true about the 'Schema' in DBMS?

• A) A schema is a set of data values in a table

• B) Schema defines the structure of the database

• C) Schema only applies to relational databases

• D) A schema is a collection of all the files in the system

Which of the following best defines a 'database language'?

• A) A programming language for controlling hardware

• B) A language used for retrieving and manipulating data

• C) A language for creating database backups

• D) A language used to define the operating system structure

Which of the following is an example of a Data Definition Language (DDL) command?

• A) SELECT

• B) INSERT

• C) CREATE

• D) UPDATE

Which of the following best describes a 'relational DBMS'?

• A) A DBMS that uses tables to represent data

• B) A DBMS that uses trees for data storage

• C) A DBMS that stores data in files

• D) A DBMS that stores data as objects