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-17500: ODM err:string

1 4845

ORA-17501: logical block size string is invalid

2 10001

ORA-17502: ksfdcre:string Failed to create file string

1 7748

ORA-17503: ksfdopn:string Failed to open file string

1 5252

ORA-17504: ksfddel:Failed to delete file string

1 3892

ORA-17505: ksfdrsz:string Failed to resize file to size string blocks

1 11496

ORA-17506: I/O Error Simulation

1 3117

ORA-17507: I/O request size string is not a multiple of logical block size

1 10906

ORA-17508: I/O request buffer ptr is not alligned

1 3641

ORA-17509: Attempt to do i/o beyond block1 offset

1 3393

ORA-17510: Attempt to do i/o beyond file size

1 13594

ORA-17610: file 'string' does not exist and no size specified

1 6588

ORA-17611: ksfd: file 'string' cannot be accessed, global open closed

1 4385

ORA-17612: Failed to discover Oracle Disk Manager library, return value string

1 9729

ORA-17613: Failed to initialize Oracle Disk Manager library: string

1 3516

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

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2868

ORA-16626: failed to enable specified object

2278

ORA-26095: unprocessed stream data exists

3644

ORA-26094: stream format error: input column overflow

2859

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2770

ORA-26084: direct path context already finished

2001

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

What is SCD (Slowly Changing Dimensions)? What are its types?

2724

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2524

How to view the error log for any specific instance?

2546

[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

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

1801

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

3716

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

6794

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