1z0-101 Oracle - Braindumps.com.ua: question list for "Develop PL/SQL Program Units", page: 1

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-101: Develop PL/SQL Program Units

#1. The number of cascading triggers is limited by which data base initialization parameter?

#2. Which type of package construct must be declared both within the package specification and package body?

#3. Why do stored procedures and functions improve performance? (Chose two)

#4. When creating store procedures and functions which construct allows you to transfer values to and from the calling environment?

#5. You need to remove database trigger BUSINESS_RULE.
Which command do you use to remove the trigger in the SQL*Plus environment?

#6. Which two tables are fused track object dependencies? (Choose two)

#7. The QUERY_PRODUCT procedure directly references the product table. There is a NEW_PRODUCT_VIEW view created based on the NOT NULL columns of the table. The ADD_PRODUCT procedure updates the table indirectly by the way of NEW_PRODUCT_VIEW view. Under which circumstances does the procedure ADD_PRODUCT get invalidated but automatically get complied when invoked?

#8. You need to recompile several program units you have recently modified through a PL/SQL program. Which statement is true?

#9. Which type of argument passes a value from a calling environment?

#10. You need to create a trigger on the EMP table that monitors every row that is changed and places this information into the AUDIT_TABLE. Which type of trigger do you create?

[1] [2] [3] [4] [5] [6] [7] [8] [9]

gen. 0.137

Server date 01:59 10-01-2009

Oracle 1z0-101

Forum

Start online exam simulation

Master braindump

User braindumps