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-04041: package specification must be created first before creating package body

1 3990

ORA-04042: procedure, function, package, or package body does not exist

1 17159

ORA-04043: object string does not exist

1 9391

ORA-04044: procedure, function, package, or type is not allowed here

1 11088

ORA-04045: errors during recompilation/revalidation of string.string

1 5511

ORA-04046: results of compilation are too large to support

1 3278

ORA-04047: object specified is incompatible with the flag specified

1 5998

ORA-04050: invalid or missing procedure, function, or package name

1 16880

ORA-04051: user string cannot use database link string.string

1 3510

ORA-04052: error occurred when looking up remote object stringstringstringstringstring

1 8565

ORA-04053: error occurred when validating remote object stringstringstringstringstring

1 7456

ORA-04054: database link string does not exist

1 17794

ORA-04055: Aborted: "string" formed a non-REF mutually-dependent cycle with "string".

1 4277

ORA-04060: insufficient privileges to execute string

1 7885

ORA-04061: existing state of string has been invalidated

1 4538

Un-Answered Questions { Database Errors }

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

6794

ORA-26095: unprocessed stream data exists

3642

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

6721

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

2181

What is the use of NOLOCK locking hint?

1837

hp asking for replication floppy to do reinstall 25254 server assistant

2967

why we are using shift key in unix shell script

3237

NZE-28868: Peer certificate chain check failed.

2868

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

1736

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

3440

What is Mutex error in Triggers?

3129

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

2715

what is new g/l functionality

2676

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

2235

ORA-26084: direct path context already finished

1999

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