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 5913

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

1 3298

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

1 8810

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

1 4022

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

1 4969

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

1 5841

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

1 3192

ORA-24280: invalid input value for parameter string

1 3516

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

1 3074

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

1 3198

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

1 3197

ORA-24300: bad value for mode

1 6757

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

1 2843

ORA-24302: host connection in use by another thread

1 2838

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

1 2912

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1784

hp asking for replication floppy to do reinstall 25254 server assistant

2879

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.

2799

When do you get "getwmicomexception"?

2679

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

2696

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

3154

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

2410

What is live lock, deadlock and what is Lock escalation?

2432

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.

2532

IMP-00064: Definition of LOB was truncated by export

6413

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2228

[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

2722

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

3383

ORA-26095: unprocessed stream data exists

3561

ORA-16627: No standby databases support the overall protection mode.

3988

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