Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-01201: file string header failed to write correctly

1 7169

ORA-01202: wrong incarnation of this file - wrong creation time

1 5998

ORA-01203: wrong incarnation of this file - wrong creation SCN

1 7819

ORA-01204: file number is string rather than string - wrong file

1 5493

ORA-01205: not a data file - type number in header is string

1 4354

ORA-01206: file is not part of this database - wrong database id

1 9364

ORA-01207: file is more recent than controlfile - old controlfile

1 4459

ORA-01208: data file is an old version - not accessing current version

1 5497

ORA-01209: data file is from before the last RESETLOGS

1 5748

ORA-01210: data file header is media corrupt

1 6296

ORA-01211: Oracle7 data file is not from migration to Oracle8

1 3112

ORA-01212: MAXLOGMEMBERS may not exceed string

1 3357

ORA-01213: MAXINSTANCES may not exceed string

1 3667

ORA-01214: MAXLOGHISTORY may not exceed string

1 3584

ORA-01215: enabled thread string is missing after CREATE CONTROLFILE

1 3476

Un-Answered Questions { Database Errors }

What severity level errors are managed in TRY-CATCH block?

2270

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2701

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2948

ORA-16626: failed to enable specified object

2278

IMP-00070: Lob definitions in dump file are inconsistent with database.

1801

ORA-26076: cannot set or reset value after direct path structure is allocated

2035

What is live lock, deadlock and what is Lock escalation?

2502

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2789

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6723

ORA-26028: index string.string initially in unusable state

3916

ORA-16516: The current state is invalid for the attempted operation.

8883

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2300

When do you get "getwmicomexception"?

2735

ORA-26032: index string.string loading aborted after string keys

2183

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2868

For More Un-Answered { Database Errors } Questions Click Here