Free MTA Database Questions and Answers

Combines columns from different tables

Removes duplicates from a result set

Adds a new row to a table

Deletes rows from a table

Correct! Wrong!

INSERT

UPDATE

SELECT

ALTER

Correct! Wrong!

A field that can be left empty

A field that uniquely identifies each record in a table

A field that refers to data in another table

A field that contains duplicate values

Correct! Wrong!

SELECT

INSERT

UPDATE

DELETE

Correct! Wrong!

Tables that store unstructured data

Data is organized into tables with rows and columns

Hierarchical relationships between data elements

Data stored in flat files

Correct! Wrong!

Premium Tests $49/moFREE October-2024