Oracle9i dba new features for Oracle7.3 and Oracle9 ocps 認定 1Z0-035 試験問題:

1. What do you need to do in order for the Database Resource Manager to estimate, in advance, the execution time of a statement?

A) Gather optimizer statistics on related objects.
B) Set the TIMED_STATISTICS initialization parameter.
C) Nothing
D) Set the TIMED_OS_STATISTICS initialization parameter.

2. When should you delete rows from a partition before dropping it?

A) when a table contains only one partition
B) when only a few global indexes are defined on the table
C) when many global indexes are defined on the table
D) when many local indexes are defined on the table

3. What statement is true about taking a database default temporary tablespace offline?

A) You cannot take a default temporary tablespace offline.
B) You must ensure that all users are assigned to an alternative temporary tablespace first.
C) The database must be quiesced before you perform this action.
D) You must first ensure that the default temporary tablespace has the permanent tablespace characteristic.

4. A switchover to a standby database differs from a failover to the standby in a number of ways. What are two of the key differences that characterize a switchover? (Choose two.)

A) The primary and standby database must be using exactly the same release and patch level of Oracle9i.
B) The standby database must be running in a no data divergence mode.
C) The old primary database can take on the standby role and be available for a future switchover.
D) The operation is planned and causes no data loss.
E) Either the primary database's online or archived log files, but not necessarily both, must be available.

5. Click the Exhibit button and examine the extract from a SQL*Plus session.
Assuming that there is at least one row for each value shown in the HIGH_VALUE column, what is the result of the ALTER TABLE statement?

A) The REGION_SOUTH_EAST partition will contain only rows with a NULL value in the current
REGION_EAST partition.
B) Rows with partitioning keys in the current REGION_EAST partition not included in the VALUES clause will be stored in the REGION_SOUTH_EAST partition.
C) The REGION_SOUTH_EAST partition will be created in the TBS2 tablespace.
D) The REGION_SOUTH_EAST partition will be created with storage characteristics inherited from the LOCATIONS table.
E) The statement will fail because no values are supplied for REGION_SOUTH_EAST partition keys.

質問と回答：