Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

1z0-083 Exam Dumps - Oracle Database Administration II

Go to page:
Question # 17

Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?

A.

Plugging the application root into a different CDB plugs in all its application PDBs.

B.

The application root of an application container should be plugged into the other CDB before its application PDBs are plugged in.

C.

Application PDBs in the application container must be unplugged before the application root is unplugged.

D.

Unplugging the application root from a CDB unplugs all its application PDBs.

E.

It requires only local UNDO mode in the database where the application container will be unplugged.

F.

It requires local UNDO mode in both container databases.

Full Access
Question # 18

Which three are true about Automatic Workload Repository (AWR) snapshots?

A.

They are generated if STATISTICS_LEVEL is set to TYPICAL.

B.

They are always created manually.

C.

They are always created automatically.

D.

They are generated if STATISTICS_LEVEL is set to BASIC.

E.

They are generated if STATISTICS_LEVEL is set to ALL.

F.

They can be retained forever.

Full Access
Question # 19

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

A.

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

B.

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

C.

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

D.

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

E.

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

Full Access
Question # 20

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

A.

RMAN encryption keys are stored in a database keystore.

B.

RMAN can encrypt the Oracle Database password file.

C.

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

D.

The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

E.

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

Full Access
Question # 21

Choose two. Examine this command: $ rhpctl move database -sourcehome Oracle_home_path ¬destinationhome Oracle_home_path For which two purposes can you use this command?

A.

to switch to a patched Oracle Database home

B.

to upgrade an Oracle Database on the centralized Rapid Home Provisioning server

C.

to move an Oracle Database to the centralized Rapid Home Provisioning server

D.

to switch back to the previous Oracle home as part of a rollback operation

E.

to switch to a read-only Oracle home

Full Access
Question # 22

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.)

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.

Full Access
Question # 23

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

A.

Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

B.

After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

C.

Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

D.

The new extended data type capability must be enabled by running the utlrp.sql script

E.

The Oracle Application Express configuration should be updated after upgrading Oracle Database.

Full Access
Question # 24

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?

A.

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

B.

CDB$ROOT, PDB2, PDB1, and PDB3

C.

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

D.

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

E.

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

Full Access
Go to page: