Oracle9i dba new features for Oracle7.3 and Oracle9 ocps - 1Z0-035무료 덤프문제 풀어보기

A. only the EMPLOYEES table

B. the EMPLOYEES table and partition P1

C. the EMPLOYEES table, IPK_EMP index, and the SALES table

D. only the EMPLOYEES table and its corresponding primary key index

A. It may be set too high because there are many more multipass work area executions than one pass executions.

B. You cannot conclude anything because these statistics are not related to the PGA_AGGREGATE_TARGET parameter.

C. It may be set too low because there are many more multipass work area executions than one pass executions.

D. It is probably at its optimal setting because the ratio of one pass to multipass work area executions is below 0.10 (ten percent).

A. They should be written to disk by the sending instance and read from disk by the receiving instance.

B. They should be transferred through the cache area of the Global Resource Directory on the instance where the block is mastered.

C. They should be transferred across a high-speed cluster interconnect.

D. They should be granted, by the Global Cache Service, an exclusive mode resource for each instance involved.

A. replaces bad blocks by substituting good blocks

B. does only a recovery of the specified blocks

C. uses the DBMS_REPAIR package to fix block corruptions

D. does a restore and a recovery of the specified blocks

A. You must define a foreign key constraint.

B. You need to partition one of the tables on their join keys.

C. You need to hash-partitioned both tables on their join keys.

D. You need to equipartition both tables on their join keys.

A. You must use Oracle predefined names to identify raw partitions that will hold OMF structures.

B. You must define directories for two online redo log groups and three copies of the control file.

C. If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.

D. You must use only OMF data files when adding new tablespaces or data files to your database in the future.

A. Either the primary database's online or archived log files, but not necessarily both, must be available.

B. The primary and standby database must be using exactly the same release and patch level of Oracle9i.

C. The operation is planned and causes no data loss.

D. The standby database must be running in a no data divergence mode.

E. The old primary database can take on the standby role and be available for a future switchover.

A. Import

B. Metadata API

C. Direct path export

D. ORACLE LOADER

A. the primary database is protected against data loss and data divergence

B. the primary database is protected against write operations

C. the standby database is protected against write operations

D. the standby database is protected against data loss and data divergence

A. Execute the DBMS_STATS.GATHER_SYSTEM_STATS procedure with appropriate values

B. Unset the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE.

C. Set the instance parameters SORT_AREA_SIZE, BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE, HASH_AREA_SIZE, SORT_AREA_SIZE, and SORT_AREA_RETAINED_SIZE all to AUTO.

D. Set the instance parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY to appropriate values.