Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 41:

  Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)

  A. It can be launched from both the command line and the Universal Installer (OUI) interfaces.

  B. It can be used to change the character set of an existing database.

  C. It can be used to convert a non-container database to a container database.

  D. It can be used to create container databases and non-container databases.

  E. It can only be launched from the command line interface.

  Correct Answer: AD

• Question 42:

  Which three are performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)

  A. mounting disk groups

  B. managing Allocation Units (AUs) for disk group content

  C. managing extent allocation for Oracle database segments

  D. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)

  E. managing space allocation for Oracle ASM files

  F. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes

  Correct Answer: ABE

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmcon.htm#OSTMG94057

• Question 43:

  Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

  A. A table's constraints must be disabled before issuing the flashback.

  B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.

  C. A table's indexes must be set to unusable before issuing the flashback.

  D. Row Movement must be enabled on the table being flashed back.

  E. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.

  Correct Answer: BD

  https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/FLASHBACK-TABLE.html#GUID-FA9AF2FD-2DAD-4387-9E62-14AFC26EA85C it is B and D

• Question 44:

  Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)

  A. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.

  B. SQL statements doing only logical reads never require tuning because they do no physical I/O.

  C. The solution that best optimizes one SQL statement can degrade the performance of others.

  D. SQL statements doing joins always do more physical I/O than single table queries.

  E. Poorly performing SQL statements can be tuned automatically by the Oracle server.

  Correct Answer: CE

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#PFGRF028

• Question 45:

  Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

  A. It can be used for applications and middleware.

  B. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

  C. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

  D. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

  E. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

  Correct Answer: AD

  Reference https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwadd/rapid-home-provisioning.html#GUID-CCEC5960-EDA4-4A3F-9643-0CA308EA49AA

• Question 46:

  The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true? (Choose three.)

  A. A proxy PDB must exist in the application root in the remote CDB.

  B. A database link must exist in the local CDB root referring to the remote CDB.

  C. PDB3's application root replica must exist in the local CDB.

  D. A database link must exist in the remote CDB referring to the local CDB.

  E. The HR_ROOT replica must exist in the remote CDB.

  F. A proxy PDB must exist in the application root in the local CDB.

  Correct Answer: BEF

  Database link must be created in master application root (local CDB) referring to replica application root (remote CDB). Option B Proxy PDB must be created in master application root (local CDB) using this database link. Option F Replica application root must exist in remote CDB (created or upgraded using SYNC in local Proxy PDB). Option E With this, we can make a SELECT that will show data from local and remote PDB applications (Query in local master application root using CONTAINERS clause).

• Question 47:

  Your database is in ARCHIVELOG mode and you plan to use Flashback Database.

  Which two features or parameters manage space availability in the fast recovery area? (Choose two.)

  A. the archived log deletion policy

  B. the backup optimization policy

  C. the backup retention policy

  D. using guaranteed UNDO retention

  E. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting

  F. the DB_RECOVERY_FILE_DEST parameter setting

  Correct Answer: AC

  RMAN automatically manages files in the fast recovery area by deleting obsolete backups and archiving files no longer required for recovery. https://docs.oracle.com/en/database/oracle/oracle-database/18/ssdbi/about-the-fast-recovery-area-and-the-fast-recovery-area-disk-group.html#GUID-05343E2B-24CF-427E-A068-9AC2104BEF81

• Question 48:

  Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

  A. SQL statements

  B. log writer performance

  C. general operating system health

  D. database writer performance

  E. database instance memory management and sizes

  Correct Answer: C

• Question 49:

  Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c? (Choose two.)

  A. The response file can specify the root or sudo password.

  B. The installer will prompt for the root or sudo password.

  C. Silent install always runs operating scripts automatically.

  D. The response file must contain the root or sudo password.

  E. The response file can specify the path of the sudo program.

  Correct Answer: BE

  #-------------------------------------------------------------------------------------# Specify the configuration method to be used for automatic root script execution.

  #

  # Following are the possible choices:

  # - ROOT

  # - SUDO

  #-------------------------------------------------------------------------------------oracle.install.db.rootconfig.configMethod=ROOT

  #-------------------------------------------------------------------------------------# Specify the absolute path of the sudo program.

  #

  # Applicable only when SUDO configuration method was chosen.

  #-------------------------------------------------------------------------------------oracle.install.db.rootconfig.sudoPath=

  #-------------------------------------------------------------------------------------# Specify the name of the user who is in the sudoers list.

  # Applicable only when SUDO configuration method was chosen.

  # Note:For Single Instance database installations,the sudo user name must be the username of the user installing the database.

  Reference: https://oraclefact.wordpress.com/2019/08/05/1-install-oracle-database-19c-with-automatic-root-scripts-execution/

• Question 50:

  Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

  A. using the KEEP FOREVER clause with the BACKUP command

  B. using RMAN stored scripts

  C. using the REPORT SCHEMA command to list a database's current data files and tablespaces

  D. creating customized reports about a single database's backups

  E. creating encrypted backups

  F. using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past

  Correct Answer: ABF

  A is correct:

  https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/keepOption.html

  "Specifies that the backup or copy never becomes obsolete (see Example 2-27). A recovery catalog is required when FOREVER is specified because the backup records eventually age out of the control file."

  B is correct:

  https://docs.oracle.com/database/121/RCMRF/rcmsynta013.htm

  "Execute CREATE SCRIPT only at the RMAN prompt. RMAN must be connected to a target database and a recovery catalog."

  F is correct:

  https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/REPORT.html

  "atClause

  This subclause specifies a point in time as a time, SCN, or log sequence number. You must be connected to a recovery catalog when issuing a REPORT SCHEMA command with an AT clause."

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/managing-recovery-catalog.html#GUID-2491887B-D9AC-48BE-914D-CB0341A77057