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: 1834
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: Importing .sql file!
Next Topic: Is it possible top create a database-wide Table Column Alias?
Goto Forum:

Current Time: Mon Feb 27 17:18:43 CST 2017

Total time taken to generate the page: 0.17743 seconds