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-02434: cannot enable unique(string) - unique key not defined for table

1 8894

ORA-02435: cannot disable unique(string) - unique key not defined for table

1 3371

ORA-02436: date or system variable wrongly specified in CHECK constraint

1 4706

ORA-02437: cannot validate (string.string) - primary key violated

1 8612

ORA-02438: Column check constraint cannot reference other columns

1 7987

ORA-02439: Unique index on a deferrable constraint is not allowed

1 3810

ORA-02440: Create as select with referential constraints not allowed

1 3206

ORA-02441: Cannot drop nonexistent primary key

1 13182

ORA-02442: Cannot drop nonexistent unique key

1 4083

ORA-02443: Cannot drop constraint - nonexistent constraint

1 19665

ORA-02444: Cannot resolve referenced object in referential constraints

1 4732

ORA-02445: Exceptions table not found

1 4404

ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

1 2897

ORA-02447: cannot defer a constraint that is not deferrable

1 7349

ORA-02448: constraint does not exist

1 4756

Un-Answered Questions { Database Errors }

How will you Handle Error in SQL SERVER 2008?

2401

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

2443

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

2410

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

3381

hp asking for replication floppy to do reinstall 25254 server assistant

2878

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

1962

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

2737

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

2647

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

2210

mount: mount to NFS server failed: System Error: Connection timed out

3664

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.

2868

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

3858

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

1956

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1675

what is new g/l functionality

2609

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