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-06571: Function string does not guarantee not to update database

1 6330

ORA-06572: Function string has out arguments

1 6322

ORA-06573: Function string modifies package state, cannot be used here

1 3304

ORA-06574: Function string references package state, cannot execute remotely

1 3623

ORA-06575: Package or function string is in an invalid state

1 7162

ORA-06576: not a valid function or procedure name

1 7316

ORA-06577: output parameter not a bind variable

1 15422

ORA-06578: output parameter cannot be a duplicate bind

1 2839

ORA-06579: Bind variable not big enough to hold the output value

1 3636

ORA-06580: Hash Join ran out of memory while keeping large rows in memory

1 4324

ORA-06592: CASE not found while executing CASE statement

1 7058

ORA-06593: %s is not supported with natively compiled PL/SQL modules

1 3346

ORA-06600: LU6.2 Driver: SNA software is not loaded

1 2876

ORA-06601: LU6.2 Driver: Invalid database ID string

1 3103

ORA-06602: LU6.2 Driver: Error allocating context area

1 3129

Un-Answered Questions { Database Errors }

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2797

[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

2717

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

1741

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2209

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.

2868

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

2148

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?

2719

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

2101

IMP-00064: Definition of LOB was truncated by export

6409

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

1616

ORA-26094: stream format error: input column overflow

2792

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 ??

1671

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

2656

ORA-26084: direct path context already finished

1944

NZE-28868: Peer certificate chain check failed.

2797

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