Oracle 1z0-067 : Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

시험 문제는 시시각각 바뀌고, 학습 자료도 그에 맞춰 달라져야 합니다. ITDumpsKR은 1z0-067 연습문제 265문항을 2026년 최신 경향에 맞춰 수시로 업데이트하고 있습니다. 구매 후 365일 동안은 업데이트를 무료로 받아보실 수 있습니다.

Oracle 1z0-067 시험 개요:

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

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP 궁금증 총정리

최신 OCP 1z0-067 무료샘플문제

문제 #1

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database 11g catalog schema owned by the rc11 user.
A database with dbid=1423241 is registered in the catdb11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
$rman
RKAN> CONNECT CATALOG rc12c/pass12c@catdb12c
RKAN> IMPORT CATALOG rc11/pwdcat11@catdb11 DBID=1423241;
What is the outcome of the import?

A. It fails because RMAN is not connected to the target database with DBID=1423241
B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
C. It fails because the target database and recovery catalog database are of different versions.
D. It succeeds but the database is not automatically registered in the RC12C catalog.

문제 #2

In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

A. The statement will fail because you cannot rename an undo tablespace.
B. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.
C. The tablespace will be renamed and all the changes will be logged in the alert log.
D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.
E. The tablespace will be renamed but the data file headers will not be updated.

문제 #3

Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid :=
DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true?

A. Only DML and DDL statements will be monitored for the session.
B. All subsequent statements in the session will be treated as one database operation and will be monitored.
C. Database operations will be monitored only when they consume a significant amount of resource.
D. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
E. Database operations for all sessions will be monitored.

문제 #4

You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)

A. Temporary undo reduces the amount of undo stored in undo tablespaces
B. Performance improves because less redo is written to the redo log
C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache
D. Performance improves because no redo and undo are generated for the temporary tables

문제 #5

Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

A. The compatible initialization parameter is set to 10.2 or higher.
B. The tablespaces are locally managed.
C. The default device for the backup must be set to disk.
D. There are no guaranteed restore points defined for the database.
E. The fast recovery area is less than 50 percent free.

질문과 대답: