1Z0-144 - Oracle Database 11g: Program with PL/SQL Practice Test

Go back to Oracle

Exam FAQ

How many questions are there on the 1Z0-144 exam? How long is the 1Z0-144 exam? How much does the 1Z0-144 exam cost? What is the best way to study for the 1Z0-144 exam?

Example Questions

Martha designs a database for Oliver Inc. She wants to retrieve the error number for the current exception. Which of the following functions will she use? Which of the following packages is replaced by the UTL_MAIL package in Oracle 11g to allow email to be sent from PL/SQL? Which of the following identifiers are declared globally? Which of the following provides compile time code optimization? In which of the following ways can a PL/SQL function NOT be executed? Which of the following PL/SQL built-in functions is used to return an ASCII encoding string for a Character? All of the following statements are true about an explicit cursor except for which one? You have written the following PL/SQL code: SET SERVEROUTPUT ON SIZE 1000000 BEGIN END; / But this code fails run-time compilation. What should you do to remove this error? Which of the following functions is used to update or insert a reference to an externally stored binary large object? Which of the following statements can be used to create a package? Each correct answer represents a part of the solution. Choose two. Which of the following PL/SQL packages is used to support the SQL plan management feature? You work as an Application Developer for Dolliver Inc. The company uses an Oracle database. The database contains a table named Audit_Records. Following is the structure of the table: Sequence NUMBER User_Name VARCHAR2 (25) Login_Time DATE Job VARCHAR2 (25) Emp_ID NUMBER You create a procedure as follows: CREATE OR REPLACE PROCEDURE Login_Pro (Name VARCHAR2) AS BEGIN INSERT INTO Audit_Records (User_Name) VALUES (Name); END Login_Pro; You also create a database trigger as follows: CREATE OR REPLACE TRIGGER Logon_Trig AFTER LOGON ON DATABASE CALL Login_Pro (ORA_LOGIN_USER); Which of the following statements regarding the functionality of the Logon_Trig trigger is true? You work as an Application Developer for Blue-Well Inc. The company uses an Oracle database. The database contains a table named Employees that contains employee records. You are required to create subprograms (procedures and functions) that perform different operations on the Employees table. You want to group the subprograms in a package named Manage_Employees. In order to accomplish the task, you first create the package specification by executing the following statement: CREATE OR REPLACE PACKAGE Manage_Employees IS tax_rate CONSTANT NUMBER(5, 2) := .28; v_id NUMBER; PROCEDURE Insert_Emp (p_deptno NUMBER, p_sal NUMBER); PROCEDURE Delete_Emp; PROCEDURE Update_Emp; FUNCTION Calc_Tax (p_sal NUMBER) RETURN NUMBER; END Manage_Employees; After creating the package specification, you execute the following statement in order to create the package body: Which of the following subprograms in the Manage_Employees package is a private subprogram? You work as an Application Developer for Tech-Mart Inc. The company uses an Oracle database. You want to create automated, unattended scheduling of PL/SQL program units. Which of the following Oracle supplied packages will you use to accomplish this? Which of the following is an Oracle Database facility that keeps a list of references? Which of the following subprograms of DBMS_LOCK package are NOT procedures? Each correct answer represents a complete solution. Choose all that apply. What are the two new functions added by the DBMS_SQL built-in package? Which of the following operators allows users to check whether a VARRAY or NESTED TABLE collection is a subset of a mirrored datatype? You work as a Database Administrator for Hitech Inc. The company uses Oracle as its database. The database contains a table named Employee, which in turn have a view named ename. There is some issue with the ename view. As a DBA, you need to repair and compile the view. You issue the ALTER view ename COMPILE statement, however, the compilation failed. Which of the following will you use to accomplish the task? Each correct answer represents a part of the solution. Choose two. Which of the following programming constructs can be grouped within a package? Each correct answer represents a complete solution. Choose all that apply. Which of the following is NOT a procedure in the UTL_MAIL package? Which of the following CANNOT be compared with the BFILE? Each correct answer represents a complete solution. Choose all that apply. Which of the following is used to reference a field in a record? Which of the following built-in packages supports dynamic SQL? You want to retrieve the complete database object definitions from the data dictionary. Which of the following packages will you use to get the required result? What is the maximum size of a trigger? Which of the following methods always equals LAST for varrays? Which of the following is NOT a component of static explicit cursor? You work as an Application Developer for Federal Inc. The company uses an Oracle database. The database contains a table named Employees. You are required to create a procedure named Sal_Raise that increases the salary of the specified employee. In order to accomplish this, you execute the following statement: CREATE OR REPLACE PROCEDURE Sal_Raise (Id NUMBER, Sal NUMBER) IS BEGIN UPDATE Employees SET Salary = Salary ­ Sal WHERE EmpID = Id; COMMIT; END; You want to invoke the procedure from SQL*Plus. What will you do to accomplish the task? Each correct answer represents a complete solution. Choose two. Which of the following functions returns the SQL function code for the statement? Martha works as an Application Developer for Z-Tech Inc. The company uses an Oracle database. The database contains a table named Orders. Martha wants to create a database trigger on the Orders table. She wants the trigger to fire after an UPDATE operation is performed on the Orders table. She also wants the trigger to fire for each row updated in the Orders table. Which of the following options will she use when creating the trigger? Each correct answer represents a part of the solution. Choose two. Which of the following symbols denotes PL/SQL conditional compilation-time variable? You work as an Application Developer for Dolliver Inc. The company uses an Oracle database. The database contains two tables named Orders and Audit_Records. You are required to create a trigger that monitors every modified row of the Orders table and stores the information about the modified rows in the Audit_Records table. What will you do to accomplish this? Which of the following stored programs of Oracle is used to compute a value and returns a value to a calling environment? Which of the following cannot be created and stored in the database? Which of the following statements is true about implicit cursors? In which of the following places is the record variable NOT allowed? Which of the following procedures of the UTL_FILE package is used to write a line to a file, and appends an OS-specific line terminator? Which of the following is another name for bind variable? Anonymous blocks are used when building scripts to seed data or perform one-time processing activities. In which of the following sections of the anonymous-block of PL/SQL can anonymousblock programs be nested? Which of the following triggers can be specified on a view? Which of the following is another name for an unnamed program unit in PL/SQL? Which of the following are the features of a cursor FOR loop? Each correct answer represents a complete solution. Choose all that apply. Which of the following utilities is used to obfuscate the contents of a PL/SQL source file? Which of the following data dictionary views describes all dependencies between objects (procedures, packages, functions, package bodies, and triggers), including dependencies on views created without any database links in the database? All of the following can be the causes of raising an exception except for which one? Which of the following is NOT a procedure? What are the two methods through which a value can be assigned to a variable? Each correct answer represents a complete solution. Choose all that apply. Which of the following PL/SQL functions is used to remove a set of characters from the beginning of a string? Which of the following two methods are provided by Oracle for using dynamic SQL within PL/SQL?

Study Guides