[2026] Oracle Database 12c: Advanced Administration

문제1

Examine the command to back up the ASM metadata:
ASMCMD> md_backup /backup/ASM_backup
In which three situations can you use the backup? (Choose three.)

A. when the data file on an ASM disk group gets corrupted

B. when all the ASM disk groups for the ASM instance are lost

C. when one of the disks in a disk group is accidentally unplugged

D. when one or more disks in an ASM disk group are lost

E. when one or more file directory paths are accidentally deleted from an ASM disk group

정답: B,D,E

문제2

View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio'); SQL>exec Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'on PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?

A. The sys_group group is not included in the resource plan.

B. The procedure must be executed before creating any plan directive.

C. Pending areas can not be validated until submitted.

D. The other_groups group is not included in the resource plan.

E. The pending area is automatically submitted when creating plan directives.

정답: D

문제3

You want to create a duplicate database DUP_DB from your production database PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

A. The target database must be in MOUNT state.

B. RMAN must be connected to the target database instance and the auxiliary instance.

C. Flashback must be enabled for the PROD database.

D. A most recent backup set of the PROD database must exist.

정답: B

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

문제4

Your database instance is started using an SPFILE. You are connected to CDB$ROOT, as a DBA.
You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the STATISTICS_LEVEL parameter? (Choose two.)

A. It is set to ALL for all PDBs only in the SPFILE.

B. It is immediately set to ALL only for CDB$ROOT.

C. It is immediately set to ALL in the SPFILE and the CDB instance.

D. It is immediately set to ALL in only those pluggable databases (PDBs) where the value is set to TYPICAL.

E. It is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter is not set.

정답: C,D

문제5

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user?

A. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

B. It is created and has the CREATE SESSION privilege only in a PDB that is open.

C. It is created in all the PDBs with the CREATE SESSION privilege.

D. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.

정답: D

문제6

Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

A. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

B. A complete database backup must exist before executing this command.

C. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

D. The database must be running in ARCHIVELOG mode for the successful execution of this command.

E. Block change tracking must be enabled before executing this command.

정답: A

문제7

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command:
RMAN> LIST FAILURE;
Which statement is true about this command?

A. It lists failures only for the CDB root database.

B. It lists failures for a PDB only when RMAN is connected to a recovery catalog.

C. It lists failures for the CDB and all the PDBs in this CDB.

D. It lists failures only if RMAN is connected to a PDB.

정답: A

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

문제8

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? (Choose two.)

A. Only DML and DDL statements will be monitored for the session.

B. Database operations for all sessions will be monitored.

C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

D. Database operations will be monitored only when they consume a significant amount of resource.

E. All subsequent statements in the session will be treated as one database operation and will be monitored.

정답: C,E

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

문제9

Users report this error message when inserting rows into the orders table:
ERROR at line1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in 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? (Choose two.)

A. perform an on line table rebuild using dbms_redefinition

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

C. coalesce the indexes tablespace

D. drop and re-create the index

E. coalesce the order.ind index

정답: B,E

Oracle Database 12c: Advanced Administration - 1z1-063무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트