Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

Question Posted / dev

Answers were Sorted based on User's Feedback



My select statement is not working as expected, So, to overcome from such issues what are the steps ..

Answer / nitin

Possibe Scenarios
1. Check table is being locked by any other resourse.
2. Table reach to HIGH WATER MARK, resuse the storage or SHINK SPACE could overcome this problem.
3. Check the data volume.
4. Table or index(if any) is analysed or their stats are gather or not.

Is This Answer Correct ?    2 Yes 0 No

My select statement is not working as expected, So, to overcome from such issues what are the steps ..

Answer / nitinsharma06

1.Table is being Locked by any other resourse or not.
2.Table is reach to high water mark, REUSE STORAGE or SHRINK SPACE could resolve the issue.
3.Table or Indx(if any) stats are gather or not.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Explain the select statement in sql?

0 Answers  

Name some usages of database trigger?

0 Answers  

Why select is used in sql?

0 Answers  

What is the limitation on the block size of pl/sql?

0 Answers  

What is constant in pl sql?

0 Answers  

How do I delete a trigger?

0 Answers  

What is sorting in sql?

0 Answers  

What are the built in functions of sql?

0 Answers  

how do you login to mysql using unix shell? : Sql dba

0 Answers  

how to sort records in sql?

3 Answers  

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

Is sql a programming?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories