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-21600: path expression too long

1 2843

ORA-21601: attribute is not an object

1 3063

ORA-21602: operation does not support the specified typecode

1 3075

ORA-21603: property id [string] is invalid

1 2922

ORA-21604: property [string] is not a property of transient or value instances

1 3029

ORA-21605: property [string] is not a property of value instances

1 3202

ORA-21606: can not free this object

1 3122

ORA-21607: memory cartridge service handle not initialized

1 2951

ORA-21608: duration is invalid for this function

1 3802

ORA-21609: memory being resized without being allocated first

1 3128

ORA-21610: size [string] is invalid

1 3028

ORA-21611: key length [string] is invalid

1 3119

ORA-21612: key is already being used

1 2847

ORA-21613: key does not exist

1 2854

ORA-21614: constraint violation for attribute number [string]

1 3680

Un-Answered Questions { Database Errors }

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

2225

ORA-26095: unprocessed stream data exists

3572

ORA-16626: failed to enable specified object

2218

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

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

2665

why we are using shift key in unix shell script

3167

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

1768

When do you get "getwmicomexception"?

2682

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

3993

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-00064: Definition of LOB was truncated by export

6415

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

2410

ORA-26029: index string.string partition string initially in unusable state

2155

write a database figure to implement the master detained relationship.

2936

ORA-16516: The current state is invalid for the attempted operation.

8820

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