Set - 3

Question 6 :

What is the value of comm and sal after executing the following query if the initial value of 'sal' is 10000 UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;?

Answer :

sal = 11000, comm = 1000.


Question 7 :

Which command displays the SQL command in the SQL buffer, and then executes it?

Answer :

RUN.


Question 8 :

What command is used to get back the privileges offered by the GRANT command?

Answer :

REVOKE.


Question 9 :

What will be the output of the following query?

Answer :

SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );?
NO.
Explanation : The query checks whether a given string is a numerical digit.


Question 10 :

Which date function is used to find the difference between two dates?

Answer :

MONTHS_BETWEEN.