we provide 100% Correct Oracle 1Z0-144 practice question which are the best for clearing 1Z0-144 test, and to get certified by Oracle Oracle Database 11g: Program with PL/SQL. The 1Z0-144 Questions & Answers covers all the knowledge points of the real 1Z0-144 exam. Crack your Oracle 1Z0-144 Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-144 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-144 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-144-exam-dumps.html
Q11. View the Exhibit and examine the blocks of code that you plan to execute.
Which statement is true about the blocks of code?
A. All the blocks execute successfully and the anonymous block displays 1 2 3 cant: 45 45 cnt: 45
B. All the blocks execute successfully and the anonymous block displays 1 2 3 cut: 0 45 cart: 1
C. The anonymous block gives an error because the function invocation in line 2 is not valid.
D. The procedure creation gives an error because the function invocation in line 1 is not valid.
Answer: A
Q12. Which two statements are correct about the usage of parameters in functions? (Choose two.)
A. Functions can have only in mode parameters.
B. Functions called in SQL statements cannot have out or in out mode parameters.
C. Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
D. Functions having in, out, or in out parameters can be called In PL/SQL procedures and anonymous blocks.
Answer: B,D
Q13. View the Exhibit and examine the structure of the SALGRADE table.
Examine the following code:
What is the outcome?
A. It is created successfully.
B. It gives an error because the return clause condition is invalid.
C. It gives an error because the usage of the host variables is invalid.
D. It gives an error because the data type of the return clause is invalid.
Answer: B
Q14. 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: C
Q15. 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: A
Q16. View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:
Which statement is true about the above trigger?
A. It gives an error on compilation because it should be a statement-level trigger.
B. It compiles and fires successfully when the credit limit is updated in the customer table.
C. It gives an error on compilation because of the commit command in the trigger code
D. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.
Answer: D
Q17. Which statements are true about PL/SQL procedures? (Choose all that apply.)
A. Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
B. Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
C. Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
D. A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.
Answer: B,D
Q18. View the Exhibit and examine the structure of the customer table.
Examine the following trigger code:
What is the outcome when the above trigger is compiled?
A. It compiles successfully.
B. It gives an error because the when condition is not valid.
C. It gives an error because when cannot be used for row-level triggers.
D. It gives an error because the statements under updating are not valid.
E. It gives an error because the new qualifier in the when clause requires a colon prefix.
Answer: A
Q19. 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 PACKAGE manage_emp;
What is the outcome?
A. It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.
B. It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.
C. It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.
D. It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.
Answer: B
Q20. In which of the following scenarios would you recommend using associative arrays?
A. When you want to retrieve an entire row from a table and perform calculations
B. When you know the number of elements in advance and the elements are usually accessed sequentially
C. When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
D. When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked.
Answer: C,D
