Timedora
Free Practice Quiz Question List

Relational Tables, Keys, and Constraints Online Quiz Questions

Use this free practice quiz with 20 questions to review Relational Tables, Keys, and Constraints, test your knowledge, and prepare for your next test or exam.

20 questions
01
Choose one
1 point

A quantity column must contain only nonnegative values. Which constraint can enforce this rule?

  1. A

    NOT NULL

  2. B

    CHECK

  3. C

    UNIQUE

  4. D

    PRIMARY KEY

02
Choose all
1 point

Select all statements that correctly describe the structure of a relational table.

  1. A

    A row represents one record or instance.

  2. B

    A cell represents an entire attribute shared by all records.

  3. C

    A column describes an attribute.

  4. D

    The schema defines a table’s columns.

03
True or false
1 point

An associative table can connect records from two tables to represent a many-to-many relationship.

  1. A

    True

  2. B

    False

04
Written response
1 point

What type of key is a minimal set of columns that uniquely identifies each row, before one is chosen as the table’s main identifier?

05
Fill in the blank
1 point

An integer data type provides a basic domain of .

06
Open ended
1 point

Explain what a row, column, and cell represent in a relational table, and describe what the schema defines.

07
Choose one
1 point

Which description defines a table’s primary key?

  1. A

    A foreign key

  2. B

    Any column containing text

  3. C

    A candidate key chosen as the table’s main identifier

  4. D

    A set of columns that may contain duplicate values

08
Choose all
1 point

Select all statements that correctly describe associative tables and relationships between tables.

  1. A

    An associative table can connect records from two tables.

  2. B

    A combined primary key can limit each related pair to one row.

  3. C

    A one-to-many relationship is represented by putting a foreign key on the “one” side.

  4. D

    An associative table can represent a many-to-many relationship.

09
True or false
1 point

A UNIQUE constraint can disallow repeated values in a column.

  1. A

    True

  2. B

    False

10
Written response
1 point

What is the term for the value at the intersection of a row and a column?

11
Fill in the blank
1 point

A table that connects records from two other tables and can store facts about their connection is called an .

12
Choose one
1 point

A table has a minimal column set that uniquely identifies every row. The database designer chooses this candidate key as the table’s main identifier. What is it called?

  1. A

    A foreign key

  2. B

    A primary key

  3. C

    A candidate key

  4. D

    A domain

13
True or false
1 point

An associative table connecting students and courses can represent a many-to-many relationship in which a student may take many courses and a course may have many students.

  1. A

    True

  2. B

    False

14
Written response
1 point

What is the term for the definition that specifies a table’s columns?

15
Choose one
1 point

Which description defines a candidate key?

  1. A

    A minimal set of columns that uniquely identifies each row

  2. B

    Any column that contains a value in every row

  3. C

    A column whose values refer to a key in another table

  4. D

    The candidate key selected as the table’s main identifier

16
Written response
1 point

Each course belongs to one department, and a department may have multiple courses. According to this one-to-many design, which table holds the department foreign key?

17
Choose one
1 point

What is the value at the intersection of a table row and a table column called?

  1. A

    A schema

  2. B

    A domain

  3. C

    A cell

  4. D

    A key

18
Choose one
1 point

Which database constraint can enforce a condition such as requiring a quantity to be nonnegative?

  1. A

    NOT NULL

  2. B

    UNIQUE

  3. C

    A data type

  4. D

    CHECK

19
Choose one
1 point

Which statement correctly describes the structure of a relational table?

  1. A

    Columns represent records, rows represent attributes, and the schema changes whenever a row is added.

  2. B

    Columns describe attributes and are defined in the schema; rows represent records and have no guaranteed order.

  3. C

    Each row represents a column, and the schema specifies the order in which rows must appear.

  4. D

    The schema stores the values at row-column intersections, while columns represent individual records.

20
Choose one
1 point

A table has a candidate key that is selected as its main identifier. Which kind of key is it, and what must be true of its values?

  1. A

    A foreign key, because it can refer to a key in another table.

  2. B

    A candidate key, because every candidate key is automatically the table’s chosen main identifier.

  3. C

    A primary key, because it is the candidate key chosen as the main identifier and must be unique and not null.

  4. D

    A domain, because it is the set of valid values for an attribute.