Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

PLS-00118: Duplicate group-by clause in table expression

1 2815

PLS-00119: Duplicate having-clause in table expression

1 3623

PLS-00120: inappropriate argument in OPEN statement

1 3504

PLS-00122: %s as separator is allowed only with specific built-in functions

1 5458

PLS-00123: program too large

1 4266

PLS-00124: name of exception expected for first arg in exception_init pragma

1 3608

PLS-00125: type name expected

1 3837

PLS-00126: selector ALL is not allowed

1 3583

PLS-00127: Pragma string is not a supported pragma

1 6203

PLS-00128: Illegal number of arguments for pragma string

1 3211

PLS-00129: Pragma INTERFACE only supports C as its first argument

1 3996

PLS-00130: Pragma string expects 1st argument to be a procedure/function/package/cursor

1 3378

PLS-00131: Pragma string expects 2nd argument to be a procedure

1 2864

PLS-00132: Pragma RESTRICT_REFERENCES does not support string

1 2755

PLS-00133: Pragma string expects 1st argument to be an identifier or string-literal

1 3784

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3127

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

2300

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2785

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

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

2496

what is new g/l functionality

2675

ORA-26095: unprocessed stream data exists

3642

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

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

3227

what is the instrument that used in Mechanical Energy??

2735

ORA-26032: index string.string loading aborted after string keys

2180

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2700

How to view the error log for any specific instance?

2542

hp asking for replication floppy to do reinstall 25254 server assistant

2964

ORA-26029: index string.string partition string initially in unusable state

2234

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