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-02434: cannot enable unique(string) - unique key not defined for table

1 9001

ORA-02435: cannot disable unique(string) - unique key not defined for table

1 3462

ORA-02436: date or system variable wrongly specified in CHECK constraint

1 4800

ORA-02437: cannot validate (string.string) - primary key violated

1 8709

ORA-02438: Column check constraint cannot reference other columns

1 8101

ORA-02439: Unique index on a deferrable constraint is not allowed

1 3933

ORA-02440: Create as select with referential constraints not allowed

1 3289

ORA-02441: Cannot drop nonexistent primary key

1 13327

ORA-02442: Cannot drop nonexistent unique key

1 4226

ORA-02443: Cannot drop constraint - nonexistent constraint

1 19794

ORA-02444: Cannot resolve referenced object in referential constraints

1 4833

ORA-02445: Exceptions table not found

1 4507

ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated

1 2994

ORA-02447: cannot defer a constraint that is not deferrable

1 7446

ORA-02448: constraint does not exist

1 4839

Un-Answered Questions { Database Errors }

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

8880

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

2233

what is the instrument that used in Mechanical Energy??

2735

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

2715

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

2754

How to view the error log for any specific instance?

2542

ORA-16626: failed to enable specified object

2276

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2853

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

1668

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

3915

ORA-26084: direct path context already finished

1999

How will you Handle Error in SQL SERVER 2008?

2445

RMAN-05017: no copy of datafile number found to recover

2468

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

6793

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

3439

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