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-28503: bind value cannot be translated into SQL text for non-Oracle system

1 3063

ORA-28504: ROWID not found in ROWID cache for heterogeneous database link

1 3209

ORA-28505: cannot get non-Oracle system capabilities from string

1 3093

ORA-28506: parse error in data dictionary translation for string stored in string

1 4311

ORA-28507: error in data dictionary view string

1 3438

ORA-28508: invalid value string for Heterogeneous Services initialization parameter string

1 4437

ORA-28509: unable to establish a connection to non-Oracle system

1 4494

ORA-28510: heterogeneous database link initialization failed

1 5352

ORA-28511: lost RPC connection to heterogeneous remote agent using SID=string

1 6441

ORA-28512: cannot get data dictionary translations from string

1 2957

ORA-28513: internal error in heterogeneous remote agent

1 15019

ORA-28514: heterogeneous database link initialization could not convert system date

1 3656

ORA-28515: cannot get external object definitions from string

1 2857

ORA-28518: data dictionary translation has illegal translation type

1 2826

ORA-28519: no heterogeneous data dictionary translations available

1 3446

Un-Answered Questions { Database Errors }

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

2743

IMG-02003: 2FF03 - incorrect color histogram feature specification

1716

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.

2877

How to view the error log for any specific instance?

2490

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

1962

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

2812

why we are using shift key in unix shell script

3180

NZE-28890: Entrust Login Failed

1887

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1664

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

1755

What is Mutex error in Triggers?

3079

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2249

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

6665

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

2461

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

2808

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