Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

1z0-083 Reviews Questions

Page: 8 / 21
Total 286 questions

Oracle Database Administration II Questions and Answers

Question 29

Choose three. Which three are true about patchsets?

Options:

A.

They are installed via OPatch or OPatchAuto.

B.

A base release is not needed to install patchsets.

C.

They can be applied in a rolling fashion for Clusterware and the databases.

D.

Installing a patchset is considered an "upgrade."

E.

They can introduce new features.

F.

They are only released quarterly.

Question 30

Choose two. Which two are true about various Oracle security and auditing capabilities?

Options:

A.

Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

B.

Application-common TSDP policies are always container specific.

C.

Application-common OLS policies can be created only if all the PDBs in the application container are closed.

D.

Unified auditing can be automatically synchronized to all application PDBs in an application container.

E.

Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

Question 31

Which three statements are true about Flashback Database?

Options:

A.

Flashback logs are written sequentially, and are archived.

B.

Flashback Database uses a restored control file to recover a database.

C.

The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

D.

Flashback Database can recover a database to the state that it was in before a reset logs operation.

E.

Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F.

Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Question 32

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

Options:

A.

It fails because Data Pump cannot be container.

B.

It creates a full export of the root

C.

It creates a full export of the root

D.

It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.

Page: 8 / 21
Total 286 questions