QUESTION NO: 35
Which of these is not an advantage of Oracle partitioning over manual striping? (Choose two.)
A. Each partition can be assigned to its own tablespace and datafiles.
B. Extent allocation is manual with the Oracle Partition option.
C. The cost-based optimizer can choose better-performing execution plans by pruning partitions that aren't needed by the query.
D. RAID-5 isn’t compatible with manual striping, but it is compatible with partitioning.
E. The administration of manual striping is labor-intensive.
Answer: B, D ------ is it correct??
QUESTION NO: 52
What should you do to import data and to avoid migration? (Choose two)
A. Use the CASCADE option during import
B. Use the COMPRESS option during export
C. Use the RECORDLENGTH option during export
D. Coalesce free space
E. Add a new datafile
Answer: D, E------------ is it correct??
QUESTION NO: 186
Which two statements are true regarding the use of DB_CACHE_ADVICE init.ora parameter? (Choose two)
A. Setting the parameter to READY reserves space in the buffer cache to store information about
different buffer cache sizes, but no CPU overhead is incurred.
B. Setting the parameter to READY reserves space in the shared pool to store information about
different buffer cache sizes, but no CPU overhead is incurred.
C. Setting the parameter to ON reserves space in the buffer cache to store information about different
buffer cache sizes, and CPU overhead is incurred as statistics are collected.
D. The V$DB_CACHE_ADVICE view contains information that predicts the estimated number of physical
reads for different cache sizes for each buffer cache setup in the SGA.
Answer: C, D --- should be B, D ???
QUESTION NO: 214 ( same as question 52)
You are importing a table and you want to ensure that the table is put into a single contiguous area.
There is not a single contiguous area large enough for the entire space allocated to the table.
Which two actions below could help you achieve your goal? (Choose two)
A. Use the cascade option.
B. Use the constraint option.
C. Use the primary key option.
D. Coalesce the tablespace the table is using.
E. Add a datafile large enough to meet the allocation space required to the tablespace the table is using.
Answer: D, E ---is it correct??
QUESTION NO: 222
Which three statements are true regarding STATSPACK? (Choose three)
A. STATSPACK data should be separated from production data by putting it in its own tablespace.
B. Obsolete statistical data collected by STATSPACK cannot be purged.
DBAs will need to drop the user PERFSTAT and reinstall STATSPACK.
C. To make performance comparisons from one day, week, or year to the next, there must be multiple snapshots
taken over a period of time.
D. You can capture both the complete text of a high-load SQL statement and information on any SQL plan(s)
associated with that statement in a STATSPACK report.
E. When a snapshot is taken, STATSPACK will automatically generate a report that displays the statistical output,
including load profile, efficiency percentage of the instance, and top five wait events.
Answer: A, C, D----- ???
|
