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-31445: invalid lock handle while acquiring lock on string

1 2744

ORA-31446: this session does not own the lock handle for string

1 2733

ORA-31447: cannot create change tables in the SYS schema

1 3011

ORA-31448: invalid value for change_source

1 2836

ORA-31449: invalid value for change_set_name

1 3764

ORA-31450: invalid value for change_table_name

1 3067

ORA-31451: invalid value string for capture_values, expecting: OLD, NEW, or BOTH

1 2970

ORA-31452: invalid value string for parameter, expecting: Y or N

1 3210

ORA-31453: invalid value string for parameter, expecting: Y, N, or NULL

1 2735

ORA-31454: invalid value string for operation parameter, expecting: ADD or DROP

1 3106

ORA-31455: nothing to ALTER

1 3103

ORA-31456: error executing a procedure in the DBMS_CDC_UTILITY package

1 3734

ORA-31457: maximum length of description field exceeded

1 2849

ORA-31458: an internal error occurred

1 3048

ORA-31459: system triggers for DBMS_CDC_PUBLISH package are not installed

1 3439

Un-Answered Questions { Database Errors }

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

1630

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2534

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

1695

what is the instrument that used in Mechanical Energy??

2698

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

2450

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

1785

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

2619

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

2124

How will you Handle Error in SQL SERVER 2008?

2418

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

2720

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

1760

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

8835

ORA-26094: stream format error: input column overflow

2825

write a database figure to implement the master detained relationship.

2957

ORA-26027: unique index string.string partition string initially in unusable state

6758

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