Advanced SQL Management Simulation Test

Auto audio on: the next questions will be read aloud when you click Continue.

1. 1

   What is the PRIMARY KEY in a relational database?

   A A unique identifier for each record in a table. B An arbitrary chosen column to index. C A composite key combining all fields.
2. 2

   Which SQL clause is used to filter results?

   A SELECT B WHERE C JOIN
3. 3

   What is the function of the UNIQUE constraint?

   A Ensures that all values in a column are different. B Allows duplicate values in a column. C Automatically sets values for a column.
4. 4

   What is a FOREIGN KEY used for?

   A To uniquely identify each record in the table. B To create a unidirectional link between two tables. C To improve query performance.
5. 5

   Which normalization form eliminates transitive dependencies?

   A First Normal Form (1NF) B Second Normal Form (2NF) C Third Normal Form (3NF)
6. 6

   What does the SQL command 'ALTER TABLE' do?

   A Modifies the structure of an existing table. B Deletes rows from a table. C Retrieves data from a table.
7. 7

   What does a JOIN operation do in SQL?

   A Combines rows from two or more tables based on a related column. B Filters data based on specified conditions. C Creates a new table.
8. 8

   What is the purpose of an INDEX in a database?

   A To encrypt data for security. B To speed up retrieval of rows by using a pointer. C To ensure data uniqueness.
9. 9

   Which SQL statement is used to retrieve data from a database?

   A INSERT B UPDATE C SELECT
10. 10

    What does the SQL keyword DISTINCT do?

    A Removes duplicate values from the result set. B Calculates distinct averages of numeric columns. C Creates a new distinct column in a table.