|
|
Oracle 1z0-032: Oracle 9i: Database Fundamentals II
|
#1. When performing incomplete recovery using UNTIL SEQUENCE with RMAN, which two pieces of information are required? (Choose two)
|
|
#2. Online index rebuild functionality has been extended to include which four index structures? (Choose four)
|
|
#3. Examine the list of variables and their data types: NAME DATA Type
TS, TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS, IDSI INTERVAL YEAR To SECOND Which three expressions using the new data and time data types are valid? (Choose three)
|
|
#4. Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (- 2> ownname => ‘OE’, - 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, - 4> method opt => ‘FOR ALL columns SIZE AUTO’);
What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option?
|
|
#5. Which two are true regarding external tables? (Choose two)
|
|
#6. When does Oracle 9i flag an index as being used in the V$OBJECT_USAGE view?
|
|
#7. Using a bitmap structure to manage database object space has several benefits over using free list structures. Which three are benefits of managing space using automatic segment- space managed objects? (Choose three)
|
|
#8. The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?
|
|
#9. You can control instance recover performance by setting parameters to define targets for ______.
|
|
#10. Which three statements are true about the privileged connection options available in Oracle 9i? (Choose three)
|
|
|
|
 gen. 0.065
|
Server date 09:08 15-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
1z0-032 certification
1z0-032 master dump