Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-083 - Oracle Database Administration II

Oracle 1z0-083 Premium Access     Download Demo    
Page: 6 / 9
Total 286 questions

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

A.

Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

B.

All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

C.

The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.

D.

A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

E.

CDB$ROOT and PDB$SEED are automatically duplicated.

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

A.

Create the PDB1 application PDB and synchronize it with poB$SEED.

B.

Create the PDB1 application PDB and synchronize it with HR_ROOT.

C.

Create the PDB1 application PDB and install HR_APP in it.

D.

Create an application seed, and install HR_APP in it.

E.

Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Choose three. Which three are true about Data Pump in an Oracle multitenant environment?

A.

It can be used to transport data from a non-CDB to a PDB.

B.

It can be used to clone a CDB.

C.

It can be used to transport data between PDBs.

D.

It can be used to transport data from a PDB to a non-CDB.

E.

It can be used to create a new PDB.

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?

A.

The statistics_level parameter is set to all when any of the PDBs is reopened.

B.

The statistics_level parameter is set to all only for PDB2 when it is reopened.

C.

The statistics_level parameter is set to all when the root database is restarted.

D.

The statement is ignored because there is no SPFILE for a PDB.

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A.

A base recovery catalog should exist.

B.

The owner of VPC cannot own recovery catalog.

C.

At least one target database should be registered in the recovery catalog.

D.

The register database privilege should be granted to the virtual catalog owner.

E.

The recovery_catalog_owner role should be granted to the virtual catalog owner.

You execute this command successfully: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What is the outcome?

A.

It creates a binary backup of the control file.

B.

It updates the alert log with the location and contents of the control file

C.

It creates a file that contains SQL statements to re-create the control file.

D.

It creates a file that contains RMAN scripts to create a duplicate database.

E.

It creates a copy of the control file in the fast recovery area (FRA).

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.

Examine the statements that use flashback technologies:

FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM¬DD HH:MI:SS');

SELECT * FROM customers AS OF SCN 123456;

FLASHBACK TABLE customers TO BEFORE DROP;

FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

ALTER TABLE customers FLASHBACK ARCHIVE; Which set ofstatements depends on the availability of relevant undo data in the undo tablespace?

A.

1,3,6

B.

1,2,5

C.

3,4,5

D.

2,3,5,6

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

A.

It is automatically synchronized with its application root PDB when an application is upgraded. B)It cannot be added to an application container after the application container has already been created.

B.

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

C.

It is automatically synchronized with its application root PDB when an application is installed.

D.

It cannot be dropped from its application container.

E.

A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.

F.

It is not required in an application container.

choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

A.

The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B.

The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C.

The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D.

The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.