File Info
| Exam | Oracle Database 12c: Advanced Administration |
| Number | 1z0-063 |
| File Name | Oracle.1z0-063.TestKing.2019-12-26.157q.tqb |
| Size | 1 MB |
| Posted | Dec 26, 2019 |
| Download | Oracle.1z0-063.TestKing.2019-12-26.157q.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
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)
- Set the backup_tape_io_slaves parameter to true.
- Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
- Configure large pool if not already done.
- Remove the rate parameter, if specified, in the allocate channel command.
- Always use RMAN compression for tape backups rather than the compression provided by media manager.
- Always use synchronous I/O for the database.
Correct answer: BCD
Explanation:
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm
Question 2
For which three pieces of information can you use the RMAN list command? (Choose three.)
- stored scripts in the recovery catalog
- available archived redo log files
- backup sets and image copies that are obsolete
- backups of tablespaces
- backups that are marked obsolete according to the current retention policy
Correct answer: ABD
Explanation:
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htmhttp://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585The primary purpose of the LIST command is to list backup and copies. For example, you can list:Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file Backups that have expired Backups restricted by time, path name, device type, tag, or recoverability Archived redo log files and disk copies Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585
The primary purpose of the LIST command is to list backup and copies. For example, you can list:
- Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file
- Backups that have expired
- Backups restricted by time, path name, device type, tag, or recoverability
- Archived redo log files and disk copies
Question 3
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
