Data Processing Database Management Systems

Question 1

What does DBMS stand for?

Accepted Answer

Database Management System

Answer

Data Backup Management Service

Answer

Digital Binary Memory Storage

Answer

Distributed Buffer Management System

Question 2

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

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 3

What is a primary key in a relational database?

Accepted Answer

A unique identifier for each record in a table

Answer

The first column in every table

Answer

A field that stores encrypted passwords

Answer

A link between two databases

Question 4

Which normal form eliminates partial dependencies in a relational database?

Accepted Answer

Second Normal Form (2NF)

Answer

First Normal Form (1NF)

Answer

Third Normal Form (3NF)

Answer

Boyce-Codd Normal Form (BCNF)

Question 5

What is the role of an index in a database?

Accepted Answer

To speed up data retrieval operations on a table

Answer

To store backup copies of data

Answer

To encrypt sensitive columns

Answer

To define access permissions for users

Question 6

What does the SQL JOIN clause do?

Accepted Answer

Combines rows from two or more tables based on a related column

Answer

Deletes records from multiple tables at once

Answer

Sorts data in descending order

Answer

Converts data types between columns