One of the advantages of separating application software from the DBMS is to achieve __________, allowing changes in the database without modifying the application software.

• A) networking
• B) data security
• C) data independence
• D) user access control

What is a queue's characteristic in terms of entry removal?

• A) Sequential access
• B) Random access
• C) First-in, first-out
• D) Last-in, first-out

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

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

What do we call the structures in a tree that consist of a node and the nodes below it?

• A) Leaves
• B) Branches
• C) Subtrees
• D) Roots

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

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

In an organization chart-like tree, what does each node represent?

• A) Manager
• B) Position
• C) Employee
• D) Department

How are fields in an aggregate type usually accessed?

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

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

In a two-dimensional array, what does the second index in a pair identify?

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

What could best describe the application of a one-dimensional array with 26 elements?

• A) Managing skill ratings and reviews of employee data
• B) Representing monthly sales and profit
• C) Storing student data
• D) Tracking alphabet letter occurrences

A transaction requiring exclusive access will ___________.

• A) Grant shared access to other transactions
• B) Be forced to wait if the item is already exclusively locked
• C) Share the access with other transactions
• D) Automatically gain access without checks

The format in which information is displayed by spreadsheet programs is similar to the format used in the ________.

• A) Hierarchical model
• B) Network model
• C) Object-oriented model
• D) Relational model

To obtain information about an employee, the process of selecting the tuple with the appropriate identification attribute value results in a relation with __________ tuple(s).

• A) Many
• B) No
• C) Few
• D) Single

Today, database technology, combined with _________ techniques,

• A) opening mining
• B) text mining
• C) data mining
• D) Sentiment analysis

In a list, what is the opposite end of the head called?

• A) End
• B) Base
• C) Bottom
• D) Tail

The node at the top is called the _______ node.

• A) terminal
• B) siblings
• C) root
• D) head

Database technology, combined with data mining techniques, is an important ___________ tool.

• A) Communication
• B) Data storage
• C) Financial
• D) Decision-making

In a database, information is accessible from ___________.

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

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

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

What does a tree structure's hierarchical organization resemble?

• A) Stack
• B) Array
• C) Graph
• D) Organization chart