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

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

#41. The Dynamic SGA feature allows the SGA to grow and shrink dynamically according to an ALTER SYSTEM command.
This avoids the previous need of shutting down the instance in order to modify the components of the SGA, namely the buffer cache and shared pool components.
Which three statements are true for the Dynamic SGA feature? (Choose three.)

#42. What is true about version-enabled tables?

#43. Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature? (Choose three.)

#44. Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated? (Choose three.)

#45. There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice if you want to reduce the impact of long running operations on other users without aborting the long running operations?

#46. What do you need to do in order for the Database Resource Manager to estimate, in advance, the execution time of a statement?

#47. Online index rebuild functionality has been extended to include which four index structures? (Choose four.)

#48. The database was started up using a text parameter file.
What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?

#49. Examine the statement:

 ALTER TABLE sales 
 EXCHANGE PARTITION q1_2000 
 WITH TABLE sales q1_2000 
 UPDATE GLOBAL INDEXES 
 PARALLEL (DEGREE 4);

What is the result of the statement?

#50. Which command can you use to alter the active size of the SGA dynamically, where the entered value differs from the current one?

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

gen. 0.103

Server date 07:41 22-11-2008

Oracle 1Z0-030

Forum

Start online exam simulation

Master braindump

User braindumps