Free 1z0-083 Exam Dumps

Question 6

You are managing this configuration:
1Z0-083 dumps exhibit CDB1is a container database.
PDB1andPDB2are two pluggable databases inCDB1.
USER1.EMPis a table inPDB1andUSER2.DEPTis a table inPDB2.
CDB1userSYSexecutes these commands after connecting successfully toPDB2:

Which two are true? (Choose two.)

A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
B. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
E. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
F. The insert on USER2.DEPT is uncommitted.
G. The inserts on USER1.EMP were committed when the session connected to PDB2.

Correct Answer:FG

Question 7

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

A. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
C. to include specific user tablespaces only when relocating a PDB
D. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
E. to exclude a temp tablespace when plugging in a PDB
F. to specify the list oftablespaces to include when creating a PDB from the CDB seed

Correct Answer:BD

Question 8

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

A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.
B. 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.
C. An Oracle database can be restored from backup files copied using O/S utilities.
D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
F. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
G. 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.

Correct Answer:BDE

Question 9

Which two are true about automatic block repair? (Choose two.)

A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE.
B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
D. It is not possible for media corrupt blocks.
E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Correct Answer:BC

Question 10

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

A. Media Management messages for SBT devices are always written to sbtio.log.
B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
D. The RMAN LOG command line clause causes output issued during RMAN commandcompilation to bewritten to a log file and to standard output.
E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
F. Media Management messages for SBT devices are written to an Oracletrace file.

Correct Answer:EF