New 1Z0-144 Test Materials & Valid 1Z0-144 Test Engine [Q34-Q55]

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

NO.35 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?

NO.36 View the Exhibit and examine the structure of the departments table in SCOTT’s schema.

Examine the following block of code:

The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.
Which two statements are true in the above scenario? (Choose two.)

NO.37 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?

NO.38 Which two statements are true about PL/SQL exception propagation? (Choose two.)

NO.39 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 price is within a given range.

You then create the following trigger on the product table.
CREATE OR REPLACE TRIGGER check_price__trg BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price ON product FOR EACH ROW WHEN (nev.prod_id <> NVX(old.prod_id,0) OR New.prod__list_price <> NVL(old.prod_list_price, 0) ) BEGIN check_price (: new.prod_id) ; END /
Examine the following update command for an existing row in the product table.
SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;
Why does it generate an error?

NO.40 Identify two features of obfuscation. (Choose two.)

NO.41 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?

NO.42 View the Exhibit and examine the code:

Which statement is true about the COMPILE_CODE procedure?

NO.43 View Exhibit 1 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 following commands issued by the DBA:
SQL_CREATE DICTORY my_dir AS ‘/temp/my_files* ;
SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit 2 and examine the procedure code. You issue the following command:

You issue the following command:
SQL_EXEC sal_5tatus (‘MY_DIR’, ‘EMPREPORT.TXT’)
What is the outcome?

NO.44 Which two statements are true about statement-level and row-level triggers? (Choose two.)

NO.45 Which two statements aretrue about the instead of triggers?(Choosetwo.)

NO.46 Examine the following package specification.
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS PROCEDURE search_emp (empdet NUMBER); PROCEDURE search_emp (empdet DATE); PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2 PROCEDURE search_emp (empdet NUMBER); RETURN DATE END emp_pkg / The package is compiled successfully
Why would it generate an error at run tune?

NO.47 Examine the following code:

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

NO.48 View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What would be the outcome when the code is executed?

NO.49 Examine the following code:

What is the outcome?

NO.50 Examine the following block of code:

Which line in the above code would result in errors upon execution?

NO.51 Examine the following code: The above code generates an error on execution.

What must you do to ensure that the code executes successfully?

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

NO.53 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 following commands issued by the DBA: SQL_CREATE DICTORY my_dir AS ‘/temp/my_files* ; SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code. You issue the following command: You issue the following command:

SQL_EXEC sal_5tatus (‘MY_DIR’, ‘EMPREPORT.TXT’)
What is the outcome?

NO.54 View the Exhibit and examine the structure of the SALGRADE table.

Examine the following code:

What is the outcome?

NO.55 Which two statements are true about the usage of the cursor for loops? (Choose two.)