File Info
| Exam | Oracle Database Administration II |
| Number | 1z0-083 |
| File Name | Oracle.1z0-083.VCEplus.2020-04-15.85q.tqb |
| Size | 2 MB |
| Posted | Apr 15, 2020 |
| Download | Oracle.1z0-083.VCEplus.2020-04-15.85q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
