File Info
| Exam | Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP |
| Number | 1z0-067 |
| File Name | Oracle.1z0-067.PracticeTest.2019-02-09.139q.tqb |
| Size | 1 MB |
| Posted | Feb 09, 2019 |
| Download | Oracle.1z0-067.PracticeTest.2019-02-09.139q.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?
- 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:
Tuning RMAN Backup Performance: Procedure Many factors can affect backup performance. Often, finding the solution to a slow backup is a process of trial and error. To get the best performance for a backup, follow the suggested steps in this section: Step 1: Remove RATE Parameters from Configured and Allocated Channels Step 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVES Step 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZE Step 4: Tune RMAN Tape Streaming Performance Bottlenecks Step 5: Query V$ Views to Identify Bottlenecks https://docs.oracle.com/database/121/BRADV/rcmtunin.htm#BRADV172 Tuning RMAN Backup Performance: Procedure Many factors can affect backup performance. Often, finding the solution to a slow backup is a process of trial and error. To get the best performance for a backup, follow the suggested steps in this section: Step 1: Remove RATE Parameters from Configured and Allocated Channels Step 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVES Step 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZE Step 4: Tune RMAN Tape Streaming Performance Bottlenecks Step 5: Query V$ Views to Identify Bottlenecks https://docs.oracle.com/database/121/BRADV/rcmtunin.htm#BRADV172
Question 2
For which three pieces of information can you use the RMAN list command?
- 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:
About the LIST Command: 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 http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585 About the LIST Command: 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 http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585
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:
References: http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm References: http://docs.oracle.com/cd/E24628_01/server.121/e17635/tdppt_degrade.htm
