1Z0-144 試験問題を無料オンラインアクセス

View the Exhibit to examine the PL/SQL code:

SREVROUPUT is on for the session. Which statement Is true about the output of the PL/SQL block?

• A.The output Is x != y.
• B.The output Is Can't tell if x and y are equal or not.
• C.It produces an error.
• D.The output is x = y.

Examine the following snippet of code from the DECLARE section of PL/SQL
DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = 'Tom Jones':
Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?

• A.The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.
• B.The SAME_NAME variable inherits only the data type from the CUST_NAME variable.
• C.The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.
• D.The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, 'Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?

• A.SCOTT, HR, and SYS
• B.Only SCOTT
• C.SCOTT and HR
• D.Only HR

View the Exhibit and examine the structure of the EMP table.

You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)

• A.The procedures can be either stand-alone or packaged.
• B.The procedures should be created only as stand-alone subprograms
• C.Each subprogram's formal parameters should differ in both name and data type.
• D.The formal parameters of each subprogram should differ in data type but can use the same names.
• E.The procedures should be created only as packaged subprograms

View the exhibit and examine the structure of the products table.

Examine the following code

Which statement is true when the procedure DELETE_DETAILS is invoked?

• A.It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
• B.It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
• C.It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
• D.It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.