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;