Home » RDBMS Server » Server Administration » Interview question (Oracle 12c/11g/10g/9i Databases, Unix)
Interview question [message #673325] Thu, 15 November 2018 01:39 Go to next message
BalajiDBA
Messages: 22
Registered: October 2018
Junior Member
Hi,

There are 10,0000 data exist in table. Out of which 9000 data deleted from it.
Could you please tell me what would happen if we try to query the table?

Regards,
Balaji

[Updated on: Thu, 15 November 2018 01:40]

Report message to a moderator

Re: Interview question [message #673327 is a reply to message #673325] Thu, 15 November 2018 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 66205
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read the doc FIRST.

Re: Interview question [message #673330 is a reply to message #673325] Thu, 15 November 2018 04:18 Go to previous messageGo to next message
gazzag
Messages: 1063
Registered: November 2010
Location: Bristol, UK
Senior Member
At what point are your querying the table? Has the deletion started/finished? Has the transaction been committed?
Re: Interview question [message #673334 is a reply to message #673330] Thu, 15 November 2018 06:47 Go to previous messageGo to next message
BalajiDBA
Messages: 22
Registered: October 2018
Junior Member
Quote:
At what point are your querying the table? Has the deletion started/finished? Has the transaction been committed?
Quote:
Has the deletion started/finished?
Yes
Quote:
Has the transaction been committed?
I have no idea.It was an interview question. I didn't ask this to him.

Regards,
Balaji
Re: Interview question [message #673335 is a reply to message #673334] Thu, 15 November 2018 07:10 Go to previous messageGo to next message
gazzag
Messages: 1063
Registered: November 2010
Location: Bristol, UK
Senior Member
You should
have asked that question then. Maybe that was the point.
Re: Interview question [message #673343 is a reply to message #673325] Thu, 15 November 2018 21:00 Go to previous messageGo to next message
trantuananh24hg
Messages: 731
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
BalajiDBA wrote on Thu, 15 November 2018 07:39
Hi,

There are 10,0000 data exist in table. Out of which 9000 data deleted from it.
Could you please tell me what would happen if we try to query the table?

Regards,
Balaji
You have got a box with 10.000 ice-creams inside, sold 9000 just yesterday. What will happen, if me - a little boy to ask to buy one?
Re: Interview question [message #673357 is a reply to message #673343] Fri, 16 November 2018 02:40 Go to previous message
gazzag
Messages: 1063
Registered: November 2010
Location: Bristol, UK
Senior Member
You're going to get a lot of ice-cream!
Previous Topic: OPatch failed with error code = 255
Next Topic: Table size with BLOB column (CM merged 2)
Goto Forum:
  


Current Time: Sat Feb 23 13:42:02 CST 2019