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);*_
