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-23318: a ddl failure has occurred

1 3785

ORA-23319: parameter value string is not appropriate

1 9278

ORA-23320: the request failed because of values string and string

1 5259

ORA-23321: Pipename may not be null

1 4095

ORA-23322: Privilege error accessing pipe

1 4583

ORA-23323: parameter length exceeds deferred RPC limits

1 3278

ORA-23324: error string, while creating deferror entry at "string" with error string

1 3903

ORA-23325: parameter type is not string

1 3124

ORA-23326: object group "string"."string" is quiesced

1 6114

ORA-23327: imported deferred rpc data does not match string of importing db

1 5062

ORA-23328: mview base table "string"."string" differs from master table "string"."string"

1 3604

ORA-23329: successful user-provided ddl but no materialized view "string"."string"

1 2917

ORA-23330: column group string already exists

1 2914

ORA-23331: column group string does not exist

1 2904

ORA-23332: group string is in use; cannot drop

1 3127

Un-Answered Questions { Database Errors }

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

2107

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 ??

1681

what is the instrument that used in Mechanical Energy??

2682

ORA-16516: The current state is invalid for the attempted operation.

8820

ORA-26079: file "string" is not part of table string.string

1958

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

2434

IMG-02003: 2FF03 - incorrect color histogram feature specification

1710

What is the use of NOLOCK locking hint?

1788

ORA-26084: direct path context already finished

1949

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

2522

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

3169

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2454

When do you get "getwmicomexception"?

2682

why we are using shift key in unix shell script

3167

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

6746

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