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-24410: scrollable cursor max size exceeded

1 3380

ORA-24411: Session pool already exists.

1 3316

ORA-24412: Cannot reinitialize non-existent pool

1 3331

ORA-24413: Invalid number of sessions specified

1 5857

ORA-24414: Only number sessions could be started.

1 3038

ORA-24415: Missing or null username.

1 8515

ORA-24416: Invalid session Poolname was specified.

1 6855

ORA-24417: Session pool size has exceeded the maximum limit

1 3719

ORA-24418: Cannot open further sessions.

1 4660

ORA-24419: Proxy sessions are not supported in this mode.

1 3325

ORA-24420: OCISessionRelease must be used to release this session.

1 3366

ORA-24421: OCISessionRelease cannot be used to release this session.

1 3436

ORA-24422: error occurred while trying to destroy the Session Pool

1 4978

ORA-24430: Null values for sqltext and key were specified.

1 3432

ORA-24431: Statement does not exist in the cache

1 3891

Un-Answered Questions { Database Errors }

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

2236

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

2181

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

2588

What severity level errors are managed in TRY-CATCH block?

2269

ORA-16626: failed to enable specified object

2278

How to view the error log for any specific instance?

2546

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

2759

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2767

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

2502

[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

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2948

hp asking for replication floppy to do reinstall 25254 server assistant

2968

ORA-26084: direct path context already finished

2000

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

1801

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

1671

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