What does a primitive data type in programming languages allow for?

• A) Declaration, allocation, and manipulation of data
• B) Deallocating memory cells for new data
• C) Initializing objects for a class
• D) Storing aggregate data

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

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

A typical database application involves two major layers: the application layer and the __________ management layer.

• A) database
• B) data
• C) user
• D) schema

How are addresses in a machine's main memory encoded and stored?

• A) As a pair of rows and columns
• B) As numeric values
• C) As a 2-dimensional grid
• D) As a cursor

Why is a stack considered a LIFO structure?

• A) Entries are removed in the reverse order of storage
• B) Entries are removed from the base
• C) Entries are removed from the middle
• D) Entries are removed in the order they were stored

The new relation formed after a JOIN operation has attributes named by prefixing them with the __________.

• A) First letter
• B) Relation of its origin
• C) Arbitrary numbers
• D) Original relation

How is the depth of a tree defined?

• A) The number of top nodes in the tree
• B) The number of only first horizontal layer within the tree
• C) The number of only leaf nodes in the tree
• D) The number of nodes from root to leaf in the tree

In a tree structure, what is the top node called?

• A) Parent node
• B) Terminal node
• C) Leaf node
• D) Root node

An object-oriented database consists of objects linked to each other to reflect their __________.

• A) attributes
• B) relationships
• C) sizes
• D) colors

The process used by the DBMS to undo activities performed by an incomplete transaction is termed ______.

• A) rewind
• B) rollback
• C) revert
• D) restore

In the context of data structures, what is the primary use of pointers?

• A) To record the location of data items
• B) To serve as a counter in loops
• C) To store string data type
• D) To delete instructions

Operations that are only partially completed in commercial systems might lead to ___________ information in the database.

• A) Valid
• B) Incomplete
• C) Verified
• D) Accurate

Shared access to a data item means that ___________.

• A) Multiple transactions can modify the data
• B) Only one transaction can modify the data
• C) Only one transaction can view the data
• D) Multiple transactions can view the data

The PROJECT operation allows extraction of columns and places the result in a __________.

• A) New row
• B) Existing column
• C) New relation
• D) Matrix

The end of a list is called the _________.

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

Shared access to a data item is allowed if the item is ___________.

• A) Locked with an exclusive lock
• B) Exclusively accessed by one transaction
• C) Locked with a shared lock only
• D) Unlocked or locked with a shared lock

What is the beginning of a list called?

• A) Tail
• B) Base
• C) Head
• D) Top

Large, multiuser, commercial database systems have __________ stakes compared to personal use systems.

• A) Higher
• B) Identical
• C) Lower
• D) Comparable

The following statement extracts __________ from the EMPLOYEE relation. MAIL <- PROJECT Name, Address from EMPLOYEE

• A) Phone numbers
• B) Names and Addresses
• C) Addresses only
• D) Names only

A subschema pertains to ______.

• A) a particular user's needs
• B) primary records
• C) external information
• D) the entire database