Introduction to Database Quiz

What is the primary purpose of a Database Management System (DBMS)?

• To manage hardware resources

• To enable users to define, create, maintain, and control access to the database

• To perform manual filing

• To create application programs

Which of the following is NOT a limitation of file-based systems?

• Separation and isolation of data

• Duplication of data

• Data dependence

• Controlled access to data

What does DDL stand for in the context of databases?

• Data Design Language

• Data Distribution Language

• Data Definition Language

• Data Description Language

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

• Writing a letter

• Purchases from the supermarket

• Creating a presentation

• Using a spreadsheet for calculations

What is a key advantage of using a DBMS?

• Limited data sharing

• Higher cost of maintenance

• Improved data accessibility and responsiveness

• Increased complexity

Who is responsible for the management of the data resource in a database environment?

• End-user

• Database Administrator (DBA)

• Application Programmer

• Data Administrator (DA)

Which generation of DBMS focuses on cloud-based and distributed systems?

• Fourth Generation

• First Generation

• Fifth Generation

• Second Generation

What is the main function of a Data Manipulation Language (DML)?

• To manage user access

• To define data structures

• To manipulate data

• To create database schemas

Which of the following roles is concerned with identifying entities and attributes in a database?

• Data Administrator

• Logical Database Designer

• Application Programmer

• Database Administrator

What is a disadvantage of using a DBMS?

• Improved backup and recovery services

• Increased productivity

• Economy of scale

• Higher impact of a failure