[2026] Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

문제1

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which statement is true about the c##connect role?

A. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

B. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

C. It is granted to the c##admin user only in the CDB.

D. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제2

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which type of encryption is used for the backup performed by using this command?

A. transparent encryption

B. default encryption

C. dual-mode encryption

D. password-mode encryption

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제3

Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?
(Choose all that apply.)

A. It can be used to selectively restrict the access for each user in a database to different host computers.

B. It can be used to allow the access privilege settings for users as well as roles.

C. It can be used to control the time interval for which the access privilege is available to a user.

D. It can be used to allow the access privilege settings for users but not roles.

E. It can be used to selectively restrict a user's access to different applications in a specific host computer.

정답: A,B,C

문제4

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded.
Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

A. Use emergency monitoring to fetch data directly from SGA for analysis.

B. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

C. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

D. Enable Memory Access Mode, which reads performance data from SGA.

E. Run ADDM in diagnostic mode.

정답: A

문제5

Which three statements are true about persistent lightweight jobs?

A. They must reference an existing Scheduler Program.

B. They generate large amounts of metadata.

C. The are useful when users need to create a large number of jobs quickly.

D. A user cannot set privileges on them.

E. They may be created as fully self-contained jobs.

정답: A,C,D

설명: (Fast2test 회원만 볼 수 있음)

문제6

Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries?

A. perform an on line table rebuild using dbns_redefir.ition.

B. coalesce the orders index

C. rebuild the index online moving it to another tablespace that has enough free space for the index

D. coalesce the indexes tablespace

E. drop and re-create the index

정답: B,C

문제7

You set the following parameters in the parameter file and restart the database instance:
MEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true?

A. The memory_max_target parameter is automatically set to 500 MB.

B. The pga_aggregate_target and sga_target parameters are automatically set to zero.

C. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

E. The value of the memory_max_target parameter remains zero for the database instance.

정답: A,D

문제8

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

A. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

B. The ADR can be used to store statspack snapshots to diagnose database performance issues.

C. The ADR base is shared across multiple instances.

D. The ADR base keeps all diagnostic information in binary format.

E. The ADR can be used for problem diagnosis even when the database instance is down.

정답: C,E

문제9

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1.Restore an autobackup of the server parameter file.
2.Restore the control file.
3. Start up the database instance in nomount state.
4.Mount the database.
5.Restore the data files.
6.Open the database with the resetlogs option.
7.Recover the data files.
8.Set DBID for the database.
Identify the required steps in the correct order.

A. 8, 1, 3, 2, 4, 5, 6

B. 1, 8, 3, 2, 4, 5, 7, 6

C. 1, 3, 2, 4, 8, 5, 6, 7

D. 8, 3, 2, 4, 5, 7, 6

E. 8, 1, 3, 2, 4, 5, 7, 6

정답: D

문제10

You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAMETYPEVALUE
----------------------------------------------------------------------- db_create_file_deststring db_file_name_convertstring db_filesinteger200 You verify that sufficient disk space is available and that no file currently exists in the
'/u0l/app/oracle/oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSERsalesadmIDENTIFIED 3Y password
ROLES=(dba)
DEFAULTTABLESPACEsales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf'SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?

A. SALESPDB is created and is in read/write mode.

B. SALESPDB is created and is in mount state.

C. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

D. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제11

You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?

A. It creates a binary backup of the control file.

B. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

C. It creates a file that contains the SQL statement, which is required to re-create the control file.

D. It updates the alert log file with the location and contents of the control file.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z0-067무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트