Database Errors Interview Preparation Guide
Download PDF

Database Errors frequently Asked Questions in various Database Errors job Interviews by interviewer. The set of Database Errors interview questions here ensures that you offer a perfect answer to the interview questions posed to you. Get preparation of Database Errors job interview

20 Database Errors Questions and Answers:

1 :: How to Select 38th row details in table without using rownum?

Select * from Table_name
where rownum < 39
MINUS
Select * From Table_name
Where rownum < 38;

2 :: Display details of employees who are senior to there own manager?

select e.ename,e.hiredate,m.ename,m.hiredate from emp e,emp m
where e.mgr=m.empno
and e.hiredate<m.hiredate

3 :: How to resolve the sqlcode -501 error in db2?

This is due to the cursor declaration in which the application program has attempted to fetch some data's into a cursor that was neither declared nor opened. So, Always follow DECLARE,OPEN,FETCH,CLOSE while working with cursors.

4 :: When e open the data base the data base gives error as initializing or terminating how we log into data base?

just wait for a few seconds and then try
its
Database initializing or shutdown in process

5 :: This is the exception raised when i am working with oracle 11g java.lang.ClassNotFoundException: oracle.jdbc.Driver.Ora
cleDriver.. but i set the class path for both oracle and java?

ClassNotFoundException is the checked exception so we must handle that one or we can declare as throws keyword.
ex:
class EmployeeDao{
public static void main(String args[0]throws SQLException, ClassNotFoundException{
------------
-------------
}

}

6 :: TNS-00204: Started tracing in intlsnr

Cause: Internal message- Successfully started tracing
information.

Action: None.

Please add more information about this Error

7 :: TNS-00205: Turning off tracing in intlsnr

Cause: Internal message - Turned off tracing in the
Interchange listener.

Action: None

Please add more information about this Error

8 :: TNS-00206: Status Information for Interchange string:

Cause: Message sent back by Interchange as header for status
request.

Action: None

Please add more information about this Error

9 :: TNS-00207: Uptime : number days number hr. number min.
number sec

Cause: Part of status request.

Action: None

Please add more information about this Error

10 :: TNS-00208: Logging : string

Cause: Part of status request.

Action: None

Please add more information about this Error

11 :: TNS-00209: Tracing : string

Cause: Part of status request Interchange.

Action: None

Please add more information about this Error