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-01231: cannot make read write - file string is offline

1 2910

ORA-01232: cannot start online backup - file string is being made read-only

1 3064

ORA-01233: file string is read only - cannot recover using backup controlfile

1 2896

ORA-01234: cannot end backup of file string - file is in use or recovery

1 2919

ORA-01235: END BACKUP failed for string file(s) and succeeded for string

1 3949

ORA-01236: Error string occurred during initialization of file header access

1 3170

ORA-01237: cannot extend datafile string

2 7967

ORA-01238: cannot shrink datafile string

1 3206

ORA-01239: database must be in ARCHIVELOG mode to use external cache

1 3411

ORA-01240: too many data files to add in one command

1 3215

ORA-01241: an external cache has died

1 2952

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

1 5224

ORA-01243: system tablespace file suffered media failure

1 4134

ORA-01244: unnamed datafile(s) added to controlfile by media recovery

1 5463

ORA-01245: offline file string will be lost if RESETLOGS is done

2 20770

Un-Answered Questions { Database Errors }

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

What is the meaning of lock escalation and why/how to stop this?

2716

How to view the error log for any specific instance?

2546

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1708

ORA-16627: No standby databases support the overall protection mode.

4042

RMAN-05017: no copy of datafile number found to recover

2471

IMG-02003: 2FF03 - incorrect color histogram feature specification

1769

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

2035

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3229

ORA-26029: index string.string partition string initially in unusable state

2236

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

2181

What is Mutex error in Triggers?

3130

IMP-00064: Definition of LOB was truncated by export

6473

ORA-26079: file "string" is not part of table string.string

2006

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2779

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