Home » SQL & PL/SQL » SQL & PL/SQL » qns about triggers, pl/table
qns about triggers, pl/table [message #202439] Thu, 09 November 2006 17:14 Go to next message
Messages: 1
Registered: November 2006
Junior Member
Can anyone answer these qns this will be very useful to me.
Thanks in advance Embarassed Embarassed

1.Where is pl/sql table declared statically?
1. Any function or procedure marked statically_reusable
2. Package body
3. trigger
4. function.

2.when stored in the database pl/sql table type (nested
table)is comprised of how many columns?.

1. 1
2. 2
3. 3
4. as many as necessary or one plus the no of columns in
the nested table.

3.How many triggers can be placed on the in PL/sql?
1.12 triggers but only one of each type.
2. 12 triggers can be any combinations
3. 1 trigger
4. only 6
5. no limit on the no of triggers.

4. Oracle makes pl/sql engine available in both client server side environments.
Which is true?
1. object definitions are true
2. work is dynamic distributed among the client& server.
3. network round trips are decreased.
4. program units are easily moved from server execution to
client execution.
5. data integrity is enhanced.

5.Purpose of exception handler used only in
1. client side pgms
2. stored procedures & functions
3. server side pgms
4. to allow pl/sql pgms to deal with anticipated &
unanticipated pgms.
6. which one is we canot use in triggers?.
1. update
2. lock table
3. Calls to pl/sql block.
4. DML

Re: qns about triggers, pl/table [message #202440 is a reply to message #202439] Thu, 09 November 2006 17:28 Go to previous messageGo to next message
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
The homework tutor is down the hall & 2nd door on the left.
Re: qns about triggers, pl/table [message #202491 is a reply to message #202440] Fri, 10 November 2006 00:51 Go to previous message
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
ha man i love you for this..
The homework tutor is down the hall & 2nd door on the left. 

this ones up for locking
Previous Topic: executeQuery vs. executeUpdate on a resultset
Next Topic: Is the line of code below redundant?
Goto Forum:

Current Time: Sat Aug 19 13:54:30 CDT 2017

Total time taken to generate the page: 0.06971 seconds