Question 1

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 2

What is a database?

Options :

A : A program that manages data

B : A network of interconnected computers

C : A collection of related data

D : A physical storage device for data

Answer: C

Question 3

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 4

Which SQL keyword is used to delete data from a table?

Options :

A : REMOVE

B : DROP

C : DELETE

D : ERASE

Answer: C

Question 5

What is the difference between a logical model and a physical model in database design?

Options :

A : A logical model is created by developers, while a physical model is created by database administrators.

B : A logical model focuses on performance optimization, while a physical model focuses on data integrity.

C : A logical model represents the database structure in terms of entities and relationships, while a physical model represents the actual implementation of the database.

D : A logical model is used for small-scale databases, while a physical model is used for large-scale databases.

Answer: C