최신Oracle database 10g:Administration I - 1Z0-042무료샘플문제

A. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).

B. The ADDM analysis provides only the diagnostic information but does not provide recommendations.

C. The ADDM requires at least four AWR snapshots for analysis.

D. The ADDM calls other advisors if required, but does not provide recommendations about the advisors.

E. The ADDM runs after each AWR snapshot is collected.

A. moved the EMPLOYEES table to another location in the same tablespace

B. reorganized the associated indexes for the EMPLOYEES table that were in an unusable state

C. moved the EMPLOYEES table in to a locally managed tablespace

D. moved the indexes associated with the EMPLOYEES table to the same tablespace where the EMPLOYEES table exists

E. analyzed the EMPLOYEES table to collect the current statistics

A. Use the CREATE DATABASE .. command to create the database with Oracle-managed files.

B. Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

C. Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.

D. Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.

E. Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.

A. displays only the list of all advanced parameters

B. displays only the list of default values

C. displays only the list of all basic parameters

D. displays the current contents of the server parameter file

E. displays the currently in effect parameter values

F. displays the list of all the parameter files of a database

A. The database can have only one bigfile tablespace.

B. The bigfile tablespace can be converted to a smallfile tablespace.

C. The bigfile tablespace have only one data file.

D. The segment space management is automatic.

E. The extent management is dictionary managed.

A. configuring the database in ARCHIVELOG mode

B. renaming of data files

C. renaming of control files

D. dropping the database user

E. multiplexing of control files

A. use the external table population

B. use the direct path data load of Oracle export and import utility

C. use the Oracle Data Pump export and import utility

D. use the conventional path data load of SQL*Loader utility

A. Undo data will be retained in the UNDO tablespace for 1,000 seconds, then it gets moved to the TEMPORARY tablespace to provide read consistency.

B. Undo data will be stored permanently after 1,000 seconds.

C. Undo data gets refreshed after every 1,000 seconds.

D. Undo data becomes obsolete after 1,000 seconds.

E. Committed undo data would be retained for 1,000 seconds if free undo space is available.

A. SCHEMAS

B. REMAP_TABLESPACE

C. FULL

D. REMAP_DATAFILES

E. REMAP_SCHEMA

A. SQL*Loader

B. Data Pump

C. Oracle Text

D. Oracle Import

E. External table

A. Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

B. It can be converted to a B-tree index by using the ALTER INDEX command.

C. It has a bitmap segment for each distinct value in the key column, containing a string of bits in which each bit represents the presence or absence of a key column value.

D. It is recommended for the columns that have unique values.