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

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

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

#131. Which option lists the correct hierarchy of storage structures, from largest to the smallest?

#132. Which command would revoke the ROLE_EMP role from all users?

#133. You are experiencing intermittent hardware problems with the disk drive on which your control file is located. You decide to multiplex your control file. While your database is open, you perform these steps:
1. Make a copy of your control file using an operating system command.
2. Add the new file name to the list of files for the CONTROL FILES parameter in your text initialization parameter file using an editor.
3. Shut down the instance.
4. Issue the STARTUP command to restart the instance, mount, and open the database. The instance starts, but the database mount fails.
Why?

#134. Tom was allocated 10 MB of quota in the USERS tablespace. He created database objects in the USERS tablespace. The total space allocated for the objects owned by Tom is 5 MB. You need to revoke Tom's quota from the USERS tablespace. You issue this command:

 ALTER USER Tom QUOTA 0 ON users;

What is the result?

#135. SALES_DATA is a non-temporary tablespace. You have set the SALES_DATA tablespace OFFLINE by issuing this command:

 ALTER TABLESPACE sales_data OFFLINE NORMAL;

Which three statements are true? (Choose three.)

#136. Where does Oracle store the database creation time stamp?

#137. Which statement about multiplexing an existing control file is true?

#138. When starting an instance, during which state is the control file read?

#139. What should you do immediately after you add a data file to an existing database?

#140. Media failure has occurred and you have lost all the copies of the control file for the PROD database.
Which statement about the PROD database is true?

[1] ... [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] [21] ... [37]

gen. 0.076

Server date 08:52 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps