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 86. 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.

Is it helpful? Yes No Add Comment View Comments

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

RUN.

Is it helpful? Yes No Add Comment View Comments

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

REVOKE.

Is it helpful? Yes No Add Comment View Comments

Ques 89. What will be the output of the following query?
SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );?

NO.
Explanation : The query checks whether a given string is a numerical digit.

Is it helpful? Yes No Add Comment View Comments

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

MONTHS_BETWEEN.

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 86. 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;?

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

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

Ques 89. What will be the output of the following query?
SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );?

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

About Withoutbook

Social Links

Quick Links

SQL Interview Questions and Answers

Related differences

Ques 86. 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;?

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

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

Ques 89. What will be the output of the following query? SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );?

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

About Withoutbook

Social Links

Quick Links

Ques 89. What will be the output of the following query?
SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );?