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

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

_________ is used to combine different relations into one relation.

• A) JOIN
• B) SELECT
• C) PROJECT
• D) COMBINE

In a tree, what is the term for nodes at the other extreme, often called leaf nodes?

• A) Internal nodes
• B) Parent nodes
• C) Terminal nodes
• D) Root nodes

What are the items within an aggregate type usually called?

• A) Indices
• B) Fields
• C) Rows and columns
• D) Entries

To obtain information about an employee, the process of selecting the tuple with the appropriate identification attribute value results in a relation with __________ tuple(s).

• A) Single
• B) No
• C) Many
• D) Few

The issue known as ______ might occur if rolling back one transaction affects others and causes a chain reaction.

• A) transaction inconsistency
• B) deadlock
• C) cascading rollback
• D) transaction failure

One of the advantages of separating application software from the DBMS is to achieve __________, allowing changes in the database without modifying the application software.

• A) data independence
• B) networking
• C) data security
• D) user access control

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

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

What are the keywords used in the syntax for a SELECT operation?

• A) JOIN and GROUP BY
• B) UPDATE and WHERE
• C) SELECT and FROM
• D) INSERT and DELETE

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

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

In a queue, where are entries inserted?

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

The end of a list is called the _________.

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

In the context of maintaining employee records, an index is typically used for quick retrieval based on ________.

• A) employee's date of birth
• B) employee's department
• C) employee's name
• D) employee identification numbers

The index for a file is usually stored ________.

• A) separately on a different device
• B) within the RAM
• C) as a part of the main file
• D) as a separate file on the same device

The classic employee file uses _____ to contain information about a single employee in a company.

• A) hash functions
• B) keys
• C) buckets
• D) records

From a perspective, an entire file system in an operating system is like ________.

• A) a randomly arranged file
• B) a single large file
• C) one large indexed file
• D) a fragmented file

Act that gives control over what information websites can collect from kids is:

• A) COPPA
• B) HIPPA
• C) ECPA
• D) Video Privacy Protection

An index for a file contains a list of ________ stored in the file.

• A) data types
• B) file names
• C) directory paths
• D) keys

In hash file, if a disproportionate number of keys happen to hash to the same bucket, it may cause _____.

• A) clustering
• B) faster search
• C) even distribution
• D) efficient retrieval

In the United States the Privacy Act of 1974 was to protect citizens from abusive use of databases:

• A) Agencies
• B) Public
• C) Companies
• D) Government