Multiple choice technology databases

How to see the time of execution of an SQL Statement.

  1. set timing on select * from EMP

  2. set time on select * from EMP

  3. time on select * from EMP

  4. set timings on select * from EMP
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The correct SQL*Plus command is 'SET TIMING ON' before executing the query. This displays elapsed time for each SQL statement executed.

Keep practicing — related questions