Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 516

Which command would return an empty sample?

select * from testtable sample ();

select * from testtable sample (0);

select * from testtable sample (null);

select * from testtable sample (none);

Correct Answer: B

The correct command to return an empty sample is 'select * from testtable sample (0);'. In SQL, using 'sample (0)' will instruct the database to return none of the rows in the table, hence resulting in an empty result set.

Discussion

bibisaOption: B

from doc: Return an empty sample: SELECT * FROM testtable SAMPLE ROW (0);

ShagunMittalOption: B

B is correct

dementorOption: B

Correct. Tested!

_yyuktaOption: B

B. select * from testtable sample (0);

MultiCloudIronManOption: B

correct