Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Given a table named MY_TABLE containing 10 rows, which of the following sampling queries is guaranteed to return exactly 5 rows?
A
SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);
B
SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);
C
SELECT * FROM MY_TABLE SAMPLE (5 ROWS);
D
SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);
