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-14253: table is not partitioned by Composite Range method

1 9233

ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table

1 4240

ORA-14255: table is not partitioned by Range, Composite Range or List method

1 7471

ORA-14256: invalid resulting partition description(s)

1 4022

ORA-14257: cannot move partition other than a Range or Hash partition

1 6743

ORA-14258: invalid partition description

1 4322

ORA-14259: table is not partitioned by Hash method

1 3587

ORA-14260: incorrect physical attribute specified for this partition

1 5952

ORA-14261: partition bound may not be specified when adding this Hash partition

1 5946

ORA-14262: new subpartition name must differ from the old subpartition name

1 3383

ORA-14263: new subpartition name must differ from that of any other subpartition of the object

1 3595

ORA-14264: table is not partitioned by Composite Range method

1 5916

ORA-14265: data type or length of a table subpartitioning column may not be changed

1 4976

ORA-14266: data type or length of an index subpartitioning column may not be changed

1 3178

ORA-14267: cannot specify PARALLEL clause when adding a (Composite) Range partition

1 3427

Un-Answered Questions { Database Errors }

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

3867

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

2523

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.

2874

NZE-28890: Entrust Login Failed

1885

ORA-26095: unprocessed stream data exists

3586

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

6752

ORA-16626: failed to enable specified object

2225

[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

2733

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

2650

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

1714

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.

1660

ORA-26079: file "string" is not part of table string.string

1960

write a database figure to implement the master detained relationship.

2940

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

2670

hp asking for replication floppy to do reinstall 25254 server assistant

2890

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