6. Which SQL keyword is used to retrieve data from a database table?
A) SELECT
B) UPDATE
C) DELETE
D) ALTER
Answer: A
7. A database schema defines the:
A) Data types of attributes
B) Operations to be performed on data
C) Constraints on data
D) Structure of the database
Answer: D
8. Which type of relationship connects two tables in a database?
A) Index
B) Join
C) Constraint
D) Trigger
Answer: B
9. Which SQL command is used to add new rows to a database table?
A) ADD
B) INSERT
C) UPDATE
D) CREATE
Answer: B
10. The process of decomposing a table into smaller tables to eliminate data redundancy is called:
A) Normalization
B) Denormalization
C) Indexing
D) Aggregation
Answer: A
