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

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

#161. Which structure provides for statement-level read consistency?

#162. You can use the Database Configuration Assistant to create a template using an existing database structure. Which three will be included in this template? (Choose three.)

#163. You are going to create a new database. You will NOT use operating system authentication. Which two files do you need to create before creating the database? (Choose two.)

#164. You omit the UNDO tablespace clause in your CREATE DATABASE statement. The UNDO_MANAGEMENT parameter is set to AUTO. What is the result of your CREATE DATABASE statement?

#165. What provides for recovery of data that has not been written to the data files prior to a failure?

#166. Which two statements are true about identifying unused indexes? (Choose two.)

#167. Anne issued this SQL statement to grant Bill access to the CUSTOMERS table in Anne's schema:

 GRANT SELECT ON customers TO bill WITH GRANT OPTION;

Bill issued this SQL statement to grant Claire access to the CUSTOMERS table in Anne's schema:

 GRANT SELECT ON anne.customers TO claire;

Later, Anne decides to revoke the select privilege on the CUSTOMERS table from Bill.
Which statement correctly describes both what Anne can do to revoke the privilege, and the effect of the REVOKE command?

#168. ABC Company consolidated into one office building, so the very large EMPLOYEES table no longer requires the OFFICE_LOCATION column. The DBA decided to drop the column using the syntax below:

 ALTER TABLE hr.employees 
 DROP COLUMN building_location 
 CASCADE CONSTRAINTS;

Dropping this column has turned out to be very time consuming and is requiring a large amount of undo space. What could the DBA have done to minimize the problem regarding time and undo space consumption?

#169. A user calls and informs you that a 'failure to extend tablespace' error was received while inserting into a table. The tablespace is locally managed.
Which three solutions can resolve this problem? (Choose three.)

#170. During a checkpoint in an Oracle9i database, a number of dirty database buffers covered by the log being checkpointed are written to the data files by DBWn. Which parameter determines the number of buffers being written by DBWn?

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

gen. 0.059

Server date 08:53 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps