MCQ Bank
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
When using PROJECT, if multiple columns are required, they are specified __________.
- A) Separately
- B) Using a comma
- C) Using brackets
- D) Using quotation marks
How do we refer to nodes that have the same parent in a tree?
- A) Descendants
- B) Children
- C) Ancestors
- D) Siblings
In the case of ________that are subject to heavy transaction loads, it is highly likely that a random snapshot will find the database in the middle of some transaction.
- A) object oriented programming
- B) large databases
- C) web development
- D) small database
_________ is used to combine different relations into one relation.
- A) COMBINE
- B) JOIN
- C) PROJECT
- D) SELECT
Retrieving an employee's job history in an object-oriented database involves asking the __________ to report its job history.
- A) employee object
- B) DBMS
- C) manager
- D) network
_________ is exemplified by two transactions, each of which makes a deduction from the same account.
- A) Potential problem
- B) Time sharing
- C) Lost update problem
- D) Incorrect summary problem
What are the keywords used in the syntax for a SELECT operation?
- A) SELECT and FROM
- B) UPDATE and WHERE
- C) JOIN and GROUP BY
- D) INSERT and DELETE
The simplest form of array is the __________array.
- A) one-dimensional
- B) all of above
- C) multi-dimensional
- D) two-dimensional
If a transaction requests exclusive access to an item that is already locked with an exclusive lock, ___________.
- A) The lock is shared with the requesting transaction
- B) The transaction is rolled back
- C) The additional access is denied
- D) The request is granted immediately
What is the colloquial term for the head of a stack?
- A) Top
- B) End
- C) Bottom
- D) Base
In a tree, what is the term for nodes at the other extreme, often called leaf nodes?
- A) Parent nodes
- B) Terminal nodes
- C) Internal nodes
- D) Root nodes
In a stack, what is the term for inserting a new entry at the top?
- A) Removing
- B) Pushing
- C) Dequeuing
- D) Popping
To retrieve information about an employee, we perform ______ operation on the EMPLOYEE relation.
- A) SELECT
- B) DELETE
- C) INSERT
- D) UPDATE
What is the main characteristic of a one-dimensional array?
- A) Varied sizes of entries
- B) Different types of entries
- C) Single row of elements
- D) Multiple rows and columns
What are the items within an aggregate type usually called?
- A) Rows and columns
- B) Fields
- C) Indices
- D) Entries