1Z0-007 Oracle - Braindumps.com.ua: question list for "Introduction to Oracle9i: SQL", page: 21

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-007: Introduction to Oracle9i: SQL

#201. Why would you NOT create an index on a column in the CLASS_SCHEDULE table?

#202. Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

#203. Which two statements accurately describe a role? (Choose two.)

#204. Scott issues the SQL statements:

 CREATE TABLE dept 
 (deptno NUMBER(2), 
 dname VARCHAR2(14), 
 loc VARCHAR2(13)}; 
 GRANT SELECT 
 ON DEPT 
 TO SUE;

If Sue needs to select from Scott's DEPT table, which command should she use?

#205. Which statement creates a new user?

#206. What is true about the WITH GRANT OPTION clause?

#207. You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.
Which statement accomplishes this?

#208. When should you create a role? (Choose two)

#209. The DBA issues this SQL command:

 CREATE USER scott 
 IDENTIFIES BY tiger;

What privileges does the user Scott have at this point?

#210. You granted user Joe the INDEX and REFERENCES privileges on the INVENTORY table. Which statement did you use?

[1] ... [21] [22] [23] [24] [25] [26] [27] [28] [29] [30] [31] ... [31]

gen. 0.062

Server date 04:54 08-01-2009

Oracle 1Z0-007

Forum

Start online exam simulation

Master braindump

User braindumps