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-02084: database name is missing a component

1 11071

ORA-02085: database link string connects to string

1 5552

ORA-02086: database (link) name is too long

1 3117

ORA-02087: object locked by another process in same transaction

1 2774

ORA-02088: distributed database option not installed

1 3399

ORA-02089: COMMIT is not allowed in a subordinate session

Oracle,

1 10279

ORA-02090: network error: attempted callback+passthru

1 3220

ORA-02091: transaction rolled back

1 5987

ORA-02092: out of transaction table slots for distributed transaction

1 3010

ORA-02093: TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)

1 3216

ORA-02094: replication option not installed

1 3615

ORA-02095: specified initialization parameter cannot be modified

1 5243

ORA-02096: specified initialization parameter is not modifiable with this option

1 4925

ORA-02097: parameter cannot be modified because specified value is invalid

1 8235

ORA-02098: error parsing index-table reference (:I)

1 3102

Un-Answered Questions { Database Errors }

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.

1647

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2531

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

2648

RMAN-05017: no copy of datafile number found to recover

2410

IMG-02003: 2FF03 - incorrect color histogram feature specification

1704

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

1676

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

2154

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

3382

ORA-26030: index string.string had string partitions made unusable due to:

1940

why we are using shift key in unix shell script

3161

what is the instrument that used in Mechanical Energy??

2679

What is Mutex error in Triggers?

3062

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

3665

NZE-28868: Peer certificate chain check failed.

2798

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

2695

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