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

1. What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?

A) information stored inside a data dictionary table
B) information stored in the ALERT.LOG file for the corresponding instance
C) the filename format
D) information stored inside the corresponding initialization parameter file for the instance

2. Which two can be obtained from the summary advisor? (Choose two.)

A) summary space requirements
B) summary refresh plan
C) summary accounting
D) summary recommendations

3. Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS (2> ownname => 'OE', 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 4> method_opt => 'for all columns size AUTO');
What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?

A) The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
B) The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.
C) The Oracle server creates a histogram based on data distribution and application usage of the column/s for all table, column, and index statistics for the OE schema.
D) The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

4. The Oracle9i LogMiner needs a data dictionary copy to display the object names.
From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)

A) separate supplemental log file
B) information in the control file
C) redo information stored within the redo vectors of the DML operation
D) the current online data dictionary
E) a Data Dictionary copy stored in an operating system flat file
F) a Data Dictionary copy stored in the redo log file

5. What is one benefit of using the ALTER TABLE ... MOVE command rather than a CREATE TABLE ... AS SELECT command?

A) all operations, such as INSERT, UPDATE, DELETE, and SELECT can be performed while the operation completes.
B) index definitions are retained.
C) duplicate space is not required while the command executes.
D) row chaining is eliminated.

質問と回答：