SQL Interview Questions and Answers

Prepare for your Interview today!

Test your skills through the online practice test: SQL Quiz Online Practice Test

Related differences

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

True.

Is it helpful? Yes No 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? Yes No 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? Yes No 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? Yes No Add Comment View Comments

Ques 85. Which command executes the contents of a specified file?

START or @.

Is it helpful? Yes No Add Comment View Comments

Most helpful rated by users:

About Withoutbook

This site contains most of the quality computer technologies which can help all the related students and employees. We have large number of interview questions and answers, online test, difference between on many subjects.

SQL Interview Questions and Answers

Related differences

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

Ques 82. What will be the output of the following query?

Ques 83. What does the following query do? SELECT SAL + NVL(COMM,0) FROM EMP;

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

Ques 85. Which command executes the contents of a specified file?

About Withoutbook

Social Links

Quick Links