[2026] Oracle Database Administration II - 1Z0-083 무료 시험 문제

문제1

Which two are true about RMAN duplexed backup sets? (Choose two.)

A. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

B. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

C. A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

D. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

E. A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

F. A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

정답: C,F

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

문제2

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

A. Decreasing PCTFREE

B. Using Automatic Segment Space Management (ASSM)

C. Decreasing PCTUSED

D. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation

E. Increasing the number of DBWN process

정답: B

문제3

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

A. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

B. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

C. AWR reports can be generated while connected to any container.

D. AWR snapshots can be created in CDB$ROOT.

E. ADDM can run in a nonroot container.

F. AWR snapshots can be created in a PDB.

정답: D,E,F

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

문제4

Which three are true? (Choose three.)

A. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

B. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

C. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-ENDblock.

D. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-ENDblock.

E. Unified auditing can be automatically synchronized to all application PDBs in an application container.

F. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-ENDblock.

G. Application-common TSDP policies are always container specific.

정답: C,E,G

문제5

In which three situations can you use threshold server-generated alerts to help diagnose and fix problems? (Choose three.)

A. when the total number of logons exceeds a specific value

B. when free space in a locally managed tablespace falls below a specified percentage

C. when the total number of locked user account exceeds a specific value

D. when free space in a dictionary managed tablespace falls below a specified percentage

E. when a resumable statement is suspended

F. when the number of logons per second exceeds a specific value

정답: C,D,F

문제6

Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

A. flashback database must be enabled for it to work.

B. RMAN always includes tablespaces containing undo segments in the recovery set.

C. It can be used to recover a dropped tablespace.

D. It can be used to recover a truncated table.

E. It can be performed using an auxiliary instance managed by RMAN.

F. It can be performed using an auxiliary instance managed by a DBA.

G. It can be performed repeatedly until the correct time is found without using an RMAN catalog.

H. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.

정답: A,E,F,G

문제7

Examine this configuration:
1. CDB1 is a container database.
2. APP1_ROOT is an application container contained in CDB1.
3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT.
4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT.
5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0.
6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version
1.0 of APP1_USER_APP was installed.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> ALTER SESSION SET CONTAINER=app1_root;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app
BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered.
SQL> GRANT CREATE SESSION TO USER1; Grant succeeded.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app
END UPGRADE TO '2.0'; Pluggable database altered
SQL> ALTER SESSION SET CONTAINER=app1_pdb1;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;
Pluggable database altered.
Which two are true?

A. USER1 is defined in APP1_PDB2. E) USER1 can connect only to APP1_PDB1.

B. USER1 can connect only to APP1_ROOT.

C. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.

D. USER1 can connect to APP1_ROOT and APP1_PDB1.

E. USER1 can connect to CDB1.

정답: A,D

문제8

Which three are true about corrupted data blocks and their recovery in an Oracle Database?

A. If a row lock is held by a nonexistent transaction, the block containing the row is media corrupt.

B. DB_BLOCK_CHECKING=TRUE causes a check sum to be added to each data block to help detect physical or media corruption.

C. The ANALYZE TABLE VALIDATE STRUCTURE CASCADE command verifies that each table row has an index entry pointing to it.

D. If a row lock is held by a nonexistent transaction, the block containing the row is logically corrupt.

E. DB_LOST_WRITE_PROTECT=TYPICAL causes extra logging overhead on the standby database.

F. A media corrupt block is one where the block is not formatted correctly.

정답: C,D,E

문제9

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

A. The C # # A_ADMIN user can perform wallet operations.

B. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

C. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

E. TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only.

정답: B,C,D

문제10

Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)

A. Space might be reclaimed proactively before space pressure occurs.

B. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

C. Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)

D. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

E. Space is always reclaimed proactively before space pressure occurs.

정답: B,E

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

문제11

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

A. It can be used to provision applications.

B. It cannot be used to upgrade Oracle Database homes.

C. It can be used to provision middleware.

D. It is an Oracle Database service

E. It can be used to patch Grid Infrastructure homes containing Oracle Restart.

정답: A,C

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

문제12

A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2.
You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.
Which three are required?

A. CDB1 and CDB2 must both be in local UNDO mode.

B. CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.

C. CDB1 must be in archivelog mode.

D. CDB2 must be in archivelog mode.

E. CDB2 must be in shared UNDO mode only.

F. CDB1 and CDB2 must be in shared UNDO mode.

정답: A,C,D

문제13

Which three are true about a container database (CDB)?

A. It can have local users with the same name in different PDBs.

B. It can have any number of pluggable databases (PDBs) limited only by space availability.

C. It can be created by cloning an existing CDB.

D. It contains predefined common roles in both the root and the seed.

E. It can contain only one PDB$SEED, which is created when the CDB is created.

F. It can contain only one Application Container seed, which is created when the Application Container is created.

G. It can be created from a non-CDB.

정답: C,D,E

Oracle Database Administration II - 1Z0-083무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트