Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Which three are true about Database Point-in-Time Recovery? (Choose three.)

A.

The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.

B.

The database must be in MOUNT state when performing Database Point-in-Time Recovery.

C.

Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

D.

The Database must be in ARCHIVE LOG mode.

E.

The target point for the recovery must be specified as a stime or System Change Number (SCN).

F.

The database must be open RESETLOGS after Database Point-in-Time Recovery.

Which three statements are true about Flashback Data Archive?

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.

Choose two. Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: SELECT containers_default, container_map, table_name FROM dba_tables WHERE owner='FIN' ; CONTAINERS_DEFAULT CONTAINER_MAP CONTAINER_MAP_OBJECT TABLE_NAME -------------------------------------------------------------------------------------------------------------------------------NO YES NO REVENUE NO NO YES MAPTABLE Which two are true?

A.

The REVENUE table must be a list-partitioned table.

B.

The CONTAINERS clause cannot be used in queries on the REVENUE table.

C.

The REVENUE table partitions are not pruned across the PDBs automatically.

D.

The REVENUE table must be a composite-partitioned table.

E.

The MAPTABLE table defines a logical partition key on a commonly used column for the REVENUE table.

Choose three. Which three are true about the FLASHBACK DATABASE feature?

A.

FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

B.

It requires that the target database be in ARCHIVELOG mode.

C.

FLASHBACK LOGS are archived after a log switch.

D.

A database can be flashed back using SQL*PLUS.

E.

It always generates REDO and UNDO.

F.

Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

A.

A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

B.

The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

C.

An existing Oracle base can be used.

D.

The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

E.

Existing Oracle Database instances must be shut down before starting the upgrade.

F.

Only the grid user can perform the upgrade.