Set - 3

Question 1 :

State true or false. EXISTS, SOME, ANY are operators in SQL?

Answer :

True.


Question 2 :

What will be the output of the following query?

Answer :

SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL;?
TROUBLETHETROUBLE. p>


Question 3 :

What does the following query do?

Answer :

SELECT SAL + NVL(COMM,0) FROM EMP;?
This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary.


Question 4 :

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

Answer :

The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.


Question 5 :

Which command executes the contents of a specified file?

Answer :

START or @.