MCQ Bank
Database technology, combined with data mining techniques, is an important ___________ tool.
- A) Data storage
- B) Decision-making
- C) Communication
- D) Financial
In an organization chart-like tree, what does each node represent?
- A) Position
- B) Department
- C) Employee
- D) Manager
A subschema pertains to ______.
- A) primary records
- B) a particular user's needs
- C) the entire database
- D) external information
An array is a “________” block of data whose entries are of the same type.
- A) square
- B) triangle
- C) rectangular
- D) oval
How do we refer to nodes that have the same parent in a tree?
- A) Siblings
- B) Ancestors
- C) Children
- D) Descendants
The node at the top is called the _______ node.
- A) terminal
- B) head
- C) root
- D) siblings
The resulting relation after a select operation contains tuples that ____________ the specified condition.
- A) violate
- B) match
- C) ignore
- D) modify
In a stack, what is the term for inserting a new entry at the top?
- A) Popping
- B) Pushing
- C) Dequeuing
- D) Removing
What is a queue's characteristic in terms of entry removal?
- A) Sequential access
- B) Last-in, first-out
- C) First-in, first-out
- D) Random access
How is the depth of a tree defined?
- A) The number of only first horizontal layer within the tree
- B) The number of top nodes in the tree
- C) The number of nodes from root to leaf in the tree
- D) The number of only leaf nodes in the tree
If a transaction requests exclusive access to an item that is already locked with an exclusive lock, ___________.
- A) The request is granted immediately
- B) The additional access is denied
- C) The lock is shared with the requesting transaction
- D) The transaction is rolled back
A schema describes the ______ database structure used by the database software.
- A) complete
- B) external
- C) partial
- D) secondary
The new relation formed after a JOIN operation has attributes named by prefixing them with the __________.
- A) Original relation
- B) Relation of its origin
- C) First letter
- D) Arbitrary numbers
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) Unlocked or locked with a shared lock
- D) Locked with a shared lock only
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 with entries removed only at the tail
- D) A list of sounds recorded on a CD
How are addresses in a machine's main memory encoded and stored?
- A) As a 2-dimensional grid
- B) As a pair of rows and columns
- C) As numeric values
- D) As a cursor
What is the colloquial term for the head of a stack?
- A) Base
- B) End
- C) Top
- D) Bottom
Retrieving an employee's job history in an object-oriented database involves asking the __________ to report its job history.
- A) employee object
- B) manager
- C) DBMS
- D) network
The simplest form of array is the __________array.
- A) two-dimensional
- B) multi-dimensional
- C) one-dimensional
- D) all of above
In a list, what is the opposite end of the head called?
- A) Base
- B) Bottom
- C) Tail
- D) End