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-24902: invalid subscription name or name-length in subscription handle

1 3270

ORA-24903: invalid namespace attribute passed into OCI call

1 2955

ORA-24904: invalid callback attribute passed into OCI call

1 3029

ORA-24905: invalid recepient protocol attribute passed into OCI call

1 3201

ORA-24906: invalid recepient attribute passed into OCI call

1 3170

ORA-24907: invalid pair of callback and recepient protocol attributes

1 2642

ORA-24908: invalid recipient presentation attribute

1 3214

ORA-24909: call in progress. Current operation cancelled

1 7786

ORA-24950: unregister failed, registeration not found

1 5526

ORA-24960: the attribute string is greater than the maximum allowable length of number

1 9257

ORA-25000: invalid use of bind variable in trigger WHEN clause

1 6210

ORA-25001: cannot create this trigger type on views

1 7976

ORA-25002: cannot create INSTEAD OF triggers on tables

1 7340

ORA-25003: cannot change NEW values for this column type in trigger

1 3216

ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers

1 3312

Un-Answered Questions { Database Errors }

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

2502

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2779

How will you Handle Error in SQL SERVER 2008?

2447

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2869

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

3916

ORA-26094: stream format error: input column overflow

2859

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

2868

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

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

2716

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

3716

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

2524

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

2804

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

2270

what is new g/l functionality

2681

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

1737

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