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

Database Errors Interview Questions

Questions Answers Views Company eMail

DRG-13012: language column must be a char, varchar, or varchar2 type

1 2932

DRG-13100: index is not partitioned

1 3016

DRG-13101: partition string does not exist in this index

1 3429

DRG-13102: index partition name must be specified

1 4107

DRG-13103: index table string is partitioned

1 2723

DRG-13104: indexes do not have equivalent settings for string

1 3178

DRG-13200: failed to load dictionary file string

1 2927

DRG-13300: document size bigger than string bytes

1 2769

DRG-13301: syntax error in token data when expecting string, at line string

1 2870

DRG-13302: number of wildcard offsets must be in the range string..string, at line string

1 2712

DRG-13303: value of wildcard offset must be in the range string..string, at line string

1 3023

DRG-13304: character referenced by wildcard attribute is not a wildcard character, at line string

1 3026

DRG-13305: 'off' attribute value must be in the range string..string, at line string

1 2645

DRG-13306: 'len' attribute value must be in the range string..string, at line string

1 2715

DRG-13307: 'off'=string and 'len'=string references character past end-of-file of string character document, at line string

1 3017

Un-Answered Questions { Database Errors }

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

2593

ORA-16626: failed to enable specified object

2214

How will you Handle Error in SQL SERVER 2008?

2401

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

2430

What is the use of NOLOCK locking hint?

1783

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

2648

When do you get "getwmicomexception"?

2678

what is the instrument that used in Mechanical Energy??

2679

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

2104

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

2410

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

2798

ORA-26094: stream format error: input column overflow

2795

What severity level errors are managed in TRY-CATCH block?

2222

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

2520

ORA-26079: file "string" is not part of table string.string

1956

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