Changed 1z0-144 Exam Questions

The PL/SQL wrapper detects and reports only syntax errors.

The PL/SQL wrapper detects and reports both syntax and semantic errors.

When wrapping a package or object type, both the body and specification should be wrapped.

When wrapping a package or object type, only the body should be wrapped, not the specification.

To change a wrapped object, the original source code needs to be modified and then wrapped again

To change a wrapped object, the wrapped code can be unwrapped, modified In a text file, and then wrapped again.

Line 2

Line 3

Line 4

Line 5

Line 6

It is a private variable defined in a procedure or function within a package body whose value is consistent within a user session.

It is a public variable in a package specification whose value is consistent within a user session.

It is a private variable in a package body whose value is consistent across all current active sessions.

It is a public variable in a package specification whose value is always consistent across all current active sessions.

It executes successfully and creates the report.

It gives an error because the text file should be opened in append mode.

It gives an error because the "no data found" condition is not handled to come out of the loop.

It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.

It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.