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

In an organization chart-like tree, what does each node represent?

• A) Manager
• B) Position
• C) Employee
• D) Department

How are fields in an aggregate type usually accessed?

• A) Field names
• B) Pairs of indices
• C) Row and column numbers
• D) Numerical index numbers

What is another name for a program counter in the context of CPUs?

• A) Code counter
• B) Instruction pointer
• C) Index counter
• D) Numeric register

In a two-dimensional array, what does the second index in a pair identify?

• A) Column associated with the position
• B) Field name
• C) Numerical index number
• D) Row associated with the position

What could best describe the application of a one-dimensional array with 26 elements?

• A) Managing skill ratings and reviews of employee data
• B) Representing monthly sales and profit
• C) Storing student data
• D) Tracking alphabet letter occurrences

A transaction requiring exclusive access will ___________.

• A) Grant shared access to other transactions
• B) Be forced to wait if the item is already exclusively locked
• C) Share the access with other transactions
• D) Automatically gain access without checks