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-36800: (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP

1 2934

ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.

1 2958

ORA-36804: (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP.

1 2933

ORA-36806: (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.

1 3259

ORA-36808: (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.

1 2797

ORA-36810: (XSTBLFUNC05) Analytic workspace object number does not exist.

1 3607

ORA-36812: (XSTBLFUNC06) Invalid Syntax at '?'.

1 3097

ORA-36814: (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).

1 2675

ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.

1 2995

ORA-36820: (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.

1 3004

ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.

1 3136

ORA-36872: (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.

1 2970

ORA-36873: (XSTFDSC03) Column type must be specified explicitly.

1 2907

ORA-36874: (XSFTDSC04) Expression string cannot be used to define a column in a LIMITMAP.

1 3182

ORA-36875: (XSFTDSC05) LIMITMAP is missing or is not a string literal.

1 3427

Un-Answered Questions { Database Errors }

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

2733

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2805

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

2741

How will you Handle Error in SQL SERVER 2008?

2403

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

1747

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

2453

What is Mutex error in Triggers?

3069

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

2107

NZE-28868: Peer certificate chain check failed.

2803

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

2434

what is new g/l functionality

2612

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?

2665

why we are using shift key in unix shell script

3167

2597

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