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-00106: cannot startup/shutdown database when connected to a dispatcher

1 4443

ORA-00107: failed to connect to ORACLE listener process

1 4461

ORA-00108: failed to set up dispatcher to accept connection asynchronously

1 7840

ORA-00109: invalid value for attribute string: string

1 4111

ORA-00110: invalid value string for attribute string, must be between string and string

1 3704

ORA-00111: invalid attribute string

1 4448

ORA-00112: value of string is null

1 3711

ORA-00113: protocol name string is too long

1 4222

ORA-00114: missing value for system parameter SERVICE_NAMES

1 3396

ORA-00115: connection refused; dispatcher connection table is full

1 3884

ORA-00116: SERVICE_NAMES name is too long

1 3668

ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified

1 3500

ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified

1 3429

ORA-00119: invalid specification for system parameter string

1 3831

ORA-00122: cannot initialize network configuration

1 3754

Un-Answered Questions { Database Errors }

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6719

write a database figure to implement the master detained relationship.

3012

How to view the error log for any specific instance?

2541

When do you get "getwmicomexception"?

2733

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.

2946

NZE-28868: Peer certificate chain check failed.

2865

ORA-26084: direct path context already finished

1999

what is new g/l functionality

2675

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

1734

what is the instrument that used in Mechanical Energy??

2735

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2577

IMP-00070: Lob definitions in dump file are inconsistent with database.

1801

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

2801

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

2517

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

2495

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