SQL Interview Questions and Answers
Test your skills through the online practice test: SQL Quiz Online Practice Test
Ques 81. State true or false. EXISTS, SOME, ANY are operators in SQL?
True.
Is it helpful?
Add Comment
View Comments
Ques 82. What will be the output of the following query?
SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL;?
TROUBLETHETROUBLE.
Is it helpful?
Add Comment
View Comments
Ques 83. What does the following query do? 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.
Is it helpful?
Add Comment
View Comments
Ques 84. What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.
Is it helpful?
Add Comment
View Comments
Ques 85. Which command executes the contents of a specified file?
START or @.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: