1z0-083 Practice Test

1z0-083 Practice Test practice questions, page 7 of 8, with answer review and explanations.

Question 31

You issued this command: RMAN> BACKUP RECOVERY FILES; Which two are true? (Choose two.)

  1. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
  2. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
  3. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
  4. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
  5. These backups can be written to disk or SBT.

Question 32

Which two are true about the Oracle database methodology? (Choose two.)

  1. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
  2. Tuning activities should stop once the user is satisfied with performance.
  3. Tuning activities should stop once agreed service levels for performance have been met.
  4. The database instance memory should always be tuned before tuning any file systems.
  5. SQL statements should always be tuned before tuning any file systems.
  6. The alert log should be used to find the database and instance areas most in need of tuning.

Question 33

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck. Which three are true about diagnosing and tuning these problems? (Choose three.)

  1. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
  2. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O.
  3. If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck.
  4. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck.
  5. Data 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.
  6. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using asynchronous I/O/
  7. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

Question 34

You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2. CDB1 user SYS executes these commands after connecting successfully to PDB2: Which two are true? (Choose two.)

  1. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
  2. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
  3. The insert on USER2.DEPT fails because of the active transaction in the parent container.
  4. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
  5. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
  6. The insert on USER2.DEPT is uncommitted.
  7. The inserts on USER1.EMP were committed when the session connected to PDB2.

Question 35

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

  1. CDB1, PDB$SEED, PDB1, and PDB2
  2. PDB$SEED, PDB1, and PDB2 only
  3. CDB1 and PDB$SEED only
  4. CDB1, PDB1, and PDB2 only
  5. CDB1, PDB$SEED, and PDB1 only