Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

SQL*Loader-00622: Column not found before end of logical record (use TRAILING NULLCOLS)

2 31915

SQL*Loader-00623: second enclosure string not present

1 7315

SQL*Loader-00624: no terminator found after TERMINATED and ENCLOSED field

2 17703

SQL*Loader-00625: Multibyte character error in control file.

1 7213

SQL*Loader-00626: Character set conversion buffer overflow.

1 3845

SQL*Loader-00627: Character set conversion graph not available.

1 2912

SQL*Loader-00628: Character set conversion error.

1 3036

SQL*Loader-00640: Variable length field was truncated.

1 3750

SQL*Loader-00641: Invalid packed decimal nibble.

1 5825

SQL*Loader-00642: Relative start position > absolute field end position.

1 3154

SQL*Loader-00643: error executing INSERT statement for table string

1 3857

SQL*Loader-00644: end of logical record found when reading length of varying length field

1 3215

SQL*Loader-00645: error converting character length field to a number

1 4976

SQL*Loader-00646: lob set to EMPTY in column string, row number, table string

1 3647

SQL*Loader-00647: Integer to number conversion error

1 3426

Un-Answered Questions { Database Errors }

What is live lock, deadlock and what is Lock escalation?

2434

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

2232

When do you get "getwmicomexception"?

2682

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2601

ORA-16626: failed to enable specified object

2218

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

1620

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

3385

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

2666

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

1747

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

2643

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

1683

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

2410

what is the instrument that used in Mechanical Energy??

2682

ORA-26084: direct path context already finished

1949

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

2107

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