| Help on questions faced at interview [message #229202] |
Fri, 06 April 2007 00:16  |
thandavakarumuri
Messages: 64
Registered: May 2005
|
Member |
|
|
Hello There,
I am seeking for a oracle job. I have faced this question in the interview.
Questions about size of DB
Q:what is the size of the database you have worked so far?
Me asked: in terms of what?
Q:size of the instance of your module
Me said: about one lack of records
I know thats wrong answer.
Questions about table size
Q:what is the size of the table you have used in your last project?
I did not answer this
Could you please help me in this? Plz tell me how can we represent the size of table/DB/procedure/function. First of all, is there any term or word like this?
Plz tell me following
1.how many columns can a table can have and size of the table
2.how many rows of code can a package/procedure/function/trigger have and the size of each
I appreciated your earliest and detailed reply.
Thanks,
Krishna
|
|
|
|
| Re: Help on questions faced at interview [message #229205 is a reply to message #229202] |
Fri, 06 April 2007 00:37  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
It quite depends on what you are applying for. As a developer, I would tell them the number of tables, views and stored program units to give them an idea, together with the number of records in the key tables. (eg. number of students for an application tracking course-info)
As a DBA, you'd probably add to that the physical size of the database files.
| Quote: | 1.how many columns can a table can have and size of the table
2.how many rows of code can a package/procedure/function/trigger have and the size of each
|
1: quite easy to find if you'd search for that
2: There is no real limit to that. The practical limit would be:
package: none
procedure/function: about 1-2 screens
trigger: as small as possible. (only assign PK-column with sequence)
|
|
|
|
|
|
| Re: Help on questions faced at interview [message #229210 is a reply to message #229207] |
Fri, 06 April 2007 00:58 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| thandavakarumuri wrote on Fri, 06 April 2007 07:49 | so, can i answer like this..
- i have used some 20 tables/proc's/fun's/pack's?
|
I don't know; I thought I made it quite clear what I would tell them..
Ideally, the code for a procedure should fit on one screen. This can be achieved by modular programming, but can in reality turn out to be too little, hence my 1-2 screens.
| Quote: | how many columns can a table have?
|
I did answer this one.
[Updated on: Fri, 06 April 2007 00:58] Report message to a moderator |
|
|
|
|
|
| Re: Help on questions faced at interview [message #229215 is a reply to message #229210] |
Fri, 06 April 2007 01:14 |
thandavakarumuri
Messages: 64
Registered: May 2005
|
Member |
|
|
You must be having great experience on oracle technologies. Right? I would appreciate if you could help me in this too. Where are you located? I am in Texas - USA. Where are you working?
Could you please let me know the difference between
1.oracle9i and oracle 10g
2.reports6i and forms6i
3.reports/discover
4.plsql/sql server
Thanks,
Krishna
|
|
|
|
| Re: Help on questions faced at interview [message #229234 is a reply to message #229215] |
Fri, 06 April 2007 03:19 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| Quote: | Could you please let me know the difference between
1.oracle9i and oracle 10g
2.reports6i and forms6i
3.reports/discover
4.plsql/sql server
|
Hm, I would have sworn they have Google in Texas - USA as well...
|
|
|
|
| Re: Help on questions faced at interview [message #229244 is a reply to message #229207] |
Fri, 06 April 2007 03:52 |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
It seems Frank's answer is clear.
1-2 screens: As he said it is a practical limit because procedure greater than that are hard to handle by a human.
number of columns, as Frank said "quite easy to find if you'd search for that". Do you want to try a search?
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
