Question 1

Which keyword is used to retrieve data from specific columns in a SELECT statement?

Options :

A : FROM

B : WHERE

C : SELECT

D : GROUP BY

Answer: C

Question 2

What is the purpose of the COMMIT statement in SQL?

Options :

A :

To delete data from a table

B :

To make permanent changes to the database

C :

To insert data into a table

D :

To update data in a table

Answer: B

Question 3

In a physical data model, what are foreign keys used for?

Options :

A :

To represent the logical structure and properties of database objects.

B :

To improve performance by storing frequently accessed data together.

C :

To define the relationships and links between tables.

D :

To specify the attributes and data types for each table.

Answer: C

Question 4

What is a database?

Options :

A :

A programming language used to manipulate data

B :

A set of tables used for data storage

C :

A collection of data organized in a structured manner

D :

A collection of files stored on a computer

Answer: C

Question 5

Which SQL keyword is used to delete data from a table?

Options :

A :

REMOVE

B :

DROP

C :

DELETE

D :

ERASE

Answer: C

Free 1Z0-006 Mock Exam – Practice Online Confidently

Buying Options: