ocp_83

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose fou

choose two Examine these RMAN commands: 

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; 

RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; 

RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE

SECTION SIZE 400M; 

Which two statements are true about the DUPLICATE command?

RMAN is connected to a target database instance and an auxilary instance. 

You execute the command: 

RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G;

What is the outcome?

choose three You want to duplicate one of your databases when connected to the target database and to

the recovery catalog. 

Which three are true about this type of database duplication 

choose two Examine the command to duplicate a database: 

RMAN> DUPLICATE TARGET DATABASE TCddb PLUGGABLE DATABASE pdbl,pdb5; 

Which two statements are true about the DUPLICATE command? 

 choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

Choose the best answer You want to create a duplicate database DUP_DB from your production database

PROD on the same host. 

The PROD database uses Automatic Storage Management (ASM) for storage. 

Regular backups are taken using RMAN connected to a recovery catalog. 

You create an auxiliary instance and want to execute the command: 

RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;

What is a prerequisite for the successful execution of this command 

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in

CDB1. PDB1 was unplugged from CDB1 earlier in the week. 

Examine this command, which will be executed in CDB1: 

CREATE PLUGGABLE DATABASE pdb1 USING ‘/u01/app/oracle/oradata/pdb1.xml’

SOURCE_FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/’,‘/u02/app/oracle/oradata/’); 

Which two are true? (Choose two.) 

Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

Examine this command: $ rhpctl move database –sourcehome Oracle_home_path –destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

 Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

 Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A user complains about poor database performance. You want to verify if the user’s session has waited for

certain types of I/O activity. 

Which view displays all waits waited on by a session at least once?

Which two are true about gathering optimizer statistics? (Choose two.)

Examine this output: Which two are true? (Choose two.) 

SOL > select pluggable_database,shares,parallel_server_limit

2 From dba_cdb_rsrc_plan_directive where plan=’MY_PLAN’

3 order by pluggable_database;

PLUGGARLE_DATARASE SHARES PARALLEL _SERVER_LIMIT 

ORA$$AUTOTASK 100

ORA$$DEFAULT_PDB_DIRECTIVE 1 0

PDB1 2 100

PDB2 2 25

PDB3 1 

SOL > select name,value from v$parameter 

 2 where name = ‘resource_manager_plan’;

NAME VALUE

Resource_manager_plan MY_PLAN

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

 Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

Automatic Shared Memory Management is disabled for one of your database instances. 

Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading

performance. 

What would be your next step? 

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)