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-12523: TNS:listener could not find instance appropriate for the client connection

1 14226

ORA-12524: TNS:listener could not resolve HANDLER_NAME given in connect descriptor

1 5835

ORA-12525: TNS:listener has not received client's request in time allowed

1 4152

ORA-12526: TNS:listener: all appropriate instances are in restricted mode

1 9283

ORA-12527: TNS:listener: all instances are in restricted mode or blocking new connections

1 3562

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

2 7924

ORA-12529: TNS:connect request rejected based on current filtering rules

1 10169

ORA-12531: TNS:cannot allocate memory

1 5097

ORA-12532: TNS:invalid argument

1 6748

ORA-12533: TNS:illegal ADDRESS parameters

1 6201

ORA-12534: TNS:operation not supported

1 7535

ORA-12535: TNS:operation timed out

1 3829

ORA-12536: TNS:operation would block

1 15626

ORA-12537: TNS:connection closed

State Bank Of India SBI,

2 11385

ORA-12538: TNS:no such protocol adapter

1 7450

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3064

NZE-28868: Peer certificate chain check failed.

2801

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

2410

How will you Handle Error in SQL SERVER 2008?

2401

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

2701

When do you get "getwmicomexception"?

2680

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3157

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

1967

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

2739

what is new g/l functionality

2611

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

1768

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

2223

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

1677

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1617

hp asking for replication floppy to do reinstall 25254 server assistant

2880

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