1Z0-083 Exam Dumps – Our Features

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.)

• Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• Add only the CREATE_FILE_DEST clause to the statement.
• Set only the PDB_FILE_NAME_CONVERT parameter.
• Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
• Enable only OM
• Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)

Choose two. Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance?

• The entire PGA is located in the System Global Area (SGA) when using shared servers.
• PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
• The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
• The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
• Sorts and Hash Joins use PGA memory.

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

• A target database’s persistent RMAN configuration settings are always stored in the target’s control file
• Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
• The RMAN SHOW ALL command displays only settings with nondefault values.
• A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• The V$RMAN_CONFIGURATION view displays only settings with valuesthat have been modified. G)A DBA must specify either a redundancy retention policy or a recovery window retention policy.

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

• Decreasing PCTUSED
• Decreasing PCTFREE
• Increasing the number of DBWN process
• Using Automatic Segment Space Management (ASSM)
• Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation

Which three are true about Automatic Workload Repository (AWR) snapshots?

• They are generated if STATISTICS_LEVEL is set to TYPICAL.
• They are always created manually.
• They are always created automatically.
• They are generated if STATISTICS_LEVEL is set to BASIC.
• They are generated if STATISTICS_LEVEL is set to ALL.
• They can be retained forever.

Choose three. Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?

• the data dictionary in CDB$ROOT
• the log writer process (LGWR)
• SYSAUX tablespaces
• temporary tablespaces
• the Process Monitor Process (PMON)
• undo tablespaces

Choose two. A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required?

• after losing all members of the CURRENT online redo log group
• after losing all copies of the control file
• after losing an UNDO tablespace that is in use
• after losing all members of an INACTIVE online redo log group
• after losing a SYSAUX tablespace data file

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• It recompiles all stored PL/SQL code by using utlrp.sql.
• It empties the RECYCLE BIN.
• It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• It sets all user tablespaces to “read-only” before starting the upgrade.
• It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• It increases tablespace size, if required, to meet upgrade requirements.

Choose the best answer. How do you configure a CDB for local undo mode?

• Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.
• Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
• Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
• Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.
• Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

Which two are true about Oracle instance recovery? (Choose three.)

• Recovery begins from the beginning of the CURRENT redo log group.
• Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
• Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
• Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
• Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
• Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.