Database Midterm Spring 2022
column
A _____ is a collection of values that are of the same type.
set
A _____ is a collection of values with no inherent order.
primary key
A column, or group of columns, that serves as the unique identifier in a relational database table is called a/an _____.
schema
A database _____ is the implementation of database requirements in SQL with CREATE TABLE statements.
Unique identification of individual rows in the table
A database administrator creates a new relational database, and a primary key is assigned within a table to assist with governing data. What does the administrator accomplish with this structural rule?
A consolidated view of specific data without changing the underlying database structure.
A view table provides which benefit when created in a database with multiple tables?
Preventing multiple transactions with the same data at the same time.
How does a database system protect data when concurrent transactions occur?
The successful query results are reversed, and the transaction is canceled.
If a database system is processing three queries as part of a transaction and the third query fails, what happens to the transaction?
Left table
In the SQL query below, the Teacher table is the _____. SELECT LastName, FirstName, CourseTitle FROM Teacher INNER JOIN Class ON Teacher.TeacherID = Class.TeacherID;
second
Redundancy is possible in a _____ normal form table when one non-key column depends on another non-key column.
EmployeeLastName
The EmployeeWorkspace table has a composite key of (EmployeeID, WorkspaceID). WorkHours depends on (EmployeeID, WorkspaceID), and EmployeeLastName depends on EmployeeID. Which column must be removed so EmployeeWorkspace is in second normal form?
SELECT
The _____ SQL statement does not alter any database data.
The base table primary key is not included in the view table.
What causes the generation of a NULL primary key value when using a view in an INSERT statement?
BLOB
What data type stores binary values?
query language
What does a user that interacts with a database use to read and write data?
Table
What is the result of a relational operation?
API
What links a host programming language to a database system?
materialized view, base table
When a database stores view data, it uses a _____ that depends on data in a corresponding _____.
format
When data is produced and stored as numeric, textual, or visual information, it varies in _____.
DECIMAL
When using a SQL statement to create a table, which data type is used to store a fractional value?
Programmer
Which role focuses on creating software that interacts with a database?
Foreign key referring to a foreign key in the same table
Which statement is not a special case of foreign keys?
Equijoin
Which type of join does the SQL query below? SELECT LastName, FirstName, CourseTitle FROM Teacher INNER JOIN Class ON Teacher.TeacherID = Class.TeacherID;