SQL 면접 질문과 답변
Test your skills through the online practice test: SQL Quiz Online Practice Test
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.
도움이 되었나요?
Add Comment
View Comments
Ques 87. Which command displays the SQL command in the SQL buffer, and then executes it?
RUN.
도움이 되었나요?
Add Comment
View Comments
Ques 88. What command is used to get back the privileges offered by the GRANT command?
REVOKE.
도움이 되었나요?
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.
도움이 되었나요?
Add Comment
View Comments
Ques 90. Which date function is used to find the difference between two dates?
MONTHS_BETWEEN.
도움이 되었나요?
Add Comment
View Comments
Most helpful rated by users: