COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Table
|
|
|
Type
|
|
|
Trigger
|
|
|
Package
|
Detailed explanation-1: -A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is developed, compiled, and ultimately executed on the database.
Detailed explanation-2: -A cursor name is not a PL/SQL variable.
Detailed explanation-3: -Q 1-Which of the following is not true about the PL/SQL language? A-It supports embedded SQL statements.
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.