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-22913: must specify table name for nested table column or attribute

ABC,

1 9448

ORA-22914: DROP of nested tables not supported

1 8827

ORA-22915: cannot ALTER a nested table's storage table to ADD/MODIFY columns

1 4055

ORA-22916: cannot do an exact FETCH on a query with Nested cursors

1 3881

ORA-22917: use VARRAY to define the storage clause for this column or attribute

1 6454

ORA-22918: specified column or attribute is not a VARRAY type

1 3272

ORA-22919: dangling REF error or lock object failed for no wait request

1 3545

ORA-22920: row containing the LOB value is not locked

1 8264

ORA-22921: length of input buffer is smaller than amount requested

1 4478

ORA-22922: nonexistent LOB value

1 10027

ORA-22923: amount of data specified in streaming LOB write is 0

1 6038

ORA-22924: snapshot too old

1 5516

ORA-22925: operation would exceed maximum size allowed for a LOB value

1 4007

ORA-22926: specified trim length is greater than current LOB value's length

1 6495

ORA-22927: invalid LOB locator specified

1 3464

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

2798

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

2855

ORA-16626: failed to enable specified object

2272

mount: mount to NFS server failed: System Error: Connection timed out

3703

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

1813

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

2495

What is Mutex error in Triggers?

3117

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.

2945

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

2226

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

2695

How to view the error log for any specific instance?

2531

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

2857

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

2264

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

1664

NZE-28868: Peer certificate chain check failed.

2861

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