Question 1

Structure of the ORDERS table
 
-Based upon the structure of the ORDERS table, which of the following SQL statements will return an error message upon execution?

Accepted Answer

A)   SELECT * FROM orders;
B)   SELECT order# customer# FROM orders;
C)   SELECT order#, "order number" FROM orders;
D)   both b and cE) B) and D)
F) C) and D)

Question 2

Which of the following symbols can be used to combine data from different columns into one column of output?

Accepted Answer

A)   ||
B)   ^
C)   %
D)   *E) All of the above
F) None of the above

Exam 2: Basic Sql Select Statements

Structure of the ORDERS table -Based upon the structure of the ORDERS table, which of the following SQL statements will return an error message upon execution?

Correct Answer
verified

Which of the following symbols can be used to combine data from different columns into one column of output?

Correct Answer
verified

Exam 2: Basic Sql Select Statements

Structure of the ORDERS table -Based upon the structure of the ORDERS table, which of the following SQL statements will return an error message upon execution?

Correct AnswerverifiedShow Answer

Which of the following symbols can be used to combine data from different columns into one column of output?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified