Oracle 1Z0-083 Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

Choose two. Which two are true about PDB archive files?

ADBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

BThey contain a PDB manifest file and all the data files in uncompressed form for a PDB.

CThey contain all the data files only in uncompressed form for a PDB.

DThey must be created using the DBMS_PDB package.

EThey contain a PDB manifest file and all the data files in compressed form for a PDB.

FThey contain all the data files only in compressed form for a PDB.

Correct : A, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ADBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

BThey contain a PDB manifest file and all the data files in uncompressed form for a PDB.

CThey contain all the data files only in uncompressed form for a PDB.

DThey must be created using the DBMS_PDB package.

EThey contain a PDB manifest file and all the data files in compressed form for a PDB.

FThey contain all the data files only in compressed form for a PDB.

0 / 1500

Question 2

Choose the best answer. Examine this configuration: 1. CDB1 is an Oracle container database from an older release. 2. PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1. A priority list UpgrdList has these entries: 1, pdb2 2, pdb1, pdb3 You execute this command: $ /u01/app/oracle/product/18.1.0/ db_1/rdbms/admin/dbupgrade -L UpgrdList In which order will the upgrade occur?

ACDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

BCDB$ROOT, PDB2, PDB1, and PDB3

CCDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

DCDB$ROOT, PDB1, PDB2, PDB3, and PDB4

ECDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ACDB$ROOT, PDB$SEED, PDB2, PDB1, PDB3, and PDB4

BCDB$ROOT, PDB2, PDB1, and PDB3

CCDB$ROOT, PDB$SEED, PDB2, PDB1, and PDB3

DCDB$ROOT, PDB1, PDB2, PDB3, and PDB4

ECDB$ROOT, PDB$SEED, PDB1, PDB3, PDB2, and PDB4

0 / 1500

Question 3

Choose two. Which two are prerequisites for using FLASHBACK TABLE?

AA table's constraints must be disabled before issuing the flashback.

BThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.

CRow Movement must be enabled on the table being flashed back.

DA table's indexes must be set to unusable before issuing the flashback.

EThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.

Correct : B, C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AA table's constraints must be disabled before issuing the flashback.

BThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.

CRow Movement must be enabled on the table being flashed back.

DA table's indexes must be set to unusable before issuing the flashback.

EThe FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.

0 / 1500

Question 4

Choose two. For which two tasks can you use the DBMS_PDB.DESCRIBE procedure?

Ato generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

Bto generate an XML metadata file from any unplugged PDB

Cto determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

Dto generate a . pdb archive file for any PDB in the current CDB

Eto generate an XML metadata file that describes the current plugged-in PDB

Correct : A, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

Ato generate an XML metadata file that describes a non-CDB Oracle 12c database so that it can be plugged in as a PDB

Bto generate an XML metadata file from any unplugged PDB

Cto determine whether an XML file describes a PDB that can be plugged into the CDB in which you run the procedure

Dto generate a . pdb archive file for any PDB in the current CDB

Eto generate an XML metadata file that describes the current plugged-in PDB

0 / 1500

Question 5

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

AIt requires Oracle ASMLib to manage Automatic Storage Managerment (ASMl) disks.

BIt creates one disk group during installation.

CIt includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

DAutomatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner.

EIt requires the operating system ORACLE_BASDE environment variable to be predefined before installation.

FIt requires Oracle ASM Filter Drver (ASMFD) to manage Automatic Storage Managemernt (AsM) disks.

Correct : B, C, D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AIt requires Oracle ASMLib to manage Automatic Storage Managerment (ASMl) disks.

BIt creates one disk group during installation.

CIt includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

DAutomatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner.

EIt requires the operating system ORACLE_BASDE environment variable to be predefined before installation.

FIt requires Oracle ASM Filter Drver (ASMFD) to manage Automatic Storage Managemernt (AsM) disks.

0 / 1500

Master Oracle 1Z0-083 Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: