What things you will look for if you get following exception while making DB call ?<br/><br/>table or view does not exist
Javasearch.buggybread.com
Share

Search Interview Questions


 3356 questions in repository.
 There are more than 200 unanswered questions.
Click here and help us by providing the answer.
 Have a video suggestion.
Click Correct / Improve and please let us know.
Label / Company      Label / Company / Text

   



Java - Interview Questions and Answers

 Q1. What things you will look for if you get following exception while making DB call ?

table or view does not exist
Database
Admin
info@buggybread.com
Ans. First will check if the table or view actually exist in the DB

If it does , Will make sure to see that the application has rights on the schema that holds the respective Table.

Will then make sure that we have prefixed the schema with the table name while accessing it.

Will then make sure that its not DB Cache that's causing it as the table DDL might have been created recently.

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     sql   database   oracle   technical lead


Related Questions

  Is it necessary that each try block to be followed by catch block ?
  What's the benefit for specifying constraints like Not Null , Primary Key explicitly instead of specifying it against the column ?
  How can we disable a constraint ?
  Can we have foreign key reference to a non primary key column ?
  What should be done for auto generating primary key id in a table ?
  Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
  How to know the structure of a Table in Oracle ?
  How to know the constraints on a Table in Oracle ?
  How to know the default column value of a Table in Oracle ?




Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by FeedBurner



comments powered by Disqus
 

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.

Any input from you will be highly appreciated and It will unlock the application for 10 more requests.

Company Name:
Questions Asked:
         

X Close this