SQL 面试题与答案
Test your skills through the online practice test: SQL Quiz Online Practice Test
问题 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.
这有帮助吗？
添加评论
查看评论
问题 87. Which command displays the SQL command in the SQL buffer, and then executes it?
RUN.
这有帮助吗？
添加评论
查看评论
问题 88. What command is used to get back the privileges offered by the GRANT command?
REVOKE.
这有帮助吗？
添加评论
查看评论
问题 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.
这有帮助吗？
添加评论
查看评论
问题 90. Which date function is used to find the difference between two dates?
MONTHS_BETWEEN.
这有帮助吗？
添加评论
查看评论
用户评价最有帮助的内容：