Database Engine Tuning Advisor

SQL Server Configuration Manager

Database Maintenance Plan Wizard

Database Maintenance design surface

Find the process in System Monitor and select Kill Process.

Find the process in Activity Monitor and select Kill Process.

Find the process in SQL Profiler and select Kill Process.

Find the process in SSRS and select Kill Process.

SQL cannot support object-orientation

The same query can be written in many ways, each with vastly different execution plans.

SQL syntax is too difficult for non-computer professionals to use

SQL creates excessive locks within the database

DPAPI

RSA

Any of the above

None

At least one data mart

Data that can extracted from numerous internal and external sources

Near real-time updates

All of the above.

Data stored in the various operational systems throughout the organization.

Current data intended to be the single source for all decision support systems.

Data stored in one operational system in the organization.

Data that has been selected and formatted for end-user support applications.

Data in which changes to existing records cause the previous version of the records to be eliminated

Data in which changes to existing records do not cause the previous version of the records to be eliminated

Data that are never altered or deleted once they have been added

Data that are never deleted once they have been added

Capturing all of the data contained in various operational systems

Capturing a subset of the data contained in various operational systems

Capturing all of the data contained in various decision support systems

Capturing a subset of the data contained in various decision support systems

A process to reject data from the data warehouse and to create the necessary indexes

A process to load the data in the data warehouse and to create the necessary indexes

A process to upgrade the quality of data after it is moved into a data warehouse

A process to upgrade the quality of data before it is moved into a data warehouse

A process to reject data from the data warehouse and to create the necessary indexes

A process to load the data in the data warehouse and to create the necessary indexes

A process to upgrade the quality of data after it is moved into a data warehouse

A process to upgrade the quality of data before it is moved into a data warehouse

A process to change data from a detailed level to a summary level

A process to change data from a summary level to a detailed level

Joining data from one source into various sources of data

Separating data from one source into various sources of data

Converts data from one field into multiple fields

Converts data from multiple fields into one field

Converts data from multiple fields into multiple fields

All of the above

Many-to-many

One-to-one

One-to-many

All of the above.

Completely demoralized

Partially demoralized

Completely normalized

Partially normalized

Fact

Dimension

Helper

All of the above

To explain some observed event or condition

To confirm that data exists

To analyze data for expected relationships

To create a new data warehouse

Run the AD Relink utility and relink the GL product

Use License Manager, and register the GL product.

Run the "Recreate grants and synonyms for APPS schema" task by using the adadmin utility

Run Autopatch, and apply GL latest available patch

Run Rapid Install to reinstall the database components

DB

ORA

COMN

FND_TOP

APPL_TOP

before performing an export/import

immediately after an upgrade or applying a maintenance pack

converting to multiple organizations or multiple reporting currencies

after a patch or multiple patches are applied

whenever you receive a run-time error that suggests that a problem is caused by the AD_DDL package

There is no one-to-one relationship between schemas and users in a database

the concept of a database schema is directly tied to the concept of a database user, or a grant from the schema owner

The database user and the schema never have the same name

A schema can allow another schema to use its objects by granting access

An Oracle Application products database objects are divided between the product schema and the APPS Schema