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-30941: Cannot specify empty URI for non-default namespace 'string'

1 3386

ORA-30942: XML Schema Evolution error for schema 'string' table string column 'string'

1 3319

ORA-30943: XML Schema 'string' is dependent on XML schema 'string'

1 2704

ORA-30944: Error during rollback for XML schema 'string' table string column 'string'

1 3105

ORA-30945: Could not create mapping table 'string'

1 2627

ORA-30946: XML Schema Evolution warning: temporary tables not cleaned up

1 2978

ORA-30951: Element or attribute at Xpath string exceeds maximum length

1 4866

ORA-30990: insufficient privileges to change owner of resource string

1 2799

ORA-30991: cannot use DOM to add special attribute to schema-based parent

1 5920

ORA-31000: Resource 'string' is not an XDB schema document

1 15410

ORA-31001: Invalid resource handle or path name "string"

1 11229

ORA-31002: Path name string is not a container

1 3383

ORA-31003: Parent string already contains child entry string

1 6762

ORA-31004: Length string of the BLOB in XDB$H_INDEX is below the minimum string

1 3359

ORA-31005: Path name length string exceeds maximum length string

1 3294

Un-Answered Questions { Database Errors }

ORA-26028: index string.string initially in unusable state

3875

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

8835

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

2534

hp asking for replication floppy to do reinstall 25254 server assistant

2904

How will you Handle Error in SQL SERVER 2008?

2418

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2226

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2738

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

2812

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

2720

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2735

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

2619

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.

2890

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

2661

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

2124

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

1785

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