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-00642: local collection types not allowed in SQL statements

1 10615

PLS-00643: booleans, index tables, records and cursors not allowed in SQL statements

1 2848

PLS-00644: character set mismatch found at 'string' among result expressions in a CASE expression

1 2978

PLS-00645: character set mismatch found at 'string' among operands in a COALESCE expression

1 2961

PLS-00646: MAP or ORDER method must be defined in the root of the subtype hierarchy

1 4263

PLS-00647: attribute by name "string" conflicts with method by same name

1 2754

PLS-00648: type of supertype attribute "string" can not be a subtype or reference to a subtype in this release

1 3213

PLS-00649: method "string" can be overridden only once per object type

1 3454

PLS-00650: invalid type for PARTITION/CLUSTER/ORDER BY clause

1 3379

PLS-00651: implementation type in Aggregate/Table function should be a valid type

1 2992

PLS-00652: aggregate functions should have exactly one argument

1 5699

PLS-00653: aggregate/table functions are not allowed in PL/SQL scope

1 18192

PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE

1 3300

PLS-00655: only functions can be declared as PIPELINED

1 3022

PLS-00656: field 'string' not available in input argument

1 6381

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2546

ORA-26084: direct path context already finished

2000

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2768

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

1801

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.

2582

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2259

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

1671

what is new g/l functionality

2681

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

3229

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

2804

How will you Handle Error in SQL SERVER 2008?

2446

When do you get "getwmicomexception"?

2735

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

2182

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

3440

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2523

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