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

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

#111. Which privilege is required to create a database?

#112. Examine the command:

 CREATE TABLE employee 
 ( employee_id NUMBER CONSTRAINT employee_empid_pk 
 PRIMARY KEY, 
 employee_name VARCNAR2(30), 
 manager_id NUMBER CONSTRAINT employee_mgrid_fk 
 REFERENCES employee(employee_id));

The EMP table contains self referential integrity requiring all NOT NULL values inserted in the MANAGER_ID column to exist in the EMPLOYEE_ID column. Which view or combination of views is required to return the name of the foreign key constraint and the referenced primary key?

#113. You need to know how many data files were specified as the maximum for the database when it was created. You did not create the database and do not have the script used to create the database. How could you find this information?

#114. Evaluate the SQL command:

 CREATE TEMPORARY TABLESPACE temp_tbs 
 TEMPFILE '/usr/oracle9i/OraHome1/temp_data.dbf' 
 SIZE 2M 
 AUTOEXTEND ON;

Which two statements are true about the TEMP_TBS tablespace? (Choose two.)

#115. User Smith created indexes on some tables owned by user John.
You need to display the following:
• Index names
• Index types
Which data dictionary view(s) would you need to query?

#116. Which two statements are true about the control file? (Choose two.)

#117. Examine this TRUNCATE TABLE command:

 TRUNCATE TABLE departments;

Which four are true about the command? (Choose four.)

#118. You are logged on to a client. You do not have a secure connection from your client to the host where your Oracle database is running. Which authentication mechanism allows you to connect to the database using the SYSDBA privilege?

#119. Which two statements are true about rebuilding an index? (Choose two.)

#120. Which two statements grant an object privilege to the user Smith? (Choose two.)

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

gen. 0.071

Server date 09:00 08-01-2009

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps