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-02038: define is not allowed for array type

1 3180

ORA-02039: bind by value is not allowed for array type

1 3001

ORA-02040: remote database string does not support two-phase commit

1 3558

ORA-02041: client database did not begin a transaction

1 5650

ORA-02042: too many distributed transactions

1 5101

ORA-02043: must end current transaction before executing string

1 3840

ORA-02044: transaction manager login denied: transaction in progress

1 3684

ORA-02045: too many local sessions participating in global transaction

1 7893

ORA-02046: distributed transaction already begun

1 8895

ORA-02047: cannot join the distributed transaction in progress

1 6132

ORA-02048: attempt to begin distributed transaction without logging on

1 10247

ORA-02049: timeout: distributed transaction waiting for lock

1 6218

ORA-02050: transaction string rolled back, some remote DBs may be in-doubt

1 9864

ORA-02051: another session in same transaction failed

Axede,

1 10847

ORA-02052: remote transaction failure at string

1 3343

Un-Answered Questions { Database Errors }

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

2230

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

3704

What is the use of NOLOCK locking hint?

1832

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1700

When do you get "getwmicomexception"?

2733

what is the instrument that used in Mechanical Energy??

2733

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

2699

hp asking for replication floppy to do reinstall 25254 server assistant

2963

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

1799

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

4039

ORA-26076: cannot set or reset value after direct path structure is allocated

2034

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3226

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2581

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

1734

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

2863

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