AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 7977

Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?

Option A

No change is required to achieve the desired results.

Option B

SELECT ename, sal, 12* (sal+100) FROM emp;

Option C

 SELECT ename, sal, (12* sal)+100 FROM emp;

Option D

SELECT ename, sal +100,*12 FROM emp;

Correct Answer B
Explanation Explanation/Reference: Explanation : to achieve the result you must add 100 to sal before multiply with 12. SELECT ename, sal, 12* (sal+100) FROM EMP; Incorrect answer : A Multiplication and division has priority over addition and subtraction in Operator precedence. C Give wrong results D Wrong syntax Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 1-11


Question ID 7978

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?

Option A

CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

Option B

CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

Option C

CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

Option D

CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;

Option E

CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

Correct Answer D
Explanation Explanation/Reference: Explanation : this is the correct solution for the answer. GRANT role _name to user; Incorrect answer : A there is no such MODIFY keyword B invalid CREATE command, there is no such NEW keyword C invalid GRANT command, there is no such ROLE keyword E invalid GRANT command, there is no such CHANGE keyword Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 13-10

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