Data Processing Database Management Systems

Question 1

What does DBMS stand for?

Accepted Answer

Database Management System

Answer

DBMS stands for Database Management System, software that enables users to define, create, maintain, and control access to a database.

Question 2

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

Accepted Answer

SELECT

Answer

The SELECT statement is used in SQL to query and retrieve data from one or more tables in a relational database.

Question 3

What is a primary key in a relational database?

Accepted Answer

A unique identifier for each record in a table

Answer

A primary key is a column or set of columns whose values uniquely identify each row in a database table.

Question 4

Which normal form eliminates partial dependencies in a relational database?

Accepted Answer

Second Normal Form (2NF)

Answer

Second Normal Form (2NF) requires that every non-key attribute is fully functionally dependent on the entire primary key, eliminating partial dependencies.

Question 5

What is the role of an index in a database?

Accepted Answer

To speed up data retrieval operations on a table

Answer

A database index is a data structure that improves the speed of data retrieval by providing quick access paths to rows in a table.

Data Processing Practice Test

Data Processing Practice Test

Data Processing Database Management Systems