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-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.

1 2677

ORA-36641: (XSDUNION20) The concat dimension must be defined as UNIQUE because base dimension workspace object contains custom member values.

1 2594

ORA-36642: (XSDUNION06) Concat dimension list contains duplicate leaf dimension workspace object.

1 2791

ORA-36643: (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.

1 3129

ORA-36644: (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.

1 2738

ORA-36646: (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.

1 2625

ORA-36648: (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.

1 2804

ORA-36650: (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.

1 2735

ORA-36652: (XSDUNION11) workspace object is not a string type dimension.

1 2561

ORA-36664: (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.

1 2746

ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.

1 2880

ORA-36666: (XSDPART04) workspace object is not a concat dimension.

1 2818

ORA-36667: (XSDPART05) string is not a legal CONCAT partition.

1 2661

ORA-36668: (XSDPART06) string is not a legal RANGE partition.

1 2847

ORA-36669: (XSDPART07) string is not a legal LIST partition.

1 2864

Un-Answered Questions { Database Errors }

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

1710

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2539

[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

2731

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.

1652

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

6746

What is SCD (Slowly Changing Dimensions)? What are its types?

2665

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

2805

What is Mutex error in Triggers?

3069

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?

2723

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

2522

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

2155

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

2733

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

2212

ORA-26095: unprocessed stream data exists

3573

IMP-00070: Lob definitions in dump file are inconsistent with database.

1747

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