A major role of the DBMS in commercial systems is to maintain the database’s integrity by guarding against ___________.

• A) Intentional deletions
• B) Unintentional interactions
• C) Small errors
• D) Complete operations

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

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

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

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

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

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

In JOIN operation, the tuples that do not share common values in attributes W and X __________.

• A) Appear in the final relation
• B) Are excluded from the final relation
• C) Alter the attribute names
• D) Form the new relation

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