READ Free Dumps For Oracle- 1z0-007

Question ID 8007	Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true? (Choose two.)
Option A	MANAGER must be a role.
Option B	It allows the MANAGER to pass the specified privileges on to other users.
Option C	It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
Option D	It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
Option E	It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
Option F	It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
Correct Answer	BE

Explanation Explanation/Reference: Explanation : GRANT ROLE to ROLE/USER Incorrect answer : A Role can be grant to user C Create table privilege is not granted D Execute privilege is not granted F Delete privilege is not granted Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 13-15

Question ID 8008	Which best describes an inline view?
Option A	a schema object
Option B	a subquery that can contain an ORDER BY clause
Option C	another name for a view that contains group functions
Option D	a subquery that is part of the FROM clause of another query
Correct Answer	D

Explanation Explanation/Reference: Explanation : a subquery that is part of the FROM clause of another query Incorrect answer : A is not a schema object B subquery can contain GROUP BY clause as well. C does not necessary contains group functions Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 11-21

Previous-Page 1 2. . . 131 132 133 134 135 136 137. . . 160 161 Next-Page

Send email to admin@getfreedumps for new dumps request!!!