PrepAway - Latest Free Exam Questions & Answers

What will happen when the following query is executed?

What will happen when the following query is executed?
SELECT * FROM STREAM(quotes);

PrepAway - Latest Free Exam Questions & Answers

A.
A syntax error will be returned.

B.
Other applications trying to insert rows into the QUOTES table will block until the query ends.

C.
There will be as many rows returned as there are in the QUOTES table and then query will end
immediately.

D.
There will be as many rows returned as there are in the QUOTES table and then query will block
and wait for more rows to be inserted.


Leave a Reply