HP Exam Questions

Which SQLCI command sequence provides statistics about a query?

Which SQLCI command sequence provides statistics about a query?

A.
DISPLAY STATISTICS; SELECT COUNT (*) FROM TABLE;

B.
SELECT COUNT (*) FROM TABLE; SET STATISTICS ON;

C.
SELECT STATISTICS ON; SELECT COUNT (*) FROM TABLE;

D.
SET SESSION STATISTICS ON; SELECT COUNT (*) FROM TABLE;