READ Free Dumps For Oracle- 1z0-007

Question ID 8017	Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do?
Option A	The set of statements contains an error and does not work.
Option B	It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
Option C	It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
Option D	It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
Option E	It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.
Option F	It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
Correct Answer	C

Explanation Explanation/Reference: Explanation : the statement will create a role call REGISTRAR, grant UPDATE on student_grades to registrar, grant the role to user1,user2 and user3. Incorrect answer : A the statement does not contain error B there is no MODIFY privilege D statement does not create 3 users with the role E privilege is grant to role then grant to user F privilege is grant to role then grant to user

Question ID 8018	Which two statements about subqueries are true? (Choose two.)
Option A	A subquery should retrieve only one row.
Option B	A subquery can retrieve zero or more rows.
Option C	A subquery can be used only in SQL query statements.
Option D	Subqueries CANNOT be nested by more than two levels
Option E	A subquery CANNOT be used in an SQL query statement that uses group functions.
Option F	When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
Correct Answer	BF

Explanation Explanation Explanation/Reference: Explanation : subquery can retrieve zero or more rows, subquery is used with an inequality camparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column. Incorrect answer : A subquery can retrieve zero or more rows C subquery is not SQL query statement D subquery can be nested E group function can be use with subquery

Previous-Page 1 2. . . 136 137 138 139 140 141 142. . . 160 161 Next-Page

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