carefully,

$(4$ points for each question, five questions in this part I$)$

Which is the wrong $($or the least correct$)$ statement?

$($a$)$ The header of a function defined in a package specification provides all the information that an invoker needs.

$($b$)$ To access a function defined in a package, the invoker should incite the function name with its package name, such as package$\_$name.function$\_$name.

$($c$)$ If there is a function declared in the specification of a package, then the whole definition of this function $($header and body$)$ must be provided in the executable section of a package body.

$($d$)$ The variables declared in the package speciation are public to the invoking program.

$($e$)$ The variables declared in the package body are local to the package body program, invoking program cannot see these variables.

Which is the wrong $($or the least correct$)$ statement?

$($a$)$ Triggers are usually created in scheme level, thus they are stored in database system.

$($b$)$ In the definition of a trigger, we must use the key word "declare" before declaring any local variables

$($c$)$ In general cases $($unless we define the trigger using AUTONOMOUS$\_$TRANSACTION option$),$ when we roll back the triggering event, all the inserted records by the trigger will be rolled back too.

$($d$)$ Whenever a trigger is defined, no matter for statement level or row level, the system will create and populate two data structures, named as NEW and OLD.

$($e$)$ In the conditional predicate case, if we define a trigger such as INSERT OR DELETE OR UPDATE OF Salary on Employees for each row $,$ the trigger will not be fired when manager$\_$id is changed.

Which is the wrong $($or the least correct$)$ statement?

$($a$)$ If the Dynamic SQL statement includes placeholders, then each placeholder must have a corresponding bind variable in the appropriate clause of the Execute immediate statement.

$($b$)$ In the dynamic SQL statement, the name of placeholder must be represented with $"$:$"$ before it$,$ such as :placeholder$\_$name.

$($c$)$ In the dynamic SQL program, DDL statements are possible be executed with "execute immediate" statement.

$($d$)$ In the native dynamic SQL$,$ the INTO clause is not right after the select statement.

$($e$)$ In the native dynamic SQL$,$ the placeholders must be declared in the declarative section.