Multiple choice technology databases

A file rahul.db2 has following content : Drop procedure rahul ( ) @ Create procedure rahul ( ) P1: begin Declare c1 cursor with return to client for Select current date from sysibm.sysdummy1; Open c1; End P1 @ What will following command do when fired on db2 command linedb2 –td@ -f rahul.db2

  1. NO SQL

  2. CONTAINS SQL

  3. READS SQL

  4. MODIFIES SQL
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The script drops a procedure and creates a new one that contains a SELECT statement. Since it modifies database objects (DROP and CREATE), it requires MODIFIES SQL DATA clause. The other options are for less restrictive operations.

Keep practicing — related questions