1Z0-144 Exam Questions

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

You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table. Which two statements are corr...

Examine the following PL/SQL code: Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

Which three statements are true about wrapping? (Choose three.)

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?

You execute the following block of code: Which statement is true about the outcome?

Examine the following PL/SQL code: Which statement is true about the execution of the PL/SQL code?

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

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

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

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

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

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

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?

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?

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

View the Exhibit to examine the PL/SQL code. The record for the employee with employee__id 100 in the employees table is as follows; Identify the correct output for the code.

Which two statements are true about the exit statement encountered in loop? (Choose two)

Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)

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

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

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

Examine the following PL/SQL code: The server output is on for the session. Which statement is true about the execution of the code?

Which type of exceptions is qualified as no predefined Oracle server errors?

View the Exhibit and examine the code. Why does the code give an error on execution?

Examine the following PL/SQL code: The server output is on for the session. Which statement is true about the execution of the code?

Which two statements are true about database triggers? (Choose two.)

Which statement is true about transactions in PL/SQL?

Which two statements are true about anonymous blocks and named subprograms? (Choose two)

Examine the following PL/SQL code; The execution of the code produces errors. Identify the error in the code.

/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder Examine the following commands that are executed by the DBA: SQL>CREATE...

View the exhibit to examine the PL/SQL code. Which statement is true about the exception handlers in the PL/SQL code?

View Exhibit1 and examine the structure of the EMP table. View Exhibit2 and examine the code. EKPNOS 7845 and 7900 exist in the EMP table. Which two calls to the RAISE_SALABY proce...

Examine the following PL/SQL code: Which statement is true about the fetch statements in the PL/SQL code?

Which two statements are true about triggers? (Choose two.)

View the Exhibit and examine the blocks of code that you plan to execute. Which statement is true about the blocks of code?

You want to maintain an audit of the date and time when each user of the database logs off. Examine the following code: Which two clauses should be used to fill in the blanks and c...

View the Exhibit and examine the structure of the departments table in SCOTT's schema. Examine the following block of code: CREATE OR REPLACE PROCEDURE add_dept( p_id NUMBER, p_nam...

You want to store values of different data types in a PL/SQL block and store one record at a time for processing the information. Which type of composite data type would you choose...

Examine the following code: Which statement is true about the execution of the above code?

Examine the following package specification: Which statement is true?

Examine the following block of code: Which two statements are correct about the code above? (Choose two.)

Which two statements are correct about PL/SQL package components? (Choose two)

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

The STRING_TAB table has the following structure: View the Exhibit and examine the code. What is the outcome on execution?

View Exhibit 1 and examine the structure of the EMP table. View Exhlbit2 and examine the code of the packages that you have created. You issue the following command: SQL> DROP PACK...

Examine the following code: Which two statements are true about the above function? (Choose two.)

Examine the following snippet of PL/SQL code: View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows. Identify open statement for opening the c...

View the Exhibit to examine the PL/SQL code. SERVEROUTPUT is on for the session. Which statement is true about the execution of the code?

Which two statements are true about the %ROWTYPE attribute? (Choose two.)