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 denormalization in the physical model?

Options :

A :

To define relationships between tables

B :

To optimize database performance

C :

To reduce data redundancy and inconsistency

D :

To enforce data integrity constraints

Answer: B

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 defining physical storage structures when mapping a physical model?

Options :

A :

To establish primary and foreign key constraints

B :

To determine the data types for each column

C :

To define relationships between tables

D :

To optimize database access and storage

Answer: D

Question 5

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

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

Buying Options: