Download Oracle Database 11g-Program with PL-SQL.1Z0-144.v12-39.2016-06-13.1e.84q.vcex


Download Exam

File Info

Exam Oracle Database 11g: Program with PL/SQL
Number 1z0-144
File Name Oracle Database 11g-Program with PL-SQL.1Z0-144.v12-39.2016-06-13.1e.84q.vcex
Size 14.68 Mb
Posted June 13, 2016
Downloads 85



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



Demo Questions

Question 1
View the Exhibit and examine the structure of the EMP table. Which stages are performed when the above block is executed? (Choose all that apply)
  

  • A: Bind
  • B: Parse
  • C: Fetch
  • D: Execute



Question 2
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



Question 3
In which of the following scenarios would you recommend using PL/SQL records?

  • 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 in memory each time a subprogram is invoked



Question 4
View the Exhibit and examine the structure of the employees table.
  
Execute the following block of code:
  
What is the outcome?

  • A: It gives an error because group functions cannot be used in anonymous blocks
  • B: It executes successfully and correctly gives the result of the sum of salaries in department 60.
  • C: It executes successfully and incorrectly gives the result of the sum of salaries in department 60.
  • D: It gives an error because the variable name and column name are the same in the where clause of the select statement.



Question 5
Examine the following snippet of PL/SQL code:
  
View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has 200 rows.
  
Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as `ST_CLERK' and salary greater than 3000.

  • A: OPEN c1 (NULL, 3000);
  • B: OPEN c1 (emp_job, 3000);
  • C: OPEN c1 (3000, emp_salary);
  • D: OPEN c1 (`ST_CLERK', 3000)
  • E: OPEN c1 (EMP_job, emp_salary);








ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset