1Z0-031 Oracle - Braindumps.com.ua: question list for "Oracle9i: Database Fundamentals I", page: 10

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-031: Oracle9i: Database Fundamentals I

#91. Which initialization parameter determines the location of the alert log file?

#92. Which password management feature ensures a user cannot reuse a password for a specified time interval?

#93. Which data dictionary view(s) do you need to query to find the following information about a user? • Whether the user's account has expired
• The user's default tablespace name
• The user's profile name

#94. You need to create an index on the SALES table, which is 10 GB in size. You want your index to be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability. Which type of index would be best for this table?

#95. Which statement should you use to obtain information about the number, names, status, and location of the control files?

#96. The current password file allows for five entries. New DBAs have been hired and five more entries need to be added to the file, for a total of ten. How can you increase the allowed number of entries in the password file?

#97. Which table type should you use to provide fast key-based access to table data for queries involving exact matches and range searches?

#98. You need to shut down your database. You want all of the users who are connected to be able to complete any current transactions. Which shutdown mode should you specify in the SHUTDOWN command?

#99. You set the value of the OS_AUTHENT_PREFIX initialization parameter to OPS$ and created a user account by issuing this SQL statement:

 CREATE USER OPS$smith 
 IDENTIFIED EXTERNALLY;

Which two statements are true? (Choose two.)

#100. Which two statements about segments are true? (Choose two.)

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

gen. 0.07

Server date 06:40 22-11-2008

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps