File Info
| Exam | Oracle Database 12c: Advanced Administration |
| Number | 1z0-063 |
| File Name | Oracle.1z0-063.SelfTestEngine.2019-06-03.143q.tqb |
| Size | 1 MB |
| Posted | Jun 03, 2019 |
| Download | Oracle.1z0-063.SelfTestEngine.2019-06-03.143q.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
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
- Database Replay
- Automatic Database Diagnostic Monitor (ADDM) Compare Period report
- Active Session History (ASH) report
- SQL Performance Analyzer
Correct answer: B
Explanation:
Reference:http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm Reference:
http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm
Question 2
Which three statements are true about a job chain? (Choose three.)
- It can contain a nested chain of jobs.
- It can be used to implement dependency-based scheduling.
- It cannot invoke the same program or nested chain in multiple steps in the chain.
- It cannot have more than one dependency.
- It can be executed using event-based or time-based schedules.
Correct answer: ABE
Explanation:
Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12459 Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#ADMIN12459
Question 3
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)
- The current online redo log file is missing.
- A data file belonging to a noncritical tablespace is missing.
- All the control files are missing.
- The control file backup is older than the database backup.
- All the data files are missing.
Correct answer: CD
Explanation:
Reference:http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel Reference:
http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel
