Oracle Database Administration II

Here you have the best Oracle 1z0-083 practice exam questions

  • You have 181 total questions to study from
  • Each page has 5 questions, making a total of 37 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on October 30, 2024
Question 1 of 181

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

    Correct Answer: B, C, E

    Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY, making this statement true. A space usage management alert is automatically cleared after the underlying problem is resolved, which is also correct. Metrics are statistical counts for a specific unit, making this statement accurate as well. Not all metrics are instance related, alerts are not generated by SMON when a tablespace is 97% full, and STATISTICS_LEVEL does not need to be set to ALL to generate alerts, as TYPICAL is sufficient.

Question 2 of 181

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.

FORCE LOGGING is enabled for the database.

Which two could improve read performance? (Choose two.)

    Correct Answer: D, E

    To improve the read performance during the RMAN incremental level 0 backup, enabling asynchronous disk I/O allows multiple I/O operations to be initiated before waiting for any to complete, enhancing efficiency. Additionally, increasing the level of RMAN multiplexing helps by allowing more simultaneous read operations, which can further speed up the backup process by filling tape buffers faster and ensuring that the system handles more data concurrently.

Question 3 of 181

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

    Correct Answer: D, F

    The USER_TABLESPACE clause in the CREATE PLUGGABLE DATABASE command can be used to specify the list of user tablespaces when moving a non-CDB to a PDB. This is useful for migrating specific data without bringing unnecessary tablespaces, which optimizes space and minimizes migration time. Additionally, it can specify the list of tablespaces to include when creating a PDB from the CDB seed. This allows for defining which user tablespaces should exist in the newly created PDB, ensuring that the necessary schema and data structures are available right from the start. These use cases leverage the flexibility of the USER_TABLESPACE clause to manage database resources effectively.

Question 4 of 181

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

    Correct Answer: A, B, F

    FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time. The RECYCLEBIN parameter is not involved in FLASHBACK version query, and FLASHBACK DATA ARCHIVE does not rely on undo to store all row versions. Therefore, the correct answers are that FLASHBACK operations requiring undo are FLASHBACK transaction query and FLASHBACK version query, and FLASHBACK drop requires the RECYCLEBIN to be set to ON.

Question 5 of 181

Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx-preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

    Correct Answer: B, C, D

    The Oracle Preinstallation RPM performs several key actions to prepare the system for Oracle Grid Infrastructure installation. It creates the oracle OS user, which is necessary for running Oracle software. It also creates the OSDBA (dba) group, which is required for database administration privileges, and the oraInventory (oinstall) group, which is used to manage Oracle software installations. These three actions are essential steps carried out by the Oracle Preinstallation RPM to ensure the system is properly configured for Oracle Grid Infrastructure.