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-13190: recursive SQL fetch failed

1 3080

ORA-13191: failed to read SDO_ORDCNT value

1 3415

ORA-13192: failed to read number of element rows

1 3358

ORA-13193: failed to allocate space for geometry

1 3208

ORA-13194: failed to decode supercell

1 3289

ORA-13195: failed to generate maximum tile value

1 3013

ORA-13196: failed to compute supercell for element string.string.string

1 3037

ORA-13197: element string.string.string is out of range

1 3289

ORA-13198: Spatial error: string

1 3479

ORA-13199: %s

1 3574

ORA-13200: internal error [string] in spatial indexing.

1 5944

ORA-13201: invalid parameters supplied in CREATE INDEX statement

1 3147

ORA-13202: failed to create or insert into the SDO_INDEX_METADATA table

1 4004

ORA-13203: failed to read USER_SDO_GEOM_METADATA view

1 6263

ORA-13204: failed to create spatial index table

1 3383

Un-Answered Questions { Database Errors }

ORA-26094: stream format error: input column overflow

2859

How to view the error log for any specific instance?

2548

When do you get "getwmicomexception"?

2737

ORA-26084: direct path context already finished

2005

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

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

1830

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

3924

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

2506

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

2764

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

2524

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

2271

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

1740

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

1675

NZE-28890: Entrust Login Failed

1943

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

2476

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