Consider the my_table table with two integer columns, a and b, and the contents as shown;
Mysql > SELECT a, b FROM my_table;
1 row in set result of this query?
SELECT ab -
FROM my_table;
1z0-882 Exam QuestionsBrowse all questions from this exam
1z0-882 Exam - Question 17
Show AnswerHide Answer
Correct Answer: D
The SQL query "SELECT ab - FROM my_table;" is syntactically incorrect. In SQL, proper column names and operators must be used. The query is likely intended to perform some operation between columns 'a' and 'b', but the minor syntax error makes it invalid, resulting in an error message from the SQL interpreter.
Discussion
2 commentsLaraOption: D
Feb 14, 2019I tested this one out and the answer is D.
chehinOption: D
May 30, 2022Vote for D