Database systems emerged as a means of ___________ the information stored in organizations.

• A) Restricting
• B) Separating
• C) Integrating
• D) Duplicating

How are fields in an aggregate type usually accessed?

• A) Row and column numbers
• B) Field names
• C) Numerical index numbers
• D) Pairs of indices

What is the beginning of a list called?

• A) Base
• B) Top
• C) Tail
• D) Head

In a database, information is accessible from ___________.

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

In a two-dimensional array, how are positions identified?

• A) Numerical index numbers
• B) Pairs of indices
• C) Field names
• D) same sizes of entries

The protocol that ensures older transactions are given priority when accessing locked items is called the ___________ protocol.

• A) Priority inversion
• B) Deadlock avoidance
• C) Young-Old transaction
• D) Wound wait

When using PROJECT, if multiple columns are required, they are specified __________.

• A) Using quotation marks
• B) Using brackets
• C) Using a comma
• D) Separately

What does a primitive data type in programming languages allow for?

• A) Storing aggregate data
• B) Deallocating memory cells for new data
• C) Declaration, allocation, and manipulation of data
• D) Initializing objects for a class

The naming convention used in JOIN operations ensures __________ for attributes in the new relation.

• A) Redundancy
• B) Uniqueness
• C) Similarity
• D) Irrelevance

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