Oracle 1Z0-083 Quiz 27 Topic 5 Questions 131-135

Question: 1

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases?

AA snapshot copy PDB can be created from a stand-alone clone PDB

BA PDB snapshot depends on a storage snapshot which can be stored on any file system

CA PDB snapshot depends on a storage snapshot which can only be stored on specific file systems

DA snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems

EA snapshot copy PDB depends on a storage snapshot which can be stored on any file system

FA PDB snapshot is always a sparse copy of the source PDB

GA PDB snapshot is always a full copy of the source PDB

Show Answer

Question: 2

Examine this configuration:

1. The orcl database data files are in Automatic Storage Management (Oracle ASM) disk group +data.

2. orcl uses disk group +fra for the Fast Recovery Area.

3. listener is the listener for orcl.

4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.

5. All components are currently shut down.

You execute this command:

$ srvctl start database -d ORCL

What is the outcome?

AThe ORCL database, the Oracle ASM instances, the +data and +fra disk groups, and the listener are started.

BOnly the orcl database instance is started.

COnly the orcl database instance and the +data and +fra disk groups are started.

DOnly the orcl database instance, the Oracle ASM instance, and the +data and +fra disk groups are started.

EOnly the orcl database and the ASM instances are started.

Show Answer

Question: 3

You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.

Examine this command and its outcome:

# id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall) , 54322(dba)

Which two are true?

Aoracle will be granted the sysasm privilege when installing the Oracle Database software.

Boracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

Coracle will be an owner of the Oracle Inventory.

DThe user account, oracle, and group, oinstall, can be used for all Oracle software installations.

Eoracle must be the owner of every Oracle Database installation.

Show Answer

Question: 4

Examine this command for creating pluggable database PDB2 in container database CDB2

CREATE PLUGGABLE DATABASE pdb2

ADMIN USER pdb2_adrn

IDENTIFIED BY 12 3pdb

ROLES=(CONNECT) ;

Select three options, any one of which is required for it to execute successfully.

AAdd the file_name_convert clause to the statement and set the pdb_file_name_convert parameter.

BSet only the pdb_file_name_convert parameter.

CAdd the file_mame_comvert clause to the statement and enable Oracle Managed Files (OMF).

DEnable only OMF.

ESet the pdb_file_name_convert parameter and enable OMF.

FAdd only the create_file_dest clause to the statement.

Show Answer

Question: 5

Which two are true about Oracle instance recovery?

ARecovery reads redo until the end of the redo thread, and then opens the database, smon then rolls back any dead transactions.

BRecovery begins from the beginning of the current redo log group.

CRecovery begins from the start of any active redo log group or the start of the current log group if no other group is active.

DRecovery reads redo until the end of the redo thread, smon rolls back any dead transactions, and then the database is opened.

ERecovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (ckpt).

FRecovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

Show Answer

Oracle 1Z0-083 Quiz:27 Topic:5 Questions:131-135