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

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) networking
• B) data security
• C) data independence
• D) user access control

What is a queue's characteristic in terms of entry removal?

• A) Sequential access
• B) Random access
• C) First-in, first-out
• D) Last-in, first-out

The naming convention used in JOIN operations ensures __________ for attributes in the new relation.

• A) Uniqueness
• B) Irrelevance
• C) Redundancy
• D) Similarity

What do we call the structures in a tree that consist of a node and the nodes below it?

• A) Leaves
• B) Branches
• C) Subtrees
• D) Roots

In a two-dimensional array, how are positions identified?

• A) Pairs of indices
• B) Field names
• C) Numerical index numbers
• D) same sizes of entries