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-04001: sequence parameter string must be an integer

1 4070

ORA-04002: INCREMENT must be a non-zero integer

1 10777

ORA-04003: sequence parameter string exceeds maximum size allowed (string digits)

1 3815

ORA-04004: MINVALUE must be less than MAXVALUE

1 6288

ORA-04005: INCREMENT must be less than MAXVALUE minus MINVALUE

1 6020

ORA-04006: START WITH cannot be less than MINVALUE

1 11226

ORA-04007: MINVALUE cannot be made to exceed the current value

1 14715

ORA-04008: START WITH cannot be more than MAXVALUE

1 4553

ORA-04009: MAXVALUE cannot be made to be less than the current value

1 6503

ORA-04010: the number of values to CACHE must be greater than 1

1 8186

ORA-04011: sequence string must range between string and string

1 3132

ORA-04012: object is not a sequence

1 3266

ORA-04013: number to CACHE must be less than one cycle

1 17230

ORA-04014: descending sequences that CYCLE must specify MINVALUE

1 2881

ORA-04015: ascending sequences that CYCLE must specify MAXVALUE

1 5007

Un-Answered Questions { Database Errors }

ORA-26027: unique index string.string partition string initially in unusable state

6794

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

2181

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2757

ORA-26084: direct path context already finished

1999

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

2803

what is new g/l functionality

2676

ORA-16626: failed to enable specified object

2278

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.

2948

hp asking for replication floppy to do reinstall 25254 server assistant

2967

What is the meaning of lock escalation and why/how to stop this?

2715

What is Mutex error in Triggers?

3129

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

1823

ORA-26076: cannot set or reset value after direct path structure is allocated

2035

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

8881

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

2470

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