Oracle Interview Questions And Answers


Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert

Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel

Oracle Interview Questions And Answers


Page 78 of 95 b] Because the stored procedure occupies more space in the
database
than a integrity
constraint definition
c] Because a stored procedure creates more network traffic
than a
integrity constraint
definition
Ans : A

19. Which of the following is not an advantage of a client/server model
?
a] A client/server model allows centralised control of data
and
centralised implementation
of business rules.
b] A client/server model increases developer;s productivity
c] A client/server model is suitable for all applications
d] None of the above.
Ans : C

20. What does DLL stands for ?
a] Dynamic Language Library
b] Dynamic Link Library
c] Dynamic Load Library
d] None of the above
Ans : B

21. POST-BLOCK trigger is a
a] Navigational trigger
b] Key trigger
c] Transactional trigger
d] None of the above
Ans : A

22. The system variable that records the select statement that SQL *
FORMS
most recently used
to populate a block is
a] SYSTEM.LAST_RECORD
b] SYSTEM.CURSOR_RECORD
c] SYSTEM.CURSOR_FIELD
d] SYSTEM.LAST_QUERY
Ans: D

23. Which of the following is TRUE for the ENFORCE KEY field
a] ENFORCE KEY field characterstic indicates the source of the
value
that SQL*FORMS
uses to populate the field
b] A field with the ENFORCE KEY characterstic should have the
INPUT
ALLOWED
charaterstic turned off
a] Only 1 is TRUE
b] Only 2 is TRUE
c] Both 1 and 2 are TRUE