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-31502: invalid number supplied for supplemental_processes

1 2822

ORA-31503: invalid date supplied for begin_date or end_date

1 3083

ORA-31504: cannot alter or drop predefined change source

1 3275

ORA-31505: cannot alter or drop predefined change set

1 3154

ORA-31506: duplicate subscription name string

1 4486

ORA-31507: %s parameter value longer than maximum length string

1 3012

ORA-31508: invalid parameter value for synchronous change set

1 3623

ORA-31509: publication does not exist

1 4478

ORA-31510: name uses reserved prefix CDC$

1 2918

ORA-31511: name exceeds maximum length of 30 characters

1 3035

ORA-31512: name cannot contain double quotation marks

1 3443

ORA-31513: unsupported column type specified in change table

1 4314

ORA-31514: change set string disabled due to capture error

Oracle,

1 7386

ORA-31515: CDC change source string already exists

1 2740

ORA-31516: CDC change set string already exists

1 3037

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2496

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

2661

What is Mutex error in Triggers?

3085

why we are using shift key in unix shell script

3193

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

3399

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

2124

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

6758

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?

2735

[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

2738

NZE-28890: Entrust Login Failed

1891

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.

2890

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1695

ORA-26084: direct path context already finished

1960

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

2752

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

3680

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