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

문제1

On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups.
Today is the 26th of August.
Which backups will be obsolete?

A. all backups prior to 10th of August

B. all backups prior to 20th of August

C. all backups prior to 22nd of August

D. all backups prior to 24th of August

E. all backups prior to 17th of August

정답: E

문제2

You are managing this configuration:
1. CDB1is a container database.
2. PDB1and PDB2are two pluggable databases in CDB1.
3. USER1.EMPis a table in PDB1and USER2.DEPTis a table in PDB2.
CDB1user SYSexecutes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

A. The insert on USER2.DEPT is uncommitted.

B. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

C. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

D. The insert on USER2.DEPT fails because of the active transaction in the parent container.

E. The inserts on USER1.EMP were committed when the session connected to PDB2.

F. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

G. The inserts on USER1.EMP were rolled back when the session connected to PDB2.

정답: B,D

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

문제3

Which three are true about monitoring waits for sessions and services? (Choose three.)

A. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

D. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

E. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

F. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

정답: A,B,D

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

문제4

How do you configure a CDB for local undo mode?

A. Open the CDB instance in upgrade mode.
In cdb$root, execute alter database local undo on, and then restart the CDB instance.

B. Open the CDB in read-only mode.
In cdb$root, ex cute alter database local undo on, and then change the CDB to read/write mode.

C. Open the CDB instance in restricted mode.
In cdb$root, drop the undo tablespace.
Execute alter database local undo on in each PDB and then restart the CDB instance.

D. Open the CDB instance in upgrade mode.
In each PDB, execute alter database local undo on, create an undo tablespace, and hen restart the CDB instance.

E. Open the CDB instance in restricted mode.
In cdb$root, execute alter database local undo on.
create an undo tablespace in each PDB, and hen restart the CDB instance

정답: A

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

문제5

Which two are true about RMAN encryption? (Choose two.)

A. RMAN encryption keys are stored in a database keystore.

B. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

C. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

D. The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.

E. RMAN can encrypt the Oracle Database password file.

정답: A,D

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

문제6

Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege? (Choose three.)

A. They cannot create restore points.

B. They can view data from any data dictionary view or dynamic performance view.

C. They can create any table.

D. They cannot drop tablespaces.

E. They can drop any tablespace.

F. They can view data from any user-defined tables.

정답: B,C,E

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

문제7

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

A. by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host

B. by creating a new database in the new host, and then using the RMAN recover command

C. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

D. by using the RMAN switch command to set the new location for the data files

정답: C

문제8

Examine this configuration:
19.CDB1is a container database.
20.APP_ROOTis an application root in CDB1.
21.APP_PDB1is an application PDB in APP_ROOT.
22.FLASHBACK DATABASEis ON.
You execute these commands:

Which table or set of tables will exist after the Flashback operation has completed?

A. CDB1_TAB and APP_PDB1_TAB

B. none of the tables, because all three tables will be dropped

C. CDB1_TAB and APP_ROOT_TAB

D. CDB1_TAB only

E. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

정답: A

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

문제9

Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

A. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.

B. Backing up a database in NOARCHIVELOGmode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.

C. An Oracle database can be restored from backup files copied using O/S utilities.

D. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

E. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.

F. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

G. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.

정답: A,C,G

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

문제10

Your database is in ARCHIVELOG mode and you plan to use Flashback Database.
Which two features or parameters manage space availability in the fast recovery area? (Choose two.)

A. the archived log deletion policy

B. the backup optimization policy

C. the DB_RECOVERY_FILE_DEST parameter setting

D. using guaranteed UNDO retention

E. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting

F. the backup retention policy

정답: A,F

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

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

우리와 연락하기

유용한 링크

최신 업데이트