Question

Which command displays the sql command in the sql buffer and then executes it mcq?

Answer 1

SELECT EMP_NUM, EMP_LNAME, EMP_FNAME, Sum(INV_TOTAL) AS TOTALINVOICES FROM LGINVOICE, LGEMPLOYEE WHERE EMP_NUM = EMPLOYEE_ID GROUP BY EMP_NUM, EMP_LNAME, EMP_FNAME ORDER BY EMP_LNAME, EMP_FNAME

Answer 2

The RUN command displays the SQL command in the SQL buffer and then executes it.

• To execute the block of SQL buffer we can use the RUN command.
• It will display The SQL command in the buffer before executing it.
• The command remains in the buffer until it is replaced by the next command of SQL.
• We can also use the //(slash) command but it will only execute the command in buffer and will not display it.