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 4020

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

1 3328

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

1 3318

ORA-31096: validation failed for schema

1 4215

ORA-31097: Hierarchical Index not empty

1 2945

ORA-31099: XDB Security Internal Error

1 2807

ORA-31100: XDB Locking Internal Error

1 4254

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

1 2977

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

1 3210

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

1 3228

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

1 2609

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

1 2716

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

1 2801

ORA-31108: Action failed as resource string is locked

1 3219

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

1 2655

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1800

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

1982

ORA-26084: direct path context already finished

1960

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

2239

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

2752

hp asking for replication floppy to do reinstall 25254 server assistant

2904

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

3398

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

1629

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.

2890

IMP-00064: Definition of LOB was truncated by export

6431

ORA-16626: failed to enable specified object

2232

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

4006

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

1695

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

1951

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

3872

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