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-24149: invalid rule name

1 2711

ORA-24150: evaluation context string.string does not exist

1 5745

ORA-24151: no evaluation context is associated with rule string.string or rule set string.string

1 2942

ORA-24152: cannot drop evaluation context string.string with dependents

1 4386

ORA-24153: rule set string.string already exists

1 3820

ORA-24154: rule string.string already in rule set string.string

1 3150

ORA-24155: rule string.string not in rule set string.string

1 4030

ORA-24156: duplicate table alias string

1 3226

ORA-24157: duplicate variable name string

1 3360

ORA-24158: invalid table alias

1 3625

ORA-24159: invalid variable definiton

1 3274

ORA-24160: name string already exists in the name value pair list

1 3106

ORA-24161: name string does not exist in the name value pair list

1 3331

ORA-24162: name value pair list is full, cannot add another entry

1 3256

ORA-24163: dblink is not supported in rules engine DDLs

1 3197

Un-Answered Questions { Database Errors }

ORA-16516: The current state is invalid for the attempted operation.

8812

NZE-28868: Peer certificate chain check failed.

2797

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

2737

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.

2868

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

2426

what is the instrument that used in Mechanical Energy??

2677

IMP-00064: Definition of LOB was truncated by export

6411

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

6650

When do you get "getwmicomexception"?

2678

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

3857

ORA-26084: direct path context already finished

1945

ORA-26094: stream format error: input column overflow

2794

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

1672

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

3150

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

2218

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