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-14268: subpartition 'string' of the partition resides in offlined tablespace

1 2961

ORA-14269: cannot exchange partition other than a Range or Hash partition

1 3042

ORA-14270: table is not partitioned by Range or Hash or List method

1 3148

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

1 3616

ORA-14272: only a partition with higher bound can be reused

1 2970

ORA-14273: lower-bound partition must be specified first

1 4131

ORA-14274: partitions being merged are not adjacent

1 7471

ORA-14275: cannot reuse lower-bound partition as resulting partition

1 4028

ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table

1 3268

ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns

1 4516

ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION

1 5632

ORA-14279: index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION

2 5551

ORA-14280: all rows in table do not qualify for specified subpartition

1 4375

ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 4077

ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 3184

Un-Answered Questions { Database Errors }

[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

ORA-26030: index string.string had string partitions made unusable due to:

1943

ORA-16626: failed to enable specified object

2225

What is the meaning of lock escalation and why/how to stop this?

2658

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

What is Mutex error in Triggers?

3076

write a database figure to implement the master detained relationship.

2940

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

2810

What is the use of NOLOCK locking hint?

1788

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.

2540

How will you Handle Error in SQL SERVER 2008?

2407

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

6752

ORA-26076: cannot set or reset value after direct path structure is allocated

1973

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

1960

why we are using shift key in unix shell script

3175

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