Oracle 1Z0-083 Online Practice Questions and Exam Preparation

Oracle 1Z0-083 Online Questions & Answers

• Question 201:

  Which three are true about SGA memory management in a multitenant database? (Choose three.)

  A. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
  B. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
  C. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
  D. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
  E. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
  F. SGA_MIN_SIZE cannot be set for a PDB.
  A. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
  C. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
  E. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.

  ---

  Explanation/Reference:

• Question 202:

  You are working on an Oracle Database 19c database. You enabled the Flashback Database feature.

  Which two statements regarding flashback logs are true? (Choose two).)

  A. Flashback logs are not archived.
  B. Flashback logs are maintained in redo log files.
  C. Flashback logs are maintained in the Flash Recovery Area.
  D. Flashback logs are used to maintain Flashback Database related errors.
  E. Flashback logs need to be cleared manually after you disable Flashback Database.
  A. Flashback logs are not archived.
  C. Flashback logs are maintained in the Flash Recovery Area.

• Question 203:

  A database is configured in ARCHIVELOG mode.

  Full RMAN backups are taken and no backup to trace has been taken of the control file.

  A media failure has occurred.

  In which two scenarios is complete recovery possible? (Choose two.)

  A. when any archived log from, before, or after the most recent backup is corrupt.
  B. after losing all copies of the control file
  C. after losing an archived log from after the most recent backup
  D. after losing an archived log from before the most recent backup
  E. after losing the SYSTEM tablespace
  D. after losing an archived log from before the most recent backup
  E. after losing the SYSTEM tablespace

  ---

  Explanation/Reference:

  If you lose any archive from after the backup, you can't do a complete recovery, so A and C are discarted, also you can't mount the database if you don't have a valid control file. (not B)

• Question 204:

  Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE --------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y

  What is the outcome?

  A. It fails because Data Pump cannot be container.
  B. It creates a full export of the root
  C. It creates a full export of the root
  D. It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.
  A. It fails because Data Pump cannot be container.

• Question 205:

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

  A. A PDB snapshot depends on an existing storage snapshot of the source PDB.
  B. A PDB snapshot can be a full copy of a source PDB.
  C. A PDB snapshot can be a sparse copy of a source PDB
  D. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
  E. A snapshot copy PDB can be created from a stand-alone clone PDB.
  B. A PDB snapshot can be a full copy of a source PDB.
  C. A PDB snapshot can be a sparse copy of a source PDB

  ---

  Explanation/Reference:

• Question 206:

  Examine the 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 statement is true about the DUPLICATE command?

  A. It succeeds and creates multisection backup sets that are used for active database duplication.
  B. It fails because there is no connection to a recovery catalog.
  C. It succeeds only if the target database is in MOUNT state.
  D. It fails because no parallel channels are allocated for the auxiliary database.
  A. It succeeds and creates multisection backup sets that are used for active database duplication.

• Question 207:

  You execute this command successfully:

  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

  What is the outcome?

  A. It creates a binary backup of the control file.
  B. It updates the alert log with the location and contents of the control file
  C. It creates a file that contains SQL statements to re-create the control file.
  D. It creates a file that contains RMAN scripts to create a duplicate database.
  E. It creates a copy of the control file in the fast recovery area (FRA).
  C. It creates a file that contains SQL statements to re-create the control file.

• Question 208:

  Which three are true about managing memory components in an Oracle database instance? (Choose three.)

  A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
  B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
  C. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
  D. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
  E. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
  F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
  A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
  B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
  F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

  ---

  Explanation/Reference:

  in AMM the instance exchanges memory between the SGA and the instance PGA as needed (B is correct)

  In ASMM the instance automatically distributes this memory among the various SGA components (JUST SGA) (A is correct, E incorrect)

  After a restart the instance return to the SGA values before the shutdown (not the initial values) (C incorrect)

  https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-8F54391B-D42A-4FDA-9D12-E1F81FD113EA

  F is also correct:

  For OLTP systems, the PGA memory typically makes up a small fraction of the available memory, leaving most of the remaining memory for the SGA.

  For DSS systems running large, memory-intensive queries, PGA memory can typically use up to 70% of the available memory.

  Reference:

  https://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm

  https://docs.oracle.com/database/121/TGDBA/tune_pga.htm#TGDBA472

• Question 209:

  Examine the command for creating pluggable database PDB2 in container database CDB2.

  

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

  A. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
  B. Add only the CREATE_FILE_DEST clause to the statement.
  C. Set only the PDB_FILE_NAME_CONVERT parameter.
  D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
  E. Enable only OMF.
  F. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
  B. Add only the CREATE_FILE_DEST clause to the statement.
  C. Set only the PDB_FILE_NAME_CONVERT parameter.
  E. Enable only OMF.

  ---

  Explanation/Reference:

  You can specify FILE_NAME_CONVERT = NONE, which is the same as omitting this clause. If you omit this clause, then the database first attempts to use Oracle Managed Files to generate file names. If you are not using Oracle Managed Files, then the database uses the PDB_FILE_NAME_CONVERT initialization parameter to generate file names. If this parameter is not set, then an error occurs.

  Reference: https://docs.oracle.com/database/121/SQLRF/statements_6010.htm#SQLRF55686

• Question 210:

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

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

  ---

  Explanation/Reference: