Online 1Z0-083 Practice Test

Question 1

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

Options :

A : By default, the transported database will use Oracle Managed Files (OMF)

B : Data files can be converted on the destination system.

C : Data files can be converted on the source system.

D : A new DBID is automatically created for the transported database.

E : Databases can be transported between systems with different endian formats.

F : The password file is automatically converted by RMAN.

Answer: A,B,C

Question 2

Choose two You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID ------------------------------------------------------------------------SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?

Options :

A : Re-create or migrate the password file to the Oracle Database 12c format

B : Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C : Copy the password file from a sample file in the DBS dierectory

D : Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.

Answer: A,B

Question 3

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

Options :

A : PDB2 will be opened READ WRITE.

B : PDB1 will be opened READ WRITE.

C : PDB1 will be MOUNTED.

D : PDB$SEED will be opened READ ONLY.

E : PDB$SEED will be MOUNTED

F : PDB2 will be MOUNTED.

Answer: A,B,D

Question 4

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

Options :

A : A PDB snapshot is always a full copy of the source PDB.

B : A PDB snapshot is always a sparse copy of the source PDB.

C : A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

D : A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E : A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F : A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

G : A snapshot copy PDB can be created from a stand-alone clone PDB.

Answer: A,C

Question 5

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

Options :

A : Enable Memory Access Mode, which reads performance data from SGA.

B : Use emergency monitoring to fetch data directly from SGA for analysis.

C : Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

D : Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

E : Run ADDM in diagnostic mode.

Answer: B

EXPERTY DESIGNED 1Z0-083 PRACTICE TEST