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-30390: the source statement is not equivalent to the destination statement

1 2981

ORA-30391: the specified rewrite equivalence does not exist

1 2853

ORA-30392: the checksum analysis for the rewrite equivalence failed

1 3406

ORA-30393: a query block in the statement did not rewrite

1 3953

ORA-30394: source statement identical to the destination statement

1 2689

ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater

1 3026

ORA-30396: rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater

1 2699

ORA-30430: list does not contain any valid summaries

1 2908

ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 2952

ORA-30432: summary 'string.string' is in INVALID state

1 2788

ORA-30433: 'string.string' is not a summary

1 2803

ORA-30434: refresh method must be one of FC?AN, not 'string'

1 2798

ORA-30435: job_queue_processes must be non-zero in order to refresh summaries

1 3337

ORA-30436: unable to open named pipe 'string'

1 3225

ORA-30437: all job queue processes have stopped running

1 2873

Un-Answered Questions { Database Errors }

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-00064: Definition of LOB was truncated by export

6431

[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

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

2670

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

1759

When do you get "getwmicomexception"?

2693

ORA-26095: unprocessed stream data exists

3594

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

2261

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

2167

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2720

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

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

4006

ORA-26082: load of overlapping segments on table string.string is not allowed

1784

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

2682

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