PL PGSQL

A stored procedure in SQL is a___________

• Block of functions
• Group of Transact-SQL statements compiled into a single execution plan.
• Group of distinct SQL statements.
• None of the mentioned

Temporary stored procedures are stored in _________ database.

• Master
• Model
• User specific
• Temp

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

• Procedures
• Triggers
• Functions
• None of the mentioned

Triggers are supported in

• Delete
• Update
• Views
• All of the mentioned

What are the after triggers?

• Triggers generated after a particular operation
• These triggers run after an insert, update or delete on a table
• These triggers run after an insert, views, update or delete on a table
• All of the mentioned

Which loop construct is used in PL/pgSQL for iterating over a range of values?

• WHILE loop
• FOR loop
• DO loop
• LOOP loop

Which of the following is an PostgreSQL-supported trigger?

• BEFORE
• INSTEAD OF
• AFTER
• all of above

What of the following are types of triggers?

• Define, Create
• Drop, Comment
• Insert, Update, Delete
• All of the mentioned

Triggers ________ enabled or disabled

• Can be
• Cannot be
• Ought to be
• Always

What is the symbol for assignment operator in PL/SQL?

• ==
• =>
• :=
• _=