COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
It should have more than one executable line of code.
|
|
|
It may have just a NULL command toindicate that nothing should be executed.
|
|
|
The statements must always end with asemicolon.
|
|
|
The section may contain SQL commands, logical control commands, assignment commands, as well as other commands.
|
Detailed explanation-1: -Answer : D. Q 6-Which of the following is not true about the execution section of a PL/SQL block? A-It should have more than one executable line of code.
Detailed explanation-2: -Which of the following is true about the execution section of a PL/SQL block? It is a mandatory section. It consists of the executable PL/SQL statements.
Detailed explanation-3: -Which of the following is not true about the PL/SQL data structure VARRAY? Answer : The elements can of various data types.
Detailed explanation-4: -A PL/SQL block consists of three sections: declaration, executable, and exception-handling sections. In a block, the executable section is mandatory while the declaration and exception-handling sections are optional.