January 22, 2021 by admin Latest Updated Oracle 1Z0-144 practice test Welcome to your Latest Updated Oracle 1Z0-144 practice test QUESTION 1Which two statements are true about the INSTEAD OF triggers? (Choose two.) A. DELETE operations cannot be performed using the INSTEAD OF triggers. B. The INSTEAD OF triggers must be created to add or modify data through any view. C. The INSTEAD OF triggers can be written only for views, and the BEFORE and AFTER timing options are not valid. D. The CHECK option for views is not enforced when insertions or updates to the view are performed by using the INSTEAD OF triggers. QUESTION 2Which tasks must be performed during the installation of the UTL_MAIL package? (Choose two.) A. setting the UTL_FILE_DIR initialization parameter B. running the utlmail.sql and prvtmail.plb scripts C. setting the SMTP_OUT_SERVER initialization parameter D. using the CREATE DIRECTORY statement to associate an alias with an operating system directory E. granting read and WRITE privileges to control the type of access to files in the operating system QUESTION 3Examine the following snippet of code from the DECLARE section of PL/SQLDECLARECust_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 only the data type from the CUST_NAME variable.B. The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.C. The SAME_NAME variable inherits the data type, constraint, 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 QUESTION 4Examine the following command:SQL>ALTER SESSION SET plsql_warnings * \\'enable: severe\\', \\'enable: performance\\', \\'ERROR: 05003\\';What is the implication of the above command?A. It issues a warning whenever ERROR: 05003 occur during compilation.B. It causes the compilation to fail whenever the warning ERROR.05003 occurs.C. It issues warnings whenever the code causes an unexpected action or wrong results performance problems.D. It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed. QUESTION 5Which system events can be used to create triggers that fire both at DATABASE and SCHEMA levels? (Choose two.) A. AFTER LOGON B. AFTER STARTUP C. BEFORE SHUTDOWN D. AFTER SERVERERROR QUESTION 6View Exhibit 1 and examine the structure of the EMP table.View Exhibit 2 and examine the PL/SQL block of code. What is the outcome?A. It gives an error because the return type is not valid.B. It gives an error because the record type is not defined within the function.C. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not validD. It executes successfully and displays the names and salaries of all employees who earn the highest salary.E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary. QUESTION 7Examine the following PL/SQL code;The execution of the code produces errors. Identify the error in the code.A. The OPEN cursor is missing.B. The FETCH clause is missing.C. The EXIT WHEN condition is missing.D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement. QUESTION 8View 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 but no error messages get recorded in the DEBUG_OUTPUT tableB. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.C. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.D. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section. QUESTION 9View 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 theemployee name or employee number. Which two rules should you apply to ensure that the overloading feature is usedsuccessfully? (Choose two.) A. The procedures can be either stand-alone or packaged B. The procedures should be created only as packaged subprograms. C. The procedures should be created only as stand-alone subprograms D. Each subprogram\\'s formal parameters should differ in both name and data type. E. The formal parameters of each subprogram should differ in data type but can use the same names QUESTION 10View 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?A. It gives an error because only the innermost block is labeled.B. It gives an error because the same variable name cannot be used across all the nested blocks.C. It executes successfully and displays the resultant values in the following sequence- 1000, 2800 50000, 2800.D. It executes successfully and displays the resultant values in the following sequence: 1000, 2800, 50000, 1000. QUESTION 11What is the correct definition of the persistent state of a packaged variable?A. It is a private variable defined in a procedure or function within a package body whose value is consistent within a user session.B. It is a public variable in a package specification whose value is consistent within a user session.C. It is a private variable in a package body whose value is consistent across all current active sessions.D. It is a public variable in a package specification whose value is always consistent across all current active sessions. QUESTION 12Identify two situations where the DBMS_SQL package should be used. (Choose two.) A. The SELECT list is not known until run time. B. The dynamic SQL statement retrieves rows into records. C. You do not know how many columns a SELECT statement will return, or what their data types will be. D. You must use the % FOUND SQL cursor attribute after issuing a dynamic SQL statement that is an INSERT or UPDATE statement. QUESTION 13You execute the following block of code: Which statement is true about the outcome?A. Both output statements show different values.B. Both output statements show exactly the same values.C. It gives an error because the nested blocks are not labeled.D. It gives an error because the V_CUSTOMER variable cannot have different types in the nested blocks. Time is Up!