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;?
sal = 11000, comm = 1000.
Question 7 :
Which command displays the SQL command in the SQL buffer, and then executes it?
Question 8 :
What command is used to get back the privileges offered by the GRANT command?
Question 9 :
What will be the output of the following query?
SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', '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?