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-02254: DEFAULT not allowed here

1 3564

ORA-02255: obsolete 7.1.5

1 2856

ORA-02256: number of referencing columns must match referenced columns

1 5254

ORA-02257: maximum number of columns exceeded

1 8857

ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications

1 5974

ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications

1 7150

ORA-02260: table can have only one primary key

1 7849

ORA-02261: such unique or primary key already exists in the table

1 10949

ORA-02262: ORA-string occurs while type-checking column default value expression

1 15323

ORA-02263: need to specify the datatype for this column

1 22770

ORA-02264: name already used by an existing constraint

1 9642

ORA-02265: cannot derive the datatype of the referencing column

1 3028

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

1 4043

ORA-02267: column type incompatible with referenced column type

1 16543

ORA-02268: referenced table does not have a primary key

1 8222

Un-Answered Questions { Database Errors }

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

3381

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

2225

ORA-26084: direct path context already finished

1946

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

2410

What is the use of NOLOCK locking hint?

1780

ORA-26032: index string.string loading aborted after string keys

2103

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.

2530

why we are using shift key in unix shell script

3158

IMP-00070: Lob definitions in dump file are inconsistent with database.

1741

ORA-26082: load of overlapping segments on table string.string is not allowed

1766

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

1937

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

3984

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.

2795

NZE-28868: Peer certificate chain check failed.

2797

what is new g/l functionality

2609

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