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

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

#151. Evaluate this SQL command:

 GRANT REFERENCES (employee_id), 
 UPDATE (employee_id, salary, commission_pct) 
 ON hr.employees 
 TO oe;

Which three statements correctly describe what user OE can or cannot do? (Choose three.)

#152. Bob is an administrator who has FULL DBA privileges. When he attempts to drop the DEFAULT profile as shown below, he receives the error message shown. Which option best explains this error?
SQL> drop profile SYS.DEFAULT;
drop profile SYS.DEFAULT
*
ERROR at line 1:
ORA-00950: invalid DROP option

#153. When an Oracle instance is started, background processes are started. Background processes perform which two functions? (Choose two.)

#154. You need to enforce these two business rules:
1. No two rows of a table can have duplicate values in the specified column.
2. A column cannot contain null values.
Which type of constraint ensures that both of the above rules are true?

#155. Which three are the physical structures that constitute the Oracle database? (Choose three.)

#156. An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the database is reopened?

#157. Examine the SQL statement:

 CREATE TABLESPACE user_data 
 DATAFILE '/u01/oradata/user_data_0l.dbf' SIZE 100M 
 LOCALLY MANAGED UNIFORM SIZE 1M 
 AUTOMATIC SEGMENT SPACE MANAGEMENT;

Which part of the tablespace will be of a uniform size of 1 MB?

#158. The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The indexes become fragmented. Which statement is true?

#159. When preparing to create a database, you should be sure that you have sufficient disk space for your database files. When calculating the space requirements you need to consider that some of the files may be multiplexed.Which two types of files should you plan to multiplex? (Choose two.)

#160. You want to limit the number of transactions that can simultaneously make changes to data in a block, and increase the frequency with which Oracle returns a block back on the free list. Which parameters should you set?

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

gen. 0.069

Server date 08:13 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps