SA2 DBA

Question 1

In anonymous block, DECLARE states “this is the start of a block”. In Procedure, ____________ states “this is the start of a subprogram”.

Answer 1

CREATE PROCEDURE

Question 2

Which keyword is omitted in the declaration section of the procedure? _____

Answer 2

DECLARE

Question 3

“In the given Procedure header, the underlined clause/keyword is mandatory.

CREATE OR REPLACE PROCEDURE name [parameters] IS|AS

Group of answer choices

True

False”

Answer 3

”
True”

Question 4

“In the given Procedure header, the underlined clause/keyword is optional.

CREATE OR REPLACE PROCEDURE name [parameters] IS|AS

Group of answer choices

True

False”

Answer 4

”
True”

Question 5

Subprograms are named PL/SQL blocks that are compiled and stored in the _______.

Answer 5

DATABASE

Question 6

“The IN parameters can only be read within the procedure and cannot be modified.
Group of answer choices

True

False”

Answer 6

”
True”