Question 1

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 2

What is a primary key in a relational database?

Options :

A :

A constraint that ensures data integrity

B :

A unique identifier for each record in a table

C :

A field that can have multiple values

D :

A foreign key that points to another table

Answer: B

Question 3

Which keyword is used to join two or more tables in a SQL statement?

Options :

A : JOIN

B :

INNER JOIN

C :

CROSS JOIN

D :

UNION

Answer: A

Question 4

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 5

Which SQL statement is used to add a new column to an existing table?

Options :

A :

DELETE FROM

B : UPDATE

C :

ALTER TABLE

D :

INSERT INTO

Answer: C

Higher Test Marks with Free Online 1Z0-006 Exam Practice

Buying Options: