Cause all that matters here is passing the Oracle 1Z0-144 exam. Cause all that you need is a high score of 1Z0-144 Oracle Database 11g: Program with PL/SQL exam. The only one thing you need to do is downloading Examcollection 1Z0-144 exam study guides now. We will not let you down with our money-back guarantee.

2016 Oct 1z0-144 exam guide:

Q41. 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 complete the above code? (Choose two.) 

A. ON SCHEMA 

B. ON QRXABASE 

C. AFTER LOGOFF 

D. BEFORE LOGOFF 

Answer: A,D 


Q42. Examine the following code: 

What is the outcome? 

A. The procedure is created successfully and displays the values 20 and 30 when it is called. 

B. The procedure gives errors because the parameters should be in out mode. 

C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure. 

D. The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure. 

Answer:


Q43. Examine the following DECLARE section of PL/SQL block: 

Which line in the above declaration would generate an error? 

A. Line 2 

B. Line 3 

C. Line 4 

D. Line 5 

E. Line 6 

Answer:


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

A. The exception reproduces Itself In successive enclosing blocks until a handler is found. 

B. Exception- can propagate across the remote subprograms that are called through database links. 

C. If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception. 

D. If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception. 

Answer: A,C 


Q45. 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 procedure in the anonymous block execute successfully? (Choose two.) 

A. call in line 6 

B. call in line 7 

C. call in line 8 

D. call in line 9 

Answer: C,D 


Abreast of the times 1z0-144 exam details:

Q46. Identify two features of obfuscation. (Choose two.) 

A. The Import and Export utilities accept wrapped files. 

B. SQL' Plus cannot process the obfuscated source files. 

C. Only the wrap utility can obfuscate multiple programs at a time. 

D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time. 

E. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View 

Answer: A,C 


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

A. All the triggers that are created on a table cannot be disabled simultaneously. 

B. Any user who has the alter privilege on a table can create a trigger using that table. 

C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database. 

D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation. 

Answer: C,D 


Q48. View the Exhibit to examine the PIVSQL block. 

Which statement is true about the output of the PL/SQL block? 

A. It executes and the Output is emprec.deptname: . 

B. It executes and the Output is emprec.deptname: Sales. 

C. It produces an error because NULL is assigned to the emprec.empid field in the record. 

D. It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record. 

Answer:


Q49. Which 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 or 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 trigger. 

Answer: B,C 


Q50. Which two statements are true about anonymous blocks and named subprograms? 

(Choose two) 

A. Subprograms are by default executed with definer's rights. 

B. The declare section is optional for both anonymous blocks and subprograms. 

C. Both anonymous blocks and subprograms execute by default with invoker's rights. 

D. The declare section is mandatory for anonymous blocks and optional for subprograms. 

Answer: A,B