Chapter 9

Which of the following is used to input the entry and give the result in a variable in a procedure?

• Put and get
• Get and put
• Out and In
• In and out

Temporary stored procedures are stored in _________ database.

• Master
• Model
• User specific
• Temp

Triggers are supported in

• Delete
• Update
• Views
• All of these

Which of the following is an PostgreSQL-supported trigger?

• BEFORE
• INSTEAD OF
• AFTER
• All of these

The _____ clause specifies the table name on which the trigger is to be attached.

• For
• On
• None
• In

In order to remove a PL/pgSQL function, which statement is used?

• REMOVE FUNCTION
• DELETE FUNCTION
• ERASE FUNCTION
• DROP FUNCTION

In PL/pgSQL, which of the following describes the proper structure of an IF statement when dealing with multiple conditions?

• Using IF...ELSE statements for each condition separately.
• Using a single IF statement with multiple THEN clauses.
• Using nested IF statements within each other.
• Using ELSIF and ELSE clauses to handle multiple conditions in a single IF statement.

Which of the followings are types of triggers?

• Define, Create
• Drop, Comment
• Insert, Update, Delete
• All of these

Triggers ________ enabled or disabled

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

The format for statements in PL/pgSQL block is

• Begin ……. end
• Begin atomic……. end
• Begin ……. repeat
• Both Begin ……. end and Begin atomic……. end