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 December 12, 2024

Question 1 of 181

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

All metrics are instance related.

Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.

A space usage management alert is automatically cleared after the underlying problem is resolved.

They are generated by SMON when a tablespace is 97% full.

Metrics are statistical counts for a specific unit.

STATISTICS_LEVEL must be set to ALL to generate alerts.

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

Increase the size of tape I/O buffers.

Disable FORCE LOGGING for the database.

Increase the size of the database buffer cache.

Enable asynchronous disk I/O.

Increase the level of RMAN multiplexing.

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

to specify a default tablespace in a PDB cloned from another PDB in the same CDB.

to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

to include specific user tablespaces only when relocating a PDB

to specify the list of user tablespaces to include when moving a non-CDB to a PDB

to exclude a temp tablespace when plugging in a PDB

to specify the list of tablespaces to include when creating a PDB from the CDB seed

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

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 that the RECYCLEBIN parameter be set to ON.

FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.

FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

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

performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

creating the oracle OS user

creating the OSDBA (dba) group

creating the oraInventory (oinstall) group

creating the grid OS user

configuring the OS for Oracle Automatic Storage Management shared storage access

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.