01. While backing up to SBT channel , the read phase of compressed RMAN incremental level 0 backup is a bottleneck. FORCE LOGGING is enables for the database. Choose 2 options to improve performance
a. Increase the size of tape IO buffers
b. Disable FORCE LOGGING.
c. Increase DB buffer cache size.
d. Enable asynchronous IO
e. Increase the level of RMAN multiplexing.
Answer : d,e
02. Which 2 are true of RMAN diagnostic message output?
a. Media management messages for SBT devices are always written to SBTIO log.
b. RMAN error stacks should always be read from the bottom up.
c. RMAN error stacks should always be read top down.
d. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
e. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
f. Media management messages for SBT devices are written to an Oracle trace file.
Answer : b,e
03. 3 things true of Optimizer Statistics Adviser
a) It can be run only manually.
b) It is part of the DBMS_ADVISOR package.
c) It can recommend changes to improve the statistics gathering process.
d) It always analyzes all schemas in the database.
e) It runs automatically every night by default.
f) It is part of the DBMS_STATS package.
4. A user complaints about poor database performance. You want to check if user session has waited for certain IO activity.
Which view displays all wait events by a session at least once?
a) V$SESSION_EVENT
b) V$SESSTAT
c) V$SESSION_WAIT
d) V$SESSION_WAIT_CLASS
e) V$SESSION
5. Database is in ARCHIVELOG mode. Full RMAN backup is taken and no backup to trace has been taken of the control file. A media failure has occurred. In which 2 scenarios is complete recovery possible?
a) when any archived log from, before, or after the most recent backup is corrupt.
b) after losing all copies of the control file
c) after losing an archived log from after the most recent backup
d) after losing an archived log from before the most recent backup
e) after losing the SYSTEM tablespace
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
a. Taking of AWR snapshots can be disabled
b. Its collection level can be determined by the value of STATISTICS_LEVEL database parameter
c. AWR report is stored in SYSTEM Tablespace
d. By default, AWR report can be taken every 60 minutes
e. By default, AWR snapshots are retained for 7 days
No comments:
Post a Comment