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

Database Errors Interview Questions

Questions Answers Views Company eMail

PLS-00413: identifier in CURRENT OF clause is not a cursor name

1 5380

PLS-00414: no column 'string' in table

1 3780

PLS-00415: 'string' is an OUT parameter and cannot appear in a function

1 3291

PLS-00416: The third argument of DECODE cannot be NULL

1 3108

PLS-00417: unable to resolve "string" as a column

1 3758

PLS-00418: array bind type must match PL/SQL table row type

1 7719

PLS-00419: reference to remote attribute not permitted

1 3204

PLS-00420: can't call builtin routines remotely

1 4979

PLS-00421: synonym definitions nested too deeply; possible loop in synonyms

1 10139

PLS-00422: no PL/SQL translation for the bindtype given for this bind variable

1 6064

PLS-00423: ORDER BY item must be the number of a SELECT-list expression

1 3806

PLS-00424: RPC defaults cannot include Package State

1 6178

PLS-00425: in SQL, function argument and return types must be SQL type

1 6500

PLS-00427: RPC defaults cannot use builtins when versions of STANDARD differ

1 3041

PLS-00428: an INTO clause is expected in this SELECT statement

1 8789

Un-Answered Questions { Database Errors }

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2788

What is the use of NOLOCK locking hint?

1837

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

2269

IMP-00064: Definition of LOB was truncated by export

6473

what is the instrument that used in Mechanical Energy??

2741

When do you get "getwmicomexception"?

2735

ORA-26084: direct path context already finished

2000

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

1823

ORA-26028: index string.string initially in unusable state

3916

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

2669

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

2722

ORA-26094: stream format error: input column overflow

2859

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

1801

NZE-28890: Entrust Login Failed

1932

How will you Handle Error in SQL SERVER 2008?

2446

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