PL PGSQL -01

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

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.

The format for statements in PL/pgSQL block is

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

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

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

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

• = =
• =
• :=
• _=

What is the symbol for the operator used to compare equality between two variables in PL/pgSQL?

• = =
• =
• :=
• _=

PL/pgSQL function must contain a –

• Follow Statement
• GOTO statement
• Returns Statement
• Return Statement

The __________ loop tests the condition before executing the statements, the __________ loop is sometimes referred to as a pretest loop.

• for, for
• while, while
• Both A and B
• None of these