Download Oracle.1z0-083.VCEplus.2020-04-15.85q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-083 |
| Exam Name: | Oracle Database Administration II |
| Date: | Apr 15, 2020 |
| File Size: | 2 MB |
| Downloads: | 1 |
Demo Questions
Question 1
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: CEF
Explanation:
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2 Reference: https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027 https://blogs.oracle.com/oem/how-to-clear-an-alert-v2
Question 2
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: CE
Question 3
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: EF
Explanation:
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-removing-pdbs-with-sql-plus.html#GUID-1C47D543-8376-48AE-A1AE-632316731D59 Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-removing-pdbs-with-sql-plus.html#GUID-1C47D543-8376-48AE-A1AE-632316731D59
