请教033几题
QUESTION 181:??????
Which four activities cause a sort? (Choose four)
A. Creation of an index.
B. Execution of the ANALYZE command.
C. Use of the ORDER BY and GROUP BY clauses.
D. Use of insert operations involving index maintenance.
E. Use of the UNION, INTERSECT and MINUS operators.
Answer: A, C, D, E (个人认为应选abce)
QUESTION 175:????????
What are the three most common problems encountered while trying to tune a database?(Choose three)
A. Poor application design that does not make good use of indexes.
B. Applications not written to use bind variable to take advantage of shared SQLstatements.
C. Poor application design that require too many tables to be joined together to resolve queries.
D. Applications not closing cursors in a timely fashion because the init.ora parameter
OPEN_CURSORS was set too high.
Answer: A, B, D( abc 不确定)
QUESTION 129:????????
Which two statements are true when you are using automatic undo management?
(Choose two)
A. If you do not specify the init.ora parameter UNDO_TABLESPACE when you start
the database, Oracle will make use of all undo tablespaces within the database to store
automatic undo segments.
B. If you do not specify the init.ora parameter UNDO_TABLESPACE when you start the
database, Oracle will make use of the first undo tablespace that was created within the
database to store automatic undo segments.
C. Oracle will extend the datafiles for the undo tablespace to meet the requirements of the
time specifies by the init.ora parameter UNDO_RETENTION.
Oracle will always maintain committed transactions for this amount of time.
D. Oracle will not extend the datafiles for the undo tablespace to meet the requirements
of the time specified by the init.ora parameter UNDO_RETENTION.vol1_10-11
Oracle will attempt to maintain committed transactions for this amount of time, but may
not always be successful.
Answer: B, D (有点不确定)
QUESTION 37: ??????
Which two statements about row migration are true? (Choose two)
A. Row migration is caused by a PCTREE value set too low.
B. Row migration can be resolved using the ANALYZE command.just detecting
C. Row migration can be reduced by choosing a larger block size.
D. Row migration means that row pieces are stored in different blocks.
E. Queries that use an index to select migrated rows perform additional I/O.
Answer: A, B(ae 个人认为)
|
