Question 1

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 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 the role of database indexes in mapping a physical model?

Options :

A : To optimize database access and retrieval

B : To define relationships between tables

C : To ensure data integrity

D : To determine the data types for each column

Answer: A

Question 4

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 5

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