MCQ Bank
What term is used for a tree in which each parent has no more than two children?
- A) Trinary tree
- B) Binary tree
- C) Ternary tree
- D) Quaternary tree
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
The process used by the DBMS to undo activities performed by an incomplete transaction is termed ______.
- A) restore
- B) rewind
- C) rollback
- D) revert
To control access to information within a database, database systems often rely on ______ and ______.
- A) queries, reports
- B) schemas, subschemas
- C) keys, indexes
- D) records, tables
In a stack, what is the term for removing an entry from the top?
- A) Popping
- B) Dequeuing
- C) Removing
- D) Pushing
The SELECT operation extracts ________ from a relation.
- A) a cell
- B) columns
- C) rows
- D) table
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