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-25192: invalid option for an index-organized table

1 3455

ORA-25193: cannot use COMPRESS option for a single column key

1 12147

ORA-25194: invalid COMPRESS prefix length value

1 8642

ORA-25195: invalid option for index on an index-organized table

1 3144

ORA-25196: keyword MOVE in ALTER TABLE MOVE must immediately follow

1 2925

ORA-25197: an overflow segment already exists for the indexed-organized table

1 3611

ORA-25198: only range, list, and hash partitioning are supported for index-organized table

1 4141

ORA-25199: partitioning key of a index-organized table must be a subset of the primary key

1 4476

ORA-25200: invalid value string, QUEUE_NAME should be [SCHEMA.]NAME

1 5608

ORA-25201: invalid value, VISIBILITY should be ON_COMMIT or IMMEDIATE

1 3297

ORA-25202: invalid value NULL, string should be non-NULL

1 3881

ORA-25203: invalid value string, DELAY should be non-negative

1 3596

ORA-25204: invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP

1 2797

ORA-25205: the QUEUE string.string does not exist

1 10065

ORA-25206: enqueue failed, enqueue to exception queue string.string not permitted

1 4641

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2548

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

2678

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

1777

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

3234

ORA-16626: failed to enable specified object

2282

What is the use of NOLOCK locking hint?

1837

NZE-28890: Entrust Login Failed

1943

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

2868

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1710

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

1830

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

2193

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

2870

RMAN-05017: no copy of datafile number found to recover

2476

hp asking for replication floppy to do reinstall 25254 server assistant

2973

what is the instrument that used in Mechanical Energy??

2754

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