1Z0-030 Oracle - Braindumps.com.ua: question list for "Oracle 9i: New Features For Administrators", page: 7

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

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-030: Oracle 9i: New Features For Administrators

#61. What are three benefits of performing data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause? (Choose three.)

#62. What does the Metadata Application Programming Interface (API) allow you to do?

#63. Which two are true regarding a list-partitioned table? (Choose two.)

#64. Which two are true regarding automatic space management segments? (Choose two.)

#65. Which three parameters are ignored when creating an automatic space management segment? (Choose three.)

#66. A bitmap join index is defined as __________.

#67. What is true regarding fact tables having bitmap join indexes defined on them?

#68. Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by 'safe literals only'?

#69. When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view?

#70. The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these SELECT statements in the order shown below:

 SELECT * FROM employees WHERE department _id=50; 
 SELECT * FROM employees WHERE department_id=70;

There is an index on the DEPARTMENT ID column of the 1,000,000 row EMPLOYEES table.
Ninety percent of the employees are part of DEPARTMENT_ID 50.
In which two scenarios will Oracle9i share the corresponding cursors for the two statements? (Choose two.)

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

gen. 0.149

Server date 06:32 22-11-2008

Oracle 1Z0-030

Forum

Start online exam simulation

Master braindump

User braindumps