CCP Database Management & Information Systems

Question 1

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

Accepted Answer

To manage and control databases efficiently

Answer

To design computer networks.

Answer

To write code in Java.

Answer

To develop mobile apps.

Question 2

Which language is primarily used for managing data in a relational database?

Accepted Answer

SQL

Answer

HTML

Answer

JavaScript

Answer

Python

Question 3

What is normalization in databases?

Accepted Answer

Organizing data to minimize redundancy

Answer

Combining all data into a single table.

Answer

Deleting unnecessary records.

Answer

Encrypting database tables.

Question 4

Which of the following is a characteristic of relational databases?

Accepted Answer

Data is stored in table structures with defined relationships

Answer

Data is stored in hierarchical files.

Answer

Data is stored in networked objects.

Answer

Data is stored as raw binary blobs.

Question 5

What is the role of an information system in an organization?

Accepted Answer

Support business processes and decision making

Answer

Only store employee records.

Answer

Create social media posts.

Answer

Develop desktop wallpapers.

Question 6

Which component ensures security in a database system?

Accepted Answer

Security module

Answer

Query processor.

Answer

Backup utility.

Answer

Report generator.

Question 7

What is data integrity in a database system?

Accepted Answer

Ensuring data accuracy and consistency

Answer

Duplicating records frequently.

Answer

Using inconsistent formats.

Answer

Allowing unauthorized updates.

Question 8

Which database model is based on objects and classes?

Accepted Answer

Object-oriented model

Answer

Network model

Answer

Hierarchical model

Answer

Relational model

Question 9

What is a primary key in a database table?

Accepted Answer

A field that uniquely identifies each row in a table

Answer

A column used for sorting only.

Answer

A key used for backups.

Answer

A special password.