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-04093: references to columns of type LONG are not allowed in triggers

1 6003

ORA-04094: table string.string is constraining, trigger may not modify it

1 3388

ORA-04095: trigger 'string' already exists on another table, cannot replace it

1 8909

ORA-04096: trigger 'string' has a WHEN clause which is too large, limit 2K

1 4116

ORA-04097: DDL conflict while trying to drop or alter a trigger

1 5109

ORA-04098: trigger 'string.string' is invalid and failed re-validation

1 5926

ORA-04099: trigger 'string' is valid but not stored in compiled form

1 3299

ORA-24280: invalid input value for parameter string

1 3627

ORA-24281: invalid access past the maximum size of LOB parameter string

1 3168

ORA-24292: no more tables permitted in this sorted hash cluster

1 3292

ORA-24295: max key length (string) for sorted hash cluster exceeded

1 3269

ORA-24300: bad value for mode

1 6840

ORA-24301: null host specified in thread-safe logon

1 2928

ORA-24302: host connection in use by another thread

1 2929

ORA-24303: call not supported in non-deferred linkage

1 3028

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2546

[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

2779

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

2589

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3229

write a database figure to implement the master detained relationship.

3019

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

2716

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

2722

How will you Handle Error in SQL SERVER 2008?

2446

ORA-26094: stream format error: input column overflow

2859

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

3916

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.

1709

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

3440

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

1671

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

6794

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2868

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