Online 1Z0-083 Practice Test

Question 1

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

Options :

A : PDB1 and PDB2 are in MOUNT state.

B : Redo logs are opened.

C : PDB1 and PDB2 are in READ ONLY state.

D : CDB$ROOT is in MOUNT state.

E : PDB$SEED is in READ ONLY state.

Answer: A,D

Question 2

choose two Which two are true about RMAN image copies?

Options :

A : They can only be written to disk.

B : They can be encrypted using Transparent Data Encryption (TDE).

C : They can be used as a level 0 incremental backup.

D : They can be used as a level 1 incremental backup.

E : They are the only backup option available for databases in NOARCHIVELOG mode.

Answer: A,C

Question 3

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

Options :

A : Flashback logs are not archived.

B : Flashback logs are maintained in redo log files.

C : Flashback logs are maintained in the Flash Recovery Area.

D : Flashback logs are used to maintain Flashback Database related errors.

E : Flashback logs need to be cleared manually after you disable Flashback Database.

Answer: A,C

Question 4

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write. The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITY tablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

Options :

A : 1,2,4,5,7,8

B : 1,2,4,6,7,8

C : 1,2,3,4,5,7,8

D : 1,2,3,4,5,6,7,8

E : 2,4,5,6,7

Answer: C

Question 5

Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

Options :

A : A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.

B : A PDB Lockdown profile can be created in an application root.

C : A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.

D : A PDB Lockdown profile can be created in a regular PDB.

E : A PDB Lockdown profile can be created in CDB$ROOT .

Answer: A,B

EXPERTY DESIGNED 1Z0-083 PRACTICE TEST