Oracle 1Z0-083 Quiz 8 Topic 3 Questions 36-40

Question: 1

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? (Choose two.)

ACreate an application seed, and install HR_APP in it.

BCreate the PDB1 application PDB and install HR_APP in it.

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

DCreate the PBD1 application PDB and synchronize it with HR_ROOT.

ECreate the PBD1 application PDB and synchronize it with PDB$SEED.

Show Answer

Question: 2

Which operating system group is NOT needed to perform an Oracle Database installation?

AOSASM

BOSKMDBA

COSDBA

DOSOPER

EOSRACDBA

Show Answer

Question: 3

You want to transport the UNIVERSITY tablespace from one database to another.

The UNIVERSITY tablespace is currently open read/write.

The source and destination platforms have the same endian format.

Examine this list of steps:

1. Make the UNIVERSITY tablespace read-only on the source system.

2. Export the UNIVERSITY tablespace metadata using EXPDP.

3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an

RMAN command that includes the DATAPUMP clause.

4. Copy the cross-platform backup sets to the destination system.

5. Copy the Data Pump dump set from the source to the destination system.

6. Restore the cross-platform backup set on the destination system using an RMAN command that includes

the DATAPUMP clause.

7. Import the UNIVERSITY tablespace metadata using IMPDP.

8. Make the UNIVERSITY tablespace read/write on the destination system.

Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY

tablespace?

A1, 3, 4, 6, 8

B3, 4, 6

C1, 2, 3, 4, 5, 6, 7, 8

D2, 3, 4, 5, 6, 7

Show Answer

Question: 4

Which three true about recovering tables using RMAN? (Choose three.)

ARMAN can recover tables in the SYSAUX tablespace.

BRMAN can recover tables owned by the SYS user.

CRMAN can recover tables in the SYSTEM tablespace.

DRMAN always uses an auxiliary instance.

ERMAN can recover tables in a standby database.

FRMAN can recover a table after a DDL operation has altered the table structure.

GRMAN can recover tables owed by the SYSTEM user.

Show Answer

Question: 5

You plan to perform cross-platform PDB transport using XTTS.

Which two are true? (Choose two.)

AA backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.

BThe source PDB must be in MOUNT state.

CThe source PDB must not be an application root.

DThe source PDB can be in MOUNT or OPEN state.

EThe source and target platforms must have the same endianness.

FAutomatic conversion of endianness occurs.

Show Answer

Oracle 1Z0-083 Quiz:8 Topic:3 Questions:36-40