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-12989: invalid value for checkpoint interval

1 3378

ORA-12990: duplicate option specified

1 4739

ORA-12991: column is referenced in a multi-column constraint

1 12206

ORA-12992: cannot drop parent key column

1 6987

ORA-12993: tablespace 'string' is offline, cannot drop column

1 3424

ORA-12994: drop column option only allowed once in statement

1 2965

ORA-12995: no columns in partially dropped state

1 3537

ORA-12996: cannot drop system-generated virtual column

1 9795

ORA-12997: cannot drop primary key column from an index-organized table

1 3449

ORA-13000: dimension number is out of range

1 4069

ORA-13001: dimensions mismatch error

1 4247

ORA-13002: specified level is out of range

1 3009

ORA-13003: the specified range for a dimension is invalid

1 3935

ORA-13004: the specified buffer size is invalid

1 3649

ORA-13005: recursive HHCODE function error

1 3143

Un-Answered Questions { Database Errors }

IMP-00064: Definition of LOB was truncated by export

6413

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

2639

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2520

mount: mount to NFS server failed: System Error: Connection timed out

3668

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

6652

hp asking for replication floppy to do reinstall 25254 server assistant

2880

ORA-26027: unique index string.string partition string initially in unusable state

6746

ORA-26030: index string.string had string partitions made unusable due to:

1941

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

1708

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

2155

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

2230

[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

2724

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

2652

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

1617

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

2733

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