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-22898: existing scope clause on "string" points to a table other than the one mentioned in the referential constraint

1 3338

ORA-22899: cannot specify both scope and rowid constraint on ref column

1 3411

ORA-22900: the SELECT list item of THE subquery is not a collection type

1 3487

ORA-22901: cannot compare nested table or VARRAY or LOB attributes of an object type

1 8328

ORA-22902: CURSOR expression not allowed

1 7290

ORA-22903: MULTISET expression not allowed

1 5507

ORA-22904: invalid reference to a nested table column

1 3139

ORA-22905: cannot access rows from a non-nested table item

1 7919

ORA-22906: cannot perform DML on expression or on nested table view column

1 3799

ORA-22907: invalid CAST to a type that is not a nested table or VARRAY

1 5183

ORA-22908: reference to NULL table value

1 3539

ORA-22909: exceeded maximum VARRAY limit

1 9977

ORA-22910: cannot specify schema name for nested tables

1 3074

ORA-22911: duplicate storage specification for the nested table item

1 2936

ORA-22912: specified column or attribute is not a nested table type

1 5216

Un-Answered Questions { Database Errors }

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

3863

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

2454

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2870

How will you Handle Error in SQL SERVER 2008?

2403

what is the instrument that used in Mechanical Energy??

2682

How to view the error log for any specific instance?

2486

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

3385

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

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

2733

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

2225

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

1958

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

2665

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.

2539

ORA-16627: No standby databases support the overall protection mode.

3993

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6652

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