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

The format in which information is displayed by spreadsheet programs is similar to the format used in the ________.

• A) Hierarchical model
• B) Network model
• C) Object-oriented model
• D) Relational model

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) Many
• B) No
• C) Few
• D) Single

Today, database technology, combined with _________ techniques,

• A) opening mining
• B) text mining
• C) data mining
• D) Sentiment analysis

In a list, what is the opposite end of the head called?

• A) End
• B) Base
• C) Bottom
• D) Tail

The node at the top is called the _______ node.

• A) terminal
• B) siblings
• C) root
• D) head

Database technology, combined with data mining techniques, is an important ___________ tool.

• A) Communication
• B) Data storage
• C) Financial
• D) Decision-making

In a database, information is accessible from ___________.

• A) One perspective only
• B) A variety of perspectives
• C) A single dimension
• D) Limited viewpoints

The syntax used to perform the select operation in creating a new relation is represented as ____________.

• A) SELECT NEW <- from
• B) from NEW <- SELECT
• C) NEW <- SELECT from
• D) NEW <- from SELECT

What does a tree structure's hierarchical organization resemble?

• A) Stack
• B) Array
• C) Graph
• D) Organization chart

In an array, what does the first index in a pair identify?

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

Persistent objects in a database are distinct from transient objects because they are __________.

• A) discarded after program termination
• B) linked to other objects
• C) created during program execution
• D) saved after program termination

American throws away pieces of paper each year which is equal to:

• A) 1 billion trees
• B) 2.5 billion trees
• C) 2 billion trees
• D) 1.5 billion trees

The conversion from key values to bucket numbers in hashing is done by a ____________.

• A) retrieval function
• B) hash function
• C) sorting function
• D) search function

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

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