Free MTA Database Questions and Answers

Question 1

What is the primary key in a database table?

Accepted Answer

A field that uniquely identifies each record in a table

Answer

A field that can be left empty

Answer

A field that refers to data in another table

Answer

A field that contains duplicate values

Question 2

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

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 3

Which of the following is a characteristic of a relational database?

Accepted Answer

Data is organized into tables with rows and columns

Answer

Tables that store unstructured data

Answer

Hierarchical relationships between data elements

Answer

Data stored in flat files

Question 4

In SQL, what does the JOIN clause do?

Accepted Answer

Combines columns from different tables

Answer

Removes duplicates from a result set

Answer

Adds a new row to a table

Answer

Deletes rows from a table

Question 5

Which of the following SQL keywords is used to add a new row to a table?

Accepted Answer

INSERT

Answer

UPDATE

Answer

SELECT

Answer

ALTER