Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 出題範圍廣、題型靈活，是不少考生心中的硬骨頭。Fast2test 的 1z0-074 題庫以 75 道模擬試題帶您熟悉出題邏輯，一題一題累積實力，逐步建立應考信心。

Oracle 1z0-074 考試概覽:

Oracle 1z0-074 考試大綱主題:

關於 Oracle 1z0-074 考試，您可能想問

最新的 Oracle Database 12c R2 1z0-074 免費考試真題：

問題 #1

You receive complaints about poor performance in an Oracle 12c database while long running queries execute.
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution.
How would you achieve this?

A. by viewing Active Reports for that time period
B. by running the Active Session History (ASH) report for that time period
C. by running the Automatic Workload Repository (AWR) report for that time period
D. by enabling tracing for sessions that run these queries
E. by enabling SQL trace for each query

問題 #2

Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

A. any SYS owned objects
B. index-organized tables
C. subpartitions
D. heap tables
E. materialized views
F. clustered tables

問題 #3

Examine these commands executed in the cdb1 container database:

Which statement is true about the c##USER1 account?

A. It is locked after for consecutive failed login attempts.
B. It is locked for 90 minutes after four failed login attempts.
C. It is locked if the password is not changed within three weeks.
D. It is not affected by the profile because the user has the SYSDBA privilege.
E. It is locked for two days after the password expires.

問題 #4

QUERY_REWRITE_INTEGRITY and QUERY_REWRITE_ENABLED are set to TRUSTED and TRUE respectively in an Oracle 12c Release 2 database.
You create the SALES_EVAL real-time materialized view (MV) on the SALES, CUSTOMERS, and PRODUCTS tables, which supports COMPLETE REFRESH by executing these statements.

There is a constraint on the PRODUCTS table with ENABLE, NOVALIDATE, and RELY attributes.
No updates have been done to SALES, CUSTOMERS, or PRODUCTS since the MV was created.
From where are rows returned and why?

A. from the SALES_EVAL MV because the QUERY_REWRITE_ENABLED setting permits rewrites on unverified constraints if the table is not stale
B. from the SALES, CUSTOMERS, and PRODUCTS tables because the columns used in the SELECT list are different from the SALES_EVAL MV definition
C. from the SALES, CUSTOMERS, and PRODUCTS tables because the column in the GROUP BY clause is different from the SALES_EVAL MV definition
D. from the SALES_EVAL MV because the WHERE clause in the query and in the SALES_EVAL definition are the same
E. from the SALES, CUSTOMERS, and PRODUCTS tables because QUERY_REWRITE_INTEGRITY is set to TRUSTED

問題 #5

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It always executes triggers that are fired recursively in FULLDML mode.
B. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).
C. It generates execution plans for each SQL statement in an STS.
D. It recommends the creation of indexes for regressed SQL statements.
E. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

問題與答案：