Oracle Database 11g: Program with PL/SQL - 1Z1-144 Exam Practice Test

A. When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.

B. A package must have both specification and body.

C. A package body can exist without the package specification.

D. A package specification can exist without the package body.

A. It gives an error because the when condition is not valid.

B. It gives an error because the statements under updating are not valid.

C. It gives an error because the new qualifier in the when clause requires a colon prefix.

D. It compiles successfully.

E. It gives an error because when cannot be used for row-level triggers.

A. when you want the database not to wait if the requested rows are locked by another user

B. when you want to ensure that the current rows fetched by the cursor are updated or deleted

C. when you want to lock the rows fetched by the cursor

D. when you want to update or delete the result set without affecting the rows in the table

A. Both DML and DDL statements can cascade any number of triggers,

B. Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers

C. Each trigger can be of any size.

D. A trigger can contain a maximum of 32 lines of code.

E. Each trigger can be of a maximum size of 32 K

F. Triggers fired by DML statements cannot cascade simultaneously.

A. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.

B. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.

C. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.

D. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement.

A. The fetch clause is missing

B. The open cursor is missing

C. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.

D. The exit when condition is missing

A. It produces an error because NULL is assigned to the emprec.empid field in the record.

B. It executes and the Output is emprec.deptname: Sales.

C. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

D. It executes and the Output is emprec.deptname: .

A. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.

B. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.

C. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.

D. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.