Home » SQL & PL/SQL » SQL & PL/SQL » Some typical questions
Some typical questions [message #211628] Sat, 30 December 2006 02:19 Go to next message
Messages: 15
Registered: May 2006
Junior Member
Hi ,

Wish u Happy New Year,

Recently I came across , some questions , and tried to answer few , can someone verify ?

1. What is the maximum no of columns you can have in a composite primary key.
d.none of above

2. Which of the following is true ?
a. we should not specify size of the datatype of the parameter in procedure
b. we should not specify size of the datatype of the parameter in function.
c. both a and b.
d. none of above.

3.What is the result when an arithmetic operationis carried out with null

a. error
d.none of above

4.what is the latest date that can be obtained from oracle ?
I guess Jan 1 4712BC

5. How do you debug a pl/sql program ?

Looks like easy questions , but little tricky and can cause confusion.

Let me know of your views.

Re: Some typical questions [message #211629 is a reply to message #211628] Sat, 30 December 2006 03:10 Go to previous message
Messages: 1848
Registered: November 2006
Senior Member

you will find answers to your questions

1. here
2. here and here
3. here
4. here
5. eg. here (as I do not have any experience with this stuff)

Next time consult the documentation yourself.
Previous Topic: 1 statement to delete , update 2 tables
Next Topic: Build custom sum function
Goto Forum:

Current Time: Sat Aug 19 04:29:16 CDT 2017

Total time taken to generate the page: 0.09374 seconds