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-31093: null or invalid value specified for parameter : string

1 4024

ORA-31094: incompatible SQL type "string" for attribute or element "string"

1 3329

ORA-31095: cannot generate string : "string.string" already exists

1 3320

ORA-31096: validation failed for schema

1 4216

ORA-31097: Hierarchical Index not empty

1 2947

ORA-31099: XDB Security Internal Error

1 2808

ORA-31100: XDB Locking Internal Error

1 4255

ORA-31101: Token "string" not given while locking resource "string"

1 2979

ORA-31102: Already locked in exclusive mode. Cannot add lock.

1 3212

ORA-31103: Resource locked in shared mode. Cannot add exclusive lock

1 3230

ORA-31104: Cannot find lock with token "string" on "string" for unlock

1 2612

ORA-31105: User does not own lock "string"

1 2717

ORA-31107: Action failed as resource "string" is locked by name lock

1 2801

ORA-31108: Action failed as resource string is locked

1 3221

ORA-31109: Action failed as parent resource string is locked

1 2657

Un-Answered Questions { Database Errors }

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

6758

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

2451

ORA-16626: failed to enable specified object

2232

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

1984

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.

2820

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

2682

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

2125

ORA-26084: direct path context already finished

1960

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2753

How to view the error log for any specific instance?

2496

NZE-28868: Peer certificate chain check failed.

2824

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

2167

[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

2738

ORA-26095: unprocessed stream data exists

3594

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

4007

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