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-30002: SYS_CONNECT_BY_PATH function is not allowed here

1 7654

ORA-30005: missing or invalid WAIT interval

1 7609

ORA-30006: resource busy; acquire with WAIT timeout expired

1 18552

ORA-30011: Error simulated: psite=string, ptype=string

1 3590

ORA-30012: undo tablespace 'string' does not exist or of wrong type

1 5133

ORA-30013: undo tablespace 'string' is currently in use

1 6132

ORA-30014: operation only supported in Automatic Undo Management mode

1 8277

ORA-30015: previously offlined undo tablespace 'string' is still pending

1 4144

ORA-30016: undo tablespace 'string' is already in use by this instance

1 3198

ORA-30017: segment 'string' is not supported in string Undo Management mode

1 4833

ORA-30018: Create Rollback Segment failed, USN string is out of range

1 3169

ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

1 6100

ORA-30020: UNDO_MANAGEMENT=AUTO needs Compatibility string or greater

1 3496

ORA-30021: Operation not allowed on undo tablespace

1 6657

ORA-30022: Cannot create segments in undo tablespace

2 9074

Un-Answered Questions { Database Errors }

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

2260

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

1725

What is the use of NOLOCK locking hint?

1800

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

2754

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

1962

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

3184

NZE-28890: Entrust Login Failed

1887

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

hp asking for replication floppy to do reinstall 25254 server assistant

2904

ORA-26076: cannot set or reset value after direct path structure is allocated

1981

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

2752

ORA-26094: stream format error: input column overflow

2825

ORA-26084: direct path context already finished

1960

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

2447

How to view the error log for any specific instance?

2496

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