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-19718: length for command id longer than string

1 2920

ORA-19719: length for operation name longer than string

1 2898

ORA-19720: Error occurred when converting an OCI number into an SCN

1 3251

ORA-19721: Cannot find datafile with absolute file number string in tablespace string

1 7784

ORA-19722: datafile string is an incorrect version

1 8301

ORA-19723: Cannot recreate plugged in read-only datafile string

1 8488

ORA-19724: snapshot too old: snapshot time is before file string plug-in time

1 3452

ORA-19725: can not acquire plug-in enqueue

1 3628

ORA-19726: cannot plug data [string] at level string into database running at compatibility level string

1 3779

ORA-19727: cannot plug data [string] at level string into database running Oracle string

1 3180

ORA-19728: data object number conflict between table string and partition string in table string

1 3537

ORA-19729: File string is not the initial version of the plugged in datafile

1 5325

ORA-19730: can not convert offline plugged-in datafile string

1 3146

ORA-19731: cannot apply change to unverified plugged-in datafile string

1 3575

ORA-19732: incorrect number of datafiles for tablespace string

1 2994

Un-Answered Questions { Database Errors }

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

1799

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

2298

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

1817

When do you get "getwmicomexception"?

2731

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

1731

ORA-26084: direct path context already finished

1998

What is the use of NOLOCK locking hint?

1832

NZE-28890: Entrust Login Failed

1924

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

3224

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

2753

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

2859

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

2709

ORA-16516: The current state is invalid for the attempted operation.

8875

hp asking for replication floppy to do reinstall 25254 server assistant

2963

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

3703

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