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-01571: redo version string incompatible with ORACLE version string

1 3337

ORA-01572: rollback segment 'string' cannot be brought online, string extents exceeded

1 2920

ORA-01573: shutting down instance, no further change allowed

1 3359

ORA-01574: maximum number of concurrent transactions exceeded

1 4084

ORA-01575: timeout waiting for space management resource

1 7474

ORA-01576: The instance string is not enabled

1 7974

ORA-01577: cannot add log file 'string' - file already part of database

1 9880

ORA-01578: ORACLE data block corrupted (file # string, block # string)

1 4474

ORA-01579: write error occurred during recovery

1 6561

ORA-01580: error creating control backup file string

1 7250

ORA-01581: attempt to use rollback segment (string) new extent (string) which is being allocated

1 3313

ORA-01582: unable to open controlfile for backup

1 3437

ORA-01583: unable to get block size of controlfile to be backed up

1 2904

ORA-01584: unable to get file size of controlfile to be backed up

1 2838

ORA-01585: error identifying backup file string

1 3134

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2484

NZE-28890: Entrust Login Failed

1877

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

1958

What is Mutex error in Triggers?

3064

what is new g/l functionality

2611

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

3988

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.

2870

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

1706

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1616

ORA-16626: failed to enable specified object

2217

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

2650

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

2432

IMP-00064: Definition of LOB was truncated by export

6413

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3383

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

8817

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