Database Management Exam 2

The SQL command ________ adds one or more new columns to a table.

ALTER TABLE

A command for creating a database is:

CREATE SCHEMA.

What does the following SQL statement do? UPDATE Product_T SET Unit_Price = 775 WHERE Product_ID = 7

Changes the unit price of Product 775

The ________ DBA view shows information about all users of the database in Oracle.

DBA_USERS

________ is a set of commands used to control a database, including security.

DCL

________ is a set of commands used to update and query a database.

DML

The command for removing a table is:

DROP TABLE.

________ takes a value of TRUE if a subquery returns an intermediate results table which contains one or more rows.

Exists

A fact table holds descriptive data about the business.

False

A separate data warehouse causes more contention for resources in an organization.

False

A snowflake schema is usually heavily aggregated.

False

An API is a set of routines that a database server uses to access database objects.

False

COUNT(*) tallies only those rows that contain a value, while COUNT counts all rows.

False

Loss of data integrity does not impact the quality of data in a database.

False

Reconciled data are data that have been selected, formatted, and aggregated for end-user decision support applications.

False

SOX stands for the Sorbet-Oxford Act.

False

The HAVING clause and the WHERE clause perform the same operation.

False

There are two principal types of authorization tables: one for subjects and one for facts.

False

The LAMP stack consists of all of the following EXCEPT:

IIS.

________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved.

Middleware

A client/server configuration that has three layers (one client and two servers) has a three-tier architecture.

True

A dynamic query is created by the user.

True

A pointer is a field of data that can be used to locate a related field or record of data.

True

A procedure is run by calling it by its name.

True

All transactions must have the ACID characteristics.

True

Denormalization almost always leads to more storage space for raw data.

True

In a sequential file, the records are stored in sequence according to a primary key value.

True

The FROM clause is the first statement processed in an SQL command.

True

The following query totals sales for each salesperson. SELECT salesperson_id, sum(sales) FROM salesperson GROUP BY salesperson_id;

True

The ________ operator is used to combine the output from multiple queries into a single result table.

UNION

________ partitioning distributes the columns of a table into several separate physical records.

Vertical

A transaction that terminates abnormally is called a(n) ________ transaction.

aborted

The following code would include: SELECT Customer_T.CustomerID,CustomerName, OrderID FROM Customer_T LEFT OUTER JOIN Order_T ON Customer_T.CustomerID = Order_T.CustomerID;

all rows of the Customer_T Table regardless of matches with the Order_T Table.

A transaction is considered isolated when:

any changes in the database are not revealed to the user until the transaction is complete

A technique using pattern recognition to upgrade the quality of raw data is called:

data scrubbing.

A data mart is a(n):

data warehouse that is limited in scope.

A ________ is a temporary table used in the FROM clause of an SQL query.

derived table

Program-data dependence is caused by:

file descriptions being stored in each database application.

The analysis of data or information to support decision making is called:

informational processing.

A database is an organized collection of ________ related data.

logically

Data that describe the properties of other data are:

metadata.

The most commonly used form of join operation is the:

natural join

While triggers run automatically, ________ do not and have to be called.

routines

A key decision in the physical design process is:

selecting structures.

An expanded version of a star schema in which all of the tables are fully normalized is called a(n):

snowflake schema.

A type of join between three tables is called a(n):

ternary join.

A(n) ________ is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released.

two-phase lock

The major advantage of data propagation is:

real-time cascading of data changes throughout the organization

Data that are detailed, current, and intended to be the single, authoritative source of all decision support applications are called ________ data.

reconciled

A ________ is a DBMS module that restores the database to a correct condition when a failure occurs.

recovery manager