2026년 1z0-074 시험 준비 중 궁금한 점이 생기면 언제든 문의해 주시기 바랍니다. KoreaDumps은 Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 관련 상담을 한국어로 지원하며 연습문제 75문항의 이용 방법도 안내해 드립니다.

Oracle 1z0-074 시험 개요:

Oracle 1z0-074 시험 요강 주제:

Oracle Upgrade Oracle DBA 11g or 12c to 12c R2에 대해 알아야 할 모든 것

최신 Oracle Database 12c R2 1z0-074 무료샘플문제

문제 #1

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

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

문제 #2

The ORCL CDB has a PDB, ORCL_PDB.
Examine these parameters in ORCL:

Examine these parameters in ORCL_PDB:

You switch to ORCL_PDB and plan to execute these commands:

What will be the outcome?

A. SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to
200M in ORCL.
B. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.
C. SGA_TARGET is set to 600M.The other values remain unchanged in both ORCL and ORCL_PDB.
D. Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.SGA_TARGET size is changed to 600 M.
E. SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD

문제 #3

In which three situations would you recommend DB Replay to be used? (Choose three.)

A. to check the impact of upgrading and patching databases
B. to check the impact of new optimizer statistics
C. to check the impact of schema changes such as adding new indexes or materialized views
D. to check the impact of partitioning a table
E. to check the impact of changing the storage system or the network
F. to check the impact of database migration to the cloud

문제 #4

Which two statements are true about a PDB lockdown profile? (Choose two.)

A. It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.
B. It is enabled by default on creation.
C. It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.
D. It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.
E. It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.
F. It is created by a common user with the SYSDBA privilege in CDB$ROOT.

문제 #5

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

A. clustered tables with dependent materialized views
B. heap tables with dependent materialized views
C. heap tables with composite primary key constraints
D. sys-owned objects stored in sysaux-defined tablespaces
E. index-organized tables stored in system-defined tablespaces

질문과 대답: