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-25207: enqueue failed, queue string.string is disabled from enqueueing

1 9041

ORA-25208: RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE

1 3057

ORA-25209: invalid value string, EXPIRATION should be non-negative or NEVER

1 3283

ORA-25210: invalid value for RELATIVE_MSGID, no message in queue with that msgid

1 2995

ORA-25211: invalid DELAY specified when using sequence deviation

1 3229

ORA-25212: invalid PRIORITY specified when using sequence deviation

1 3367

ORA-25213: message with specified RELATIVE_MSGID has been dequeued

1 2953

ORA-25214: cannot specify delay or expiration for enqueue to exception queue

1 3251

ORA-25215: user_data type and queue type do not match

WalMart,

1 8094

ORA-25216: invalid recipient, either NAME or ADDRESS must be specified

1 3960

ORA-25217: enqueue failed, visibility must be IMMEDIATE for queue string.string

1 3306

ORA-25218: enqueue failed, delay must be zero for queue string.string

1 2869

ORA-25219: enqueue failed, sequence deviation not allowed for queue string.string

1 3071

ORA-25220: enqueue failed, signature not specified for a non-repudiable queue

1 3090

ORA-25221: enqueue failed, signature specified queue not supporting non-repudiation

1 3274

Un-Answered Questions { Database Errors }

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

2432

[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

2723

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

3862

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

2223

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

1768

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

2520

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

2410

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

1743

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1677

ORA-26095: unprocessed stream data exists

3562

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

2155

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.

2870

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

2732

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2800

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

3384

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