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

View Exhibit1 and examine the structure of the DO table. View Exhibit2 and examine the code.


The anonymous block gives an error on execution. What is the reason?

• A.The assignment in line 7 is not valid.
• B.A null value cannot be applied to the bind arguments In the using clause in line 10
• C.The SQL does not support the Boolean data type.
• D.The names of bind variables must be the same as the using clause bind arguments in line 10

Which statements are true about database triggers? (Choose all that apply.)

• A.They can invoke only PL/SQL procedures
• B.They can include SQL and PL/SQL or calls to Java procedures.
• C.They are implicitly fired by an event that must occur within an application
• D.They are implicitly fired when a triggering event occurs, depending on which user is connected

Which tasks must be performed during the installation of the UTL_MAIL package? (Choose all that apply.)

• A.using the CREATE DIRECTORY statement to associate an alias with an operating system directory
• B.setting the SMTP_OUT_SERVER initialization parameter
• C.setting the UTL_FILE_DIR initialization parameter
• D.running the UTLMAIL.SQL and prvtmail.plb scripts
• E.granting read and WRITE privileges to control the type of access to files in the operating system

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

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

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