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

문제1

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

문제2

You want to partition the SALES table on the CITY and SALE_DATE columns.
Which three partitioning methods can you use? (Choose three.)

A. list

B. range

C. interval

D. virtual column-based

E. hash

정답: A,B,E

문제3

The In-Memory compression level is set to MEMCOMPRESS FOR QUERY HIGH.
For what purpose is this optimized?

A. for query performance and space saving

B. for space saving only

C. for parallel query performance only

D. for query performance only

E. for query performance and space saving with greater bias toward space saving

정답: A

문제4

Examine this command:

Which statement is true?

A. Four worker processes are allocated when there is sufficient CPU available

B. Four worker processes are allocated to export data and metadata

C. Up to four worker processes are allocated to export data and metadata

D. Four worker processes are active to export only metadata

E. Four worker processes are allocated to export only data

정답: B

문제5

The TESTDB container database (CDB) running in ARCHIVELOG mode contains two pluggable databases (PDBs) PDB1 and PDB2.
A connect descriptor for TESTDB is mapped to the TNS alias testdb in tnsnames.ora.
The default RMAN configuration is used.
Examine these commands:

Which files are backed up?

A. all root and PDB1 data files, and the CONTROLFILE and SPFILE

B. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and ARCHIVELOGS

C. all root and PDB1 data files

D. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and FLASHBACKLOGS

E. all root and PDB1 data files, and the CONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS

정답: C

문제6

In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to
'/u01/app/oracle/oradata'.
CDB1 has an application container called REGIONS_APP.
There are no seeds for REGIONS_APP and there are no other application containers.
You plan to execute this command.
CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123; What must you do for the command to execute successfully?

A. Set the PDB_FILE_NAME_CONVERT parameter to '/u01/app/oracle/oradata'

B. Set the current container to REGIONS_APP

C. Add the FILE_NAME_CONVERT clause to the command

D. Add the CREATE_FILE_DEST clause to the command

E. Set the current container to CDB1

정답: A

문제7

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 enabling tracing for sessions that run these queries

B. by viewing Active Reports for that time period

C. by enabling SQL trace for each query

D. by running the Automatic Workload Repository (AWR) report for that time period

E. by running the Active Session History (ASH) report for that time period

정답: A

문제8

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

A. number of CPUs

B. amount of RAM

C. number of database instances

D. number of storage LUNs

E. number of network interface cards (NICs)

정답: A,B

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

우리와 연락하기

유용한 링크

최신 업데이트