New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

Oracle Database 19c 1z0-083 Release Date

Page: 11 / 21
Question 44

Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command?

Options:

A.

he SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated.

B.

A backup of pdb1 and pdb5 must exist before executing the command.

C.

The duplicate command first creates a backup, and then duplicates the PDBs by using the backup.

D.

A backup of CDB and pdb1 and pdb5 must exist before executing the command.

E.

An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

Question 45

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

Options:

A.

FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

B.

FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C.

FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D.

FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

E.

FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.

F.

FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Question 46

You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

Options:

A.

a General Purpose database template with default memory allocation

B.

a Data Warehouse database template, with t he dedicated server mode option and AMM enabled

C.

a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled

D.

a default database configuration

Question 47

Choose two. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?

Options:

A.

Space might be reclaimed proactively before space pressure occurs.

B.

Space is always reclaimed proactively before space pressure occurs.

C.

Space might be reclaimed automatically when the retention period for Flashback logs is lowered.

D.

Space is always reclaimed automatically when the retention period for Flashback logs is lowered.

E.

Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA).

Page: 11 / 21
Exam Code: 1z0-083
Exam Name: Oracle Database Administration II
Last Update: Dec 22, 2024
Questions: 286
1z0-083 pdf

1z0-083 PDF

$25.5  $84.99
1z0-083 Engine

1z0-083 Testing Engine

$28.5  $94.99
1z0-083 PDF + Engine

1z0-083 PDF + Testing Engine

$40.5  $134.99