1Z1-144 무료 덤프문제 온라인 액세스

What is the correct definition of the persistent state of a packaged variable?

• A.It is a private variable defined in a procedure or function within a package body whose
  value is consistent within a user session.
• B.It is a public variable in a package specification whose value is always consistent across all current active sessions.
• C.It is a public variable in a package specification whose value is consistent within a user session.
• D.It is a private variable in a package body whose value is consistent across all current active sessions.

Examine the following command:
SQL>ALTER SESSION
SET plsql_warnings *
'enable: severe',
'enable: performance',
'ERROR: 05003';
What is the implication of the above command?

• A.It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.
• B.It causes the compilation to fail whenever the warning ERROR.05003 occurs.
• C.It issues a warning whenever ERROR: 05003 occur during compilation.
• D.It issues warnings whenever the code causes an unexpected action or wrong results performance problems.

View the exhibit and examine the structure of the EMPLOYEE table.
EMPLOYEE_SEQ is an existing sequence.
Examine the following block of code:

Which statement is true about the above block of code?

• A.It consists of a single transaction,
• B.The data is automatically committed after the block execution ends,
• C.It consists of two transactions
• D.It gives an error on execution because sequences cannot be used in anonymous blocks.

Which statement is true about triggers on data definition language (DDL) statements?

• A.They can be used to track changes only to a table or index.
• B.They are fired only when the owner of the object Issues the DDL statement.
• C.They can be defined by all users in the database or only by a specific user.
• D.They can be used to track changes to a table, table space, view, or synonym.

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

• A.A procedure can contain a return statement without a value.
• B.A function can return multiple values using a single return clause,
• C.A function can contain zero or more parameters that are transferred from the calling environment.
• D.A procedure can be executed as part of a SQL expression or as a PL/SQL statement,