Question 1

Which keyword is used to filter results based on a specific condition in a SELECT statement?

Options :

A :

ORDER BY

B :

HAVING

C :

GROUP BY

D :

WHERE

Answer: D

Question 2

Which SQL statement is used to create a new table?

Options :

A : UPDATE

B :

INSERT INTO

C :

DELETE FROM

D :

CREATE TABLE

Answer: D

Question 3

What is a primary key?

Options :

A :

An attribute that can have multiple values

B :

A reserved word in SQL

C :

A unique identifier for a data entity

D :

A foreign key in a related table

Answer: C

Question 4

What is the purpose of denormalization in a physical model?

Options :

A :

To establish primary and foreign key relationships

B :

To enforce data integrity

C :

To improve data retrieval performance

D :

To eliminate all redundancy in the database

Answer: C

Question 5

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

Free 1Z0-006 Mock Exam – Practice Online Confidently

Buying Options: