[2026] Oracle Upgrade Oracle DBA 11g or 12c to 12c R2

문제1

You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB.
You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:

Where should you execute these statements?

A. All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.

B. All the statements should be executed in the application seed.

C. All the statements should be executed in the application root.

D. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.

E. BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.

정답: C,E

문제2

Which two operations is the opc user authorized to perform in an Oracle Database Cloud environment?
(Choose two.)

A. Run some commands as root.

B. Run all commands as root.

C. Log in to the database deployment compute node.

D. Only run all commands as oracle.

E. Only run some commands as oracle.

정답: B,C

문제3

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

A. They can be created only if shared undo is enabled

B. They require a clone instance to be created when used in a PDB flashback operation

C. They can be created only for a PDB in the mount state

D. They are created as guaranteed restore points

E. They can be created for a PDB when connected to either the PDB or to the root

F. They require backups to be restored when used in a PDB flashback operation

정답: A,C

문제4

Which statement is true about transportable tablespaces?

A. The cannot be dictionary-managed tablespaces

B. The source tablespace can be encrypted

C. They can be administrative tablespaces such as SYSTEM or SYSAUX

D. The tablespace data file or data files to be plugged in to the target database cannot have a different block size than any of the source database's data file or files.

정답: D

문제5

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.
BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with invoker's right.
BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.
When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to update?

A. CUST_RECORDS table in Rlayton's schema

B. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

C. CUST_RECORDS table in Bixby's schema

D. CUST_RECORDS table in Murdok's schema

E. CUST_RECORDS table in the schema of Bixby and Rlayton

정답: A

문제6

Examine these statements executed in the PROD1 database:

Which statements are audited?

A. only the CREATE USER statement

B. only the ALTER SYSTEM statements

C. only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES

D. only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement

E. all the statements

정답: D

문제7

You plan to use Information Lifecycle Management (ILM) for the ORDERS table.
Which is true about Heat Map statistics when HEAT_MAP is ON?

A. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSTEM tablespace.

B. They are collected for all segments and are stored in the SYSAUX tablespace.

C. They are collected only for the ORDERS table if it has an associated ADO policy.

D. They are collected for all segments except for those in the SYSTEM and SYSAUX tablespaces, and are stored in the SYSAUX tablespace.

E. They are collected for all segments and are stored in the SYSTEM tablespace.

정답: E

문제8

From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)

A. loss of ARCHIVELOGS

B. loss of all copies of the control file

C. loss of a redo log member

D. loss of a noncritical data file

E. loss of a critical data file such as SYSTEM, SYSAUX or UNDO

F. loss of SPFILE

정답: B,E

Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z0-074무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트