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 9338

ORA-22914: DROP of nested tables not supported

1 8717

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

1 4001

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

1 3814

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

1 6362

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

1 3190

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

1 3434

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

1 8136

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

1 4404

ORA-22922: nonexistent LOB value

1 9948

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

1 5940

ORA-22924: snapshot too old

1 5438

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

1 3930

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

1 6424

ORA-22927: invalid LOB locator specified

1 3391

Un-Answered Questions { Database Errors }

NZE-28890: Entrust Login Failed

1871

hp asking for replication floppy to do reinstall 25254 server assistant

2876

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

2692

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

What is the meaning of lock escalation and why/how to stop this?

2647

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

2633

When do you get "getwmicomexception"?

2678

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

3662

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

2727

ORA-26095: unprocessed stream data exists

3558

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2443

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

2425

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

2217

ORA-26084: direct path context already finished

1945

What is the use of NOLOCK locking hint?

1780

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