OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Interview question (Oracle 12c/11g/10g/9i Databases, Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Interview question [message #673325]

Thu, 15 November 2018 01:39

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior 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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read the doc FIRST.

Report message to a moderator

Re: Interview question [message #673330 is a reply to message #673325]

Thu, 15 November 2018 04:18

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

At what point are your querying the table? Has the deletion started/finished? Has the transaction been committed?

Report message to a moderator

Re: Interview question [message #673334 is a reply to message #673330]

Thu, 15 November 2018 06:47

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior 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

Report message to a moderator

Re: Interview question [message #673335 is a reply to message #673334]

Thu, 15 November 2018 07:10

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You should
have asked that question then. Maybe that was the point.

Report message to a moderator

Re: Interview question [message #673343 is a reply to message #673325]

Thu, 15 November 2018 21:00

trantuananh24hg
Messages: 744
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?

Report message to a moderator

Re: Interview question [message #673357 is a reply to message #673343]

Fri, 16 November 2018 02:40

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You're going to get a lot of ice-cream!

Report message to a moderator

Previous Topic:	OPatch failed with error code = 255
Next Topic:	Table size with BLOB column (CM merged 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 08:39:26 CST 2024