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-13220: failed to compare tile with the geometry

1 3419

ORA-13221: unknown geometry type in the geometry object

1 3326

ORA-13222: failed to compute supercell for geometry in string

1 2828

ORA-13223: duplicate entry for string in SDO_GEOM_METADATA

Oracle,

1 7101

ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

1 5347

ORA-13225: specified index table name is too long for a spatial index

1 2928

ORA-13226: interface not supported without a spatial index

2 7477

ORA-13227: SDO_LEVEL values for the two index tables do not match

1 3087

ORA-13228: spatial index create failed due to invalid type

1 3528

ORA-13230: failed to create temporary table [string] during R-tree creation

1 3815

ORA-13231: failed to create index table [string] during R-tree creation

1 3320

ORA-13232: failed to allocate memory during R-tree creation

1 3114

ORA-13233: failed to create sequence number [string] for R-tree

1 3559

ORA-13234: failed to access R-tree-index table [string]

1 7997

ORA-13236: internal error in R-tree processing: [string]

1 8600

Un-Answered Questions { Database Errors }

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

2246

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

1675

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

2524

ORA-26094: stream format error: input column overflow

2859

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2861

ORA-16627: No standby databases support the overall protection mode.

4045

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

2808

How to view the error log for any specific instance?

2548

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3448

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

2590

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

6805

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

8891

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

2868

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

1777

what is new g/l functionality

2683

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