Download Oracle Database Administration II.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 |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
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
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!