Question 1

What is a foreign key in a relational database?

Options :

A : A primary key from another table

B : A key used to establish relationships between tables

C : A key that can have duplicate values

D : A constraint that ensures data integrity

Answer: B

Question 2

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 3

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 4

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

Question 5

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

Smartly Prepare Exam with Free Online 1Z0-006 Practice Test