Database Management System Quiz

What is a database?

• A collection of unrelated files

• A collection of software programs

• A collection of hardware components

• A collection of related files

Which of the following is NOT a component of DBMS?

• Network

• Software

• Hardware

• Data

What does DDL stand for?

• Data Distribution Language

• Data Development Language

• Data Description Language

• Data Definition Language

Which command is used to retrieve data from the database?

• DELETE

• UPDATE

• SELECT

• INSERT

What is the main advantage of using a DBMS?

• Increased data redundancy

• More complex software

• Improved data consistency

• Higher maintenance costs

Which of the following is a disadvantage of DBMS?

• High initial cost

• Control over concurrency

• Data independence

• Efficient data access

What type of architecture does a two-tier DBMS use?

• Distributed architecture

• Three-tier architecture

• Single-tier architecture

• Client-Server architecture

Which model organizes data into a tree-like structure?

• Network Model

• Hierarchical Model

• Relational Model

• Entity-relationship Model

What is the purpose of a Database Access Language?

• To create hardware components

• To design database architecture

• To write commands for data manipulation

• To manage user accounts

What does a centralized database management system (CDBMS) do?

• Replicates data for backup

• Distributes data across networks

• Stores data in a single location

• Stores data in multiple locations