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

Oracle Oracle Database 19c 1z0-083 New Questions

Page: 18 / 21
Question 72

Examine these queries and their output: After a system crash, an instance restart and an attempted opening of the PDBs result in: Which two are true? (Choose two.)

Options:

A.

Data file 24 can be recovered while PDB2 is opened.

B.

Data file 24 must be recovered while the CDB is opened.

C.

Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

D.

Data file 24 cannot be recovered while the CDB is opened.

E.

Data file 24 must be recovered while PDB2 is closed.

Question 73

Which three statements are true about Flashback Data Archive?

Options:

A.

To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

B.

To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database

C.

While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

D.

A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

E.

Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

Question 74

Choose three. Which three activities are possible for PDBs?

Options:

A.

converting an application seed to an application PDB

B.

converting a regular PDB to an application PDB

C.

converting an application PDB to an application root

D.

copying an application container into another application container in the same CDB

E.

copying an application container into another application container in a different CDB

F.

converting an application PDB to an application seed G) converting an application PDB to a regular PDB

Question 75

Choose four. Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

Options:

A.

It can be performed using an auxiliary instance managed by RMAN.

B.

It can be performed using an auxiliary instance managed by a DBA.

C.

It can be used to recover a truncated table.

D.

It can be performed repeatedly until the correct time is found without using an RMAN catalog. E)RMAN always includes tablespaces containing UNDO segments in the recovery set.

E.

RMAN automatically adds any required tablespaces to the recovery set to make it selfcontained. G) FLASHBACK DATABASE must be enabled for it to work. H) It can be used to recover a dropped

tablespace.

Page: 18 / 21
Exam Code: 1z0-083
Exam Name: Oracle Database Administration II
Last Update: May 12, 2024
Questions: 286
1z0-083 pdf

1z0-083 PDF

$28  $80
1z0-083 Engine

1z0-083 Testing Engine

$33.25  $95
1z0-083 PDF + Engine

1z0-083 PDF + Testing Engine

$45.5  $130