1z0-032 Oracle - Braindumps.com.ua: question list for "Oracle 9i: Database Fundamentals II", page: 1

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

car insurance quotes (1)

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

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)

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [37]

gen. 0.074

Server date 06:03 22-08-2008

Oracle 1z0-032

Forum

Start online exam simulation

Master braindump

User braindumps