Relational Database Structure and Tables Quiz

Submit

3. What is the difference between a candidate key and a primary key?

A candidate key can be null; a primary key cannot

A candidate key is any key that could be primary; only one is chosen as primary

A candidate key is always composite; a primary key is always single

There is no difference between them

Submit

5. What does a JOIN operation do in SQL?

Combines rows from two or more tables based on related columns

Deletes duplicate rows from a table

Creates a backup of the database

Splits one table into multiple tables

Submit

7. What is an index in a relational database?

A backup copy of the table

A structure that improves query performance by enabling faster data retrieval

A constraint that prevents duplicate values

A column that stores primary keys

8. Which SQL clause is used to retrieve records that meet specific conditions?

JOIN

WHERE

GROUP BY

ORDER BY

Submit

10. What is the main advantage of normalizing a database?

It makes queries run faster

It reduces data redundancy and improves data integrity

It increases the number of tables needed

It eliminates the need for foreign keys

11. What is a primary key in a relational database table?

A column that uniquely identifies each row in the table

The first column in the table

A key used only for sorting data

A column that stores foreign references

12. In relational database design, what does ACID stand for?

Atomicity, Consistency, Isolation, Durability

Analysis, Creation, Implementation, Design

Access, Control, Index, Database

Attribute, Cardinality, Integrity, Definition

13. What is the purpose of the FOREIGN KEY constraint in SQL?

To ensure each row has a unique identifier

To enforce referential integrity between tables

To automatically delete old records

To sort data in ascending order

14. Which of the following best describes a composite key?

A key made of two or more columns combined

A key that references another table

A key that is automatically generated

A key used only for sorting

Submit

16. In a relational database, what is cardinality?

The number of rows in a table

The number of columns in a table

The number of records that can relate between two tables

The data type of a column

17. What does SQL stand for?

Structured Query Language

Standard Question Language

Simple Query Logic

Structured Question Layout

Submit

19. Which normal form eliminates repeating groups and ensures each column contains atomic values?

Second Normal Form (2NF)

First Normal Form (1NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

20. In relational database terminology, what is a tuple?

A column in a table

A row or record in a table

A data type definition

An index structure

Tech+ Relational Database Structure and Tables Quiz

1. A ______ constraint ensures that every value in a column is unique and not null.

2.

What first name or nickname would you like us to use?

2. The process of organizing data to minimize redundancy and improve consistency is called ______.

3. What is the difference between a candidate key and a primary key?

4. In a relational database, a ______ is a named collection of related data organized in rows and columns.

5. What does a JOIN operation do in SQL?

6. Third Normal Form (3NF) eliminates transitive dependencies, meaning non-key attributes depend only on the ______.

7. What is an index in a relational database?

8. Which SQL clause is used to retrieve records that meet specific conditions?

9. In a one-to-many relationship, the 'many' side table contains the ______.

10. What is the main advantage of normalizing a database?

11. What is a primary key in a relational database table?

12. In relational database design, what does ACID stand for?

13. What is the purpose of the FOREIGN KEY constraint in SQL?

14. Which of the following best describes a composite key?

15. A ______ is a set of related tables linked by foreign keys in a relational database.

16. In a relational database, what is cardinality?

17. What does SQL stand for?

18. A foreign key is a column that ______ another table's primary key.

19. Which normal form eliminates repeating groups and ensures each column contains atomic values?

20. In relational database terminology, what is a tuple?