Oracle 1Z0-083 Quiz 26 Topic 5 Questions 126-130

Question: 1

Examine this configuration:

1. CDB1 is a container database.

2. COMM0N_USER_PREFIX IS C##.

3. PDB1 is a pluggable database contained in CDB1.

4. APP1_ROOT is an application container contained in CDB1.

5. APP1_PDB1 is an application PDB contained in APP1_ROOT.

You execute these commands successfully:

q1_1Z0-083

Which two are true?

Aapp1_user1 can be created in cdb1.

Bapp1_user1 can be created in pdb1.

Cc##_app_user1 can be created in cdb1.

Dapp1_user1 can have different privileges in each Application PDB contained in app1_root.

Ec##_user1 will have the same privileges and roles granted in all PDBs in cdb1.

Fp1_user1 can be created in cdb1.

Show Answer

Question: 2

Which two are true about monitoring waits for sessions and services?

Av$session_wait and v$session both contain details of the event on which a waiting session is currently waiting.

Bv$session_wait_class displays waits broken down by wait class only for waiting sessions.

Cv$service_event displays wait counts for every wait event whether waited on or not, for each service.

Dv$session_wait and v$session both contain details of the event on which a non-waiting session last waited.

Ev$session_event displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

Show Answer

Question: 3

When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck.

Which two are true about diagnosing and tuning these problems?

AIf an rman backup validate command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

BIf an rman backup validate command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

CData files with a high value in v$backup_sync_io.discrete_bytes_per_second are a potential performance bottleneck when synchronous I/O is used.

DIf an rman backup validate command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.

EData files with a high value in v$backup_async_io.short_waits are a potential performance bottleneck when asynchronous I/O is used.

Show Answer

Question: 4

Examine this configuration:

q4_1Z0-083

You execute these commands before upgrading the database to the current release:

q4_1Z0-083

For which databases will fixup scripts be created?

ACDB1, PDB$SEED, PDB1, and PDB2

BCDB1 and PDB$SEED only

CCDB1, PDB1, and PDB2 only

DPDB$SEED, PDB1, and PDB2 only

ECDB1, PDB$SEED, and PDB1 only

Show Answer

Question: 5

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c?

Arelocating a remote container database in interactive mode

Bcloning a remote container database in silent mode

Ccloning a remote container database in interactive mode

Drelocating a remote container database in silent mode

Erelocating a remote pluggable database in interactive mode

Fcloning a remote pluggable database in silent mode

Grelocating a remote pluggable database in silent mode

Show Answer

Oracle 1Z0-083 Quiz:26 Topic:5 Questions:126-130