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
vijigopal78
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
pragma.
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
5.commit

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
BlackSwan
Messages: 25046
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
amul
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: Shadow and Stagging Tables
Next Topic: number of columns in csv file
Goto Forum:
  


Current Time: Thu Dec 08 18:46:40 CST 2016

Total time taken to generate the page: 0.08100 seconds