Home » SQL & PL/SQL » SQL & PL/SQL » Help on questions faced at interview
Help on questions faced at interview [message #229202] Fri, 06 April 2007 00:16 Go to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
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 #229207 is a reply to message #229205] Fri, 06 April 2007 00:49 Go to previous messageGo to next message
thandavakarumuri
Messages: 64
Registered: May 2005
Member
Thanks for the immediate reply.

so, can i answer like this..
- i have used some 20 tables/proc's/fun's/pack's?

And i did not get you with this
procedure/function: about 1-2 screens.

how many columns can a table have?

plz ans them

Thanks,
Krishna
Re: Help on questions faced at interview [message #229210 is a reply to message #229207] Fri, 06 April 2007 00:58 Go to previous messageGo to next message
Frank
Messages: 7880
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 #229213 is a reply to message #229210] Fri, 06 April 2007 01:06 Go to previous messageGo to next message
thandavakarumuri
Messages: 64
Registered: May 2005
Member
Ohk i have double checked it.

I really appreciate your help!

-Krishna
Re: Help on questions faced at interview [message #229215 is a reply to message #229210] Fri, 06 April 2007 01:14 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Frank
Messages: 7880
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 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Find foreign keys between two tables
Next Topic: How to calculate time difference if not using date datatype
Goto Forum:
  


Current Time: Fri Dec 09 21:28:55 CST 2016

Total time taken to generate the page: 0.08851 seconds