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

Total Question: 103 Last Updated: January 15,2018
  • Updated 1Z0-144 Dumps
  • Based on Real 1Z0-144 Exams Scenarios
  • Free 1Z0-144 pdf Demo Available
  • Check out our 1Z0-144 Dumps in a new PDF format
  • Instant 1Z0-144 download
  • Guarantee 1Z0-144 success in first attempt
Package Select:

Questions & Answers PDF

Practice Test Software

Practice Test + PDF 30% Discount

Price: $65.95 $29.99

Buy Now Free Trial

All About 1Z0-144 free draindumps Jan 2018

Ucertify offers free demo for 1Z0-144 exam. "Oracle Database 11g: Program with PL/SQL", also known as 1Z0-144 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1Z0-144 exam, will help you answer those questions. The 1Z0-144 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1Z0-144 exams and revised by experts!

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


Q22. Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.) 

A. When a query returns multiple rows 

B. When a column name in a where clause is unknown at compile time. 

C. When the number of columns selected in a query is not known until run time 

D. When a table needs to be created based on an existing table structure at run time 

E. When privileges need to be granted to a new user to access an existing schema at run time 

Answer: B,C 


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

A. It executes successfully. 

B. It gives an error because the SAL variable is not visible in the increase function. 

C. It gives an error because the increase function cannot be called from the RAISE_SALARY procedure. 

D. It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations. 

Answer:


Q24. Examine the following code that you plan to execute: 

What correction should be performed in the above code? 

A. The PROC2 procedure code should be defined in the package body. 

B. The PROC3 procedure should be declared in the package specification. 

C. The PROC3 procedure header should be declared at the beginning of the package body. 

D. The variable x must be declared in the package body and removed from the specification, 

Answer: A,B 


Q25. View the Exhibit and examine the code. 

Why does the code give an error on execution? 

A. because the WORD_LIST variable is not visible in procedure wording 

B. because the lexicon variable is not visible in procedure ADD_ENTRY 

C. because the lexicon variable is not initialized in procedure wording 

D. because the WORD_LIST parameter in out mode cannot be of a record data type 

Answer:


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

A. AFTER LOGON 

B. AFTER STARTUP 

C. BEFORE SHUTDOWN 

D. AFTER SERVERERROR 

Answer: A,D 

Explanation: 

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064 


Q27. The STRING_TAB table has the following structure: 

View the Exhibit and examine the code. 

What is the outcome on execution? 

A. It displays 

Output buffer not long enough. 

This is my test string.-. 

B. It displays only 

Output buffer not long enough, and exits the anonymous block. 

C. It displays only 

This is my test string. - Because EXCEPTION should have been defined in the anonymous 

block to get the error message. 

D. It does not display any of the MEMS_PUTPUT messages and gives an error because a 

transaction control statement cannot be used in the exception section of a procedure. 

Answer:


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

Answer:


Q29. Examine the following block of code: 

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

A. line 5 

B. line 8 

C. line 2 

D. line 7 

Answer:


Q30. View Exhibit 1 and examine the structure of the EMP and dept tables. 

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table. 

What is the outcome on compilation? 

A. It compiles and executes successfully. 

B. It gives an error on compilation because it is not a row-level trigger. 

C. It gives an error on compilation because the exception section Is used in the trigger. 

D. It compiles successfully but gives an error on execution because it is not a row-level trigger. 

Answer:


Related 1Z0-144 Articles