Timedora
Free Practice Quiz Question List

1 Relational Database Foundations Online Quiz Questions

Use this free practice quiz with 20 questions to review 1 Relational Database Foundations, test your knowledge, and prepare for your next test or exam.

20 questions
01
Fill in the blank
1 point

In a table, the fields being recorded are described by each , while each individual record is contained in a .

02
Written response
1 point

In relational-model terminology, what is an individual row called? Enter the singular technical term.

03
Choose one
1 point

A team is documenting a database table. Which description correctly distinguishes its schema from its data?

  1. A

    The saved rows are the schema, and the column definitions are the data.

  2. B

    The table name, column names, and column definitions are the schema; the stored rows are the data.

  3. C

    The column names are the data, and the table name is a row.

  4. D

    The table's schema is the order in which its rows are returned.

04
Fill in the blank
1 point

A column stores only whether a task is complete or not complete, using true/false values. Which SQL type from the material fits that column?

05
Written response
1 point

A column should represent calendar dates as dates rather than arbitrary text. Which SQL type named in the material is suitable? Enter the SQL type name.

06
Choose one
1 point

A shop needs to store prices as exact decimal numbers. Which type from the material is the most suitable choice?

  1. A

    DECIMAL(p, s)

  2. B

    BOOLEAN

  3. C

    DATE

  4. D

    INTEGER

07
Choose all
1 point

Which three concepts describe the relational model's structure, as presented in the material? Select all correct choices.

  1. A

    Attributes

  2. B

    Tuples

  3. C

    Domains

  4. D

    Query result order

  5. E

    Table creation statements

08
Choose all
1 point

A database administrator runs the provided CREATE TABLE statement for Student. Which conclusions are supported? Select all correct choices.

  1. A

    It defines the table's columns and their data types.

  2. B

    It automatically inserts a student row for every column.

  3. C

    It can establish the structure without adding any student rows.

  4. D

    It guarantees that later queries return rows in a fixed order.

09
True or false
1 point

A SQL table may contain duplicate rows even though duplicate tuples are not part of the pure mathematical relational model.

  1. A

    True

  2. B

    False

10
Choose one
1 point

A query without an explicit sort returns rows in a different order on two occasions, although the stored data has not changed. Which explanation is consistent with the material?

  1. A

    The database must be returning rows in the order they were inserted.

  2. B

    SQL does not promise a particular row order unless the query explicitly sorts the results.

  3. C

    The table's schema has changed.

  4. D

    The rows have become tuples with a different order in the relational model.

11
True or false
1 point

In a relational database table, every row follows the same set of column definitions.

  1. A

    True

  2. B

    False

12
Choose one
1 point

A team moves a database design between database systems. Which statement about SQL data types is supported by the material?

  1. A

    Every database system uses identical type names and features.

  2. B

    Type names and available features can vary among database systems.

  3. C

    A column's type determines the order in which its table's rows are returned.

  4. D

    A SQL type defines the values currently stored in the column.

13
Open ended
1 point

A library needs a table for a book's copy count, title, publication date, and whether it is currently available. Propose a column and a suitable SQL type from the material for each field. Then explain what a CREATE TABLE definition establishes and whether it adds existing book records.

14
Choose one
1 point

A database designer specifies the table name Student and defines its columns and their data types. What has the designer specified?

  1. A

    The values in the table's current rows

  2. B

    The table name, its columns, and their definitions

  3. C

    The order in which rows are displayed

  4. D

    The number of records currently stored

15
Choose one
1 point

A Student table needs to store each student's birth date as a calendar date. Which data type is the most suitable choice?

  1. A

    INTEGER

  2. B

    BOOLEAN

  3. C

    DATE

  4. D

    DECIMAL(8, 2)

16
Written response
1 point

Which SQL data type from the material is intended for a column that stores true/false values?

17
True or false
1 point

True or false: Unless a query explicitly sorts its results, SQL guarantees that rows will be returned in a particular order.

  1. A

    True

  2. B

    False

18
Written response
1 point

In the relational model, what is the term for one row in a relation?

19
Choose one
1 point

A database runs the material's CREATE TABLE Student statement. What does that operation accomplish?

  1. A

    It defines the table's columns and the kinds of values they accept.

  2. B

    It inserts one row for every column it defines.

  3. C

    It guarantees the order in which future query results appear.

  4. D

    It fills the table with example values for each data type.

20
Choose one
1 point

When describing a relational attribute, what does its domain specify?

  1. A

    The set of rows currently stored in a table

  2. B

    The name assigned to a relation

  3. C

    The sequence in which columns are displayed

  4. D

    The kinds of values an attribute can contain