Printable View
1) How many DB can be created in a machine
2) How many column can be used in a Select Statement
3) How many tables that can be joined in a select statement
4) How many SUB QUERY that can be written in a session
5) How many column can we have in a Table
6) What is the Max size of Procedure
7) How many parameter you can pass in a procedure
8) How many Objects you can create in DB
[b]Question asked by visitor Viji[/b]
Dear you badly need to go through some oracle books for answer of all the above question.
1) How many DB can be created in a machine
Ans: There is no particular limit for DB in a machine but it depends on the size of RAM and size of the DB.
2) How many column can be used in a Select Statement
3) How many tables that can be joined in a select statement
4) How many SUB QUERY that can be written in a session
5) How many column can we have in a Table
6) What is the Max size of Procedure
7) How many parameter you can pass in a procedure
8) How many Objects you can create in DB
Ans:There is no limit for objects. You can create n number of objects in DB
[b]Question asked by visitor Viji[/b][/QUOTE]
To get some answers to ur questions, follow this [URL="http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/limits003.htm"]link[/URL]