1z1-062 考試一旦沒通過，報名費就得再繳一次，重考成本不容小覷。與其事後補救，不如先用 Fast2test 的 Oracle Database 12c: Installation and Administration 練習題充分演練，把 380 道題目練熟練透再上場。

Oracle 1z1-062 考試概覽:

Oracle 1z1-062 考試大綱主題:

1z1-062 考試熱門問答集

最新的 Oracle Database 1z1-062 免費考試真題：

問題 #1

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.

A. Missing or stale histogram statistics
B. High clustering factor for the indexes
C. Undersized shared pool
D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
E. Oversized buffer cache

問題 #2

Identify two situations in which the alert log file is updated.

A. Inserting a value into a table returns ORA-01722: invalid number.
B. Creating a table returns ORA-00955: name us already in used by an existing objects.
C. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.
D. Running a query on a table returns ORA-600: Internal Error.
E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

問題 #3

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

A. usage of the AUDIT statement
B. creation of a fine-grained audit policy
C. configuration of unified auditing mode
D. execution of SQL statements by users connected with the SYSDBA privilege

問題 #4

Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

A. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
B. Only DDL commands that resulted in the creation of new segments are logged.
C. All DDL commands are logged in the alert log file.
D. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
E. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.

問題 #5

You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions? (Choose two.)

A. Enable Flashback Data Archiving for the tables that require tracking.
B. Create a Flashback Data Archive in the tablespace where the tables are stored.
C. Enable supplemental logging for the database.
D. Create a Flashback Data Archive in any suitable tablespace.
E. Specify undo retention guarantee for the database.

問題與答案：