Type your search query and hit enter:
Homepage
(MTA) Microsoft Technology Associate
Free MTA Database Questions and Answers
0%
In SQL, what does the JOIN clause do?
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!
Continue >>
Which of the following is a characteristic of a relational database?
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!
Continue >>
Which SQL statement is used to retrieve data from a database?
SELECT
INSERT
UPDATE
DELETE
Correct!
Wrong!
Continue >>
Which of the following SQL keywords is used to add a new row to a table?
INSERT
UPDATE
SELECT
ALTER
Correct!
Wrong!
Continue >>
What is the primary key in a database table?
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!
Continue >>
Subscribe to updates
Unsubscribe from updates
Related Post
Free MTA Security Questions and Answers
Free MTA Networking Questions and Answers
