Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 98

Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

    Correct Answer: B

    The default column for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement is the first column in the first SELECT of the compound query. This is because, by default, SQL uses the first column specified in the first SELECT clause for ordering the results unless an explicit ORDER BY clause is provided.

Discussion
NelitaOption: B

B IS CORRECT

jfc1Option: B

B is correct

McromeoOption: B

B is right solution

kuffOption: B

B is the answer

Rik92Option: B

B is correct

dexdinh91Option: B

B is correct

Viviana3184Option: B

B is correct

cspro2410Option: B

B for sure

Babi265Option: B

Definitely B

yaya32Option: B

B for me

lucemqyOption: B

Definitely B!

ESZOption: B

B IS CORRECT

NelitaOption: B

B IS CORRECT

pmeyerOption: B

B is correct