Sample Exam Questions

From the objective of OSS-DB Exam Gold
- Monitoring Performance - Execution plans

Sample Question

1.07

The EXPLAIN command can be used to display the execution plan of a query.
Select all the SQL commands that are correct as the target of the EXPLAIN command.

  1. DELETE

  2. DROP TABLE

  3. REINDEX

  4. PREPARE

  5. EXECUTE

※This sample exam is different from those that appear in the actual OSS-DB Exam.
2025/05/30

Answer and Explanation

The EXPLAIN command can be used to generate execution plans for the following SQL commands:
SELECT
INSERT
UPDATE
DELETE
VALUES
EXECUTE
DECLARE
CREATE TABLE AS
CREATE MATERIARIZED VIEW
REFRESH MATERIALIZED VIEW

Therefore, the correct answers are A and E.