1Z0-144 Exam Questions

Examine the following DECLARE section of PL/SQL block: Which line in the above declaration would generate an error?

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...

Examine the following block of code: Which line in the above code would result in errors upon execution?

Which two statements are true about the handling of internally defined or user-defined PL/SQL exceptions? (Choose two.)

You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded. The procedure should return an "e...

View the Exhibit to examine the PIVSQL block. Which statement is true about the output of the PL/SQL block?

Examine the following code: What is the outcome?

View Exhibit1 and examine the structure of the EMP table. View Exhibit2 and examine the PIVSQL block of code. What is the outcome?

In which of the following scenarios would you recommend using associative arrays?

View the Exhibit and examine the structure of the employees table. Execute the following block of code: What is the outcome?

Which three statements are true about anonymous blocks and subprograms? (Choose three.)

Consider the following scenario: Local procedure a calls remote procedure B Procedure A was compiled at 8 AM. Procedure A was modified and recompiled at 9 AM. Remote procedure B wa...

View the exhibit and examine the structure of the EMPLOYEES table The salary of EMPLOYEE_ID 195 is 2800. You execute the following code What is the outcome?

Examine the following code: The above code generates an error on execution. What must you do to ensure that the code executes successfully?

View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables. EMPLOYEES DEPAERTMENT EMP_BY_DEPT Examine the following code: What is the outcome...

View Exhibit1 and examine the structure of the employees table. View Exhibit2 and examine the code. What is the outcome when the code is executed?

Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.

Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)

View Exhibit 1 and examine the structure of the EMP and dept tables. View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete r...

View the Exhibit and examine the code and its outcome on execution: What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green. Examine the following sequence of commands issued by SCOT...

View the Exhibit to examine the PL/SQL block. Which statement is true about the execution of the PL/SQL block?

In which of the following scenarios would you recommend using PL/SQL records?

Which statements are true about PL/SQL procedures? (Choose all that apply.)

Which two statements correctly differentiate functions and procedures? (Choose two.)

View the Exhibit and examine the structure of the customer table. You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table c...

View Exhibit1 and examine the structure of the product table. View Exhiblt2 and examine the procedure you created. The procedure uses the prod id to determine whether the list pric...

Examine the following partial code: Which statement is correct about the unnamed block of code at the end of a package body?

Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

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 empl...

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?

View Exhibit1 and examine the structure of the EMP table. View Exhibit2 and examine the code created by the user SCOTT: SCOTT grants the necessary privileges to green to access the...

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

View the Exhibit and examine the structure of the customer table. You need to create a trigger to ensure that customers in category "A" and "B" have a credit limit of more than 800...

View the Exhibit and examine the code: Which statement is true about the COMPILE_CODE procedure?

Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)

Examine the following partial declare section from a block of PL/SQL code Which line(s) in the above code are NOT valid? (Choose all that apply.)

Which two statements are true about the continue statement? (Choose two.)

View the Exhibit and examine the structure of the AUDIR_CUST table. Exhibit Missing CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table. Examine the following trigger...

View the Exhibit and examine the structure of the employees table. Examine the following block of code: What is the outcome when the above code is executed?

Which two tasks should be created as functions instead of as procedures? (Choose two.)

ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code: Which statement is correct about the above code?

Which two statements are correct about the usage of parameters in functions? (Choose two.)

Which statements are true about the WHEN OTHERS exception handler? (Choose all that apply)

View Exhibit1 and examine the structure of the employees table. User SCOTT needs to generate a text report that contains the names of all employees and their salaries. Examine the...

Identify two features of obfuscation. (Choose two.)

View the Exhibit and examine the structure of the customer table. Examine the following trigger code: What is the outcome when the above trigger is compiled?

You create the following table and execute the following code: Which statement is true about the outcome of the above code?

Examine the following code that you plan to execute: What correction should be performed in the above code?

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 TRIG...