A schema describes the ______ database structure used by the database software.

• A) complete
• B) partial
• C) secondary
• D) external

In case of an equipment malfunction, the DBMS uses the log to reconstruct ______.

• A) only incomplete transactions
• B) completed transactions since the last backup
• C) non-committed transactions
• D) the entire database from scratch

Retrieving a list of job titles in a specific department involves selecting tuples based on the __________ attribute.

• A) Job title
• B) Relation
• C) Department
• D) Employee ID

In a queue, where are entries inserted?

• A) At the head
• B) At the tail
• C) At the base
• D) At the top

The protocol that ensures older transactions are given priority when accessing locked items is called the ___________ protocol.

• A) Young-Old transaction
• B) Deadlock avoidance
• C) Priority inversion
• D) Wound wait

Database systems emerged as a means of ___________ the information stored in organizations.

• A) Integrating
• B) Duplicating
• C) Restricting
• D) Separating

A __________ is a description of the entire database structure that is used by the database software to maintain the database.

• A) superschema
• B) subschema
• C) nonschema
• D) schema

If we seek the JobTitle column within a relation named NEW1, the expression would be: SELECT _____ FROM NEW1;

• A) EmployeeID
• B) JobTitle
• C) Salary
• D) Department

What is a stack in the context of data structures?

• A) A list with entries arranged sequentially
• B) A list with entries inserted and removed only at the head
• C) A list of sounds recorded on a CD
• D) A list with entries removed only at the tail

To control access to information within a database, database systems often rely on ______ and ______.

• A) queries, reports
• B) keys, indexes
• C) records, tables
• D) schemas, subschemas

A major role of the DBMS in commercial systems is to maintain the database’s integrity by guarding against ___________.

• A) Intentional deletions
• B) Unintentional interactions
• C) Small errors
• D) Complete operations

An array is a “________” block of data whose entries are of the same type.

• A) rectangular
• B) triangle
• C) oval
• D) square

The beginning of a list is called the _______ of the list.

• A) devon
• B) bob
• C) head
• D) tail

In a stack, what is the term for removing an entry from the top?

• A) Pushing
• B) Popping
• C) Removing
• D) Dequeuing

Changes in the database schema for a single user involve modifying the overall schema and the subschemas of __________ users involved in the change.

• A) new
• B) other
• C) selected
• D) all

In JOIN operation, the tuples that do not share common values in attributes W and X __________.

• A) Alter the attribute names
• B) Appear in the final relation
• C) Form the new relation
• D) Are excluded from the final relation

The problem known as the ____________ can arise if one transaction is in the middle of transferring funds from one account to another when another transaction tries to compute the total deposits in the bank.

• A) potential problem
• B) time sharing
• C) incorrect summary problem
• D) lost update problem

The two common types of locks in a locking protocol are ___________ and ___________ locks.

• A) Read, Write
• B) Shared, Exclusive
• C) Primary, Secondary
• D) Static, Dynamic

Subschemas are crucial in providing ______ to different users within a database.

• A) identical information
• B) similar access
• C) universal access
• D) restricted access

The relational model portrays data as being stored in tables called ________.

• A) Entities
• B) Graphs
• C) Records
• D) Relations