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

What is $$ in sql?

0 Answers  

How to add, remove, modify users using sql?

0 Answers  

how to retrieve the top 3 salaries of the table using rownum

31 Answers   Oracle,

What are local and global variables and their differences?

0 Answers  

what is an alias command? : Sql dba

0 Answers  

Explain alias in sql?

0 Answers  

What is the difference between an inner join and an outer join?

0 Answers  

explain about mysql and its features. : Sql dba

0 Answers  

Do foreign keys improve performance?

0 Answers  

What is cte?

0 Answers  

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

How many tables can you join in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories