In a table, the fields being recorded are described by each , while each individual record is contained in a .
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.
In relational-model terminology, what is an individual row called? Enter the singular technical term.
A team is documenting a database table. Which description correctly distinguishes its schema from its data?
- A
The saved rows are the schema, and the column definitions are the data.
- B
The table name, column names, and column definitions are the schema; the stored rows are the data.
- C
The column names are the data, and the table name is a row.
- D
The table's schema is the order in which its rows are returned.
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?
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.
A shop needs to store prices as exact decimal numbers. Which type from the material is the most suitable choice?
- A
DECIMAL(p, s)
- B
BOOLEAN
- C
DATE
- D
INTEGER
Which three concepts describe the relational model's structure, as presented in the material? Select all correct choices.
- A
Attributes
- B
Tuples
- C
Domains
- D
Query result order
- E
Table creation statements
A database administrator runs the provided CREATE TABLE statement for Student. Which conclusions are supported? Select all correct choices.
- A
It defines the table's columns and their data types.
- B
It automatically inserts a student row for every column.
- C
It can establish the structure without adding any student rows.
- D
It guarantees that later queries return rows in a fixed order.
A SQL table may contain duplicate rows even though duplicate tuples are not part of the pure mathematical relational model.
- A
True
- B
False
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?
- A
The database must be returning rows in the order they were inserted.
- B
SQL does not promise a particular row order unless the query explicitly sorts the results.
- C
The table's schema has changed.
- D
The rows have become tuples with a different order in the relational model.
In a relational database table, every row follows the same set of column definitions.
- A
True
- B
False
A team moves a database design between database systems. Which statement about SQL data types is supported by the material?
- A
Every database system uses identical type names and features.
- B
Type names and available features can vary among database systems.
- C
A column's type determines the order in which its table's rows are returned.
- D
A SQL type defines the values currently stored in the column.
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.
A database designer specifies the table name Student and defines its columns and their data types. What has the designer specified?
- A
The values in the table's current rows
- B
The table name, its columns, and their definitions
- C
The order in which rows are displayed
- D
The number of records currently stored
A Student table needs to store each student's birth date as a calendar date. Which data type is the most suitable choice?
- A
INTEGER - B
BOOLEAN - C
DATE - D
DECIMAL(8, 2)
Which SQL data type from the material is intended for a column that stores true/false values?
True or false: Unless a query explicitly sorts its results, SQL guarantees that rows will be returned in a particular order.
- A
True
- B
False
In the relational model, what is the term for one row in a relation?
A database runs the material's CREATE TABLE Student statement. What does that operation accomplish?
- A
It defines the table's columns and the kinds of values they accept.
- B
It inserts one row for every column it defines.
- C
It guarantees the order in which future query results appear.
- D
It fills the table with example values for each data type.
When describing a relational attribute, what does its domain specify?
- A
The set of rows currently stored in a table
- B
The name assigned to a relation
- C
The sequence in which columns are displayed
- D
The kinds of values an attribute can contain
Related study packs and tools
2 Digital Logic
A 14-question medium-difficulty quiz on Boolean algebra, logic gates, truth tables, and combinational circuits.
03 — Python Programming Fundamentals
A focused set of flashcards covering Python variables, data types, expressions, control flow, functions, input, output, and common programming practices.
05 — Data Structures: Concepts, Operations, and Trade-Offs
A structured guide to the main data structures, their operations, efficiency trade-offs, representations, and practical selection criteria.
6 Computer Memory
Learn how computer memory stores and addresses information, how RAM and ROM differ, and how caches and the memory hierarchy balance speed, capacity, and cost.
07 Trees and Binary Search Trees
A progressive guide to tree structure, binary-tree traversals, binary search tree operations, deletion, balancing, and the way tree height determines time and space costs.
08 — Discrete Mathematics for Computer Science
A focused review of propositional logic, quantifiers, sets, relations, functions, and foundational proof methods in discrete mathematics for computer science.
Interrupts
Reviews how interrupts support event handling and multitasking, and how Linux system calls use the RISC-V `ecall` instruction and register conventions.
OS Processes
This quiz covers process management, context switching and scheduling, multitasking, traps and interrupts, and RISC-V privilege transitions.
Systemcalls
A quiz on operating-system system calls, including privileged-operation requests, process creation and execution with fork, exec, and waitpid, and signal handling.