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-34260: (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite's bases instead.

1 3061

ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.

1 3040

ORA-34279: (MXDCL37) CONCAT can only be used when defining a DIMENSION.

1 3034

ORA-34286: (MXDCL53) workspace object cannot be used in this context because it is a string.

1 2646

ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).

1 2914

ORA-34342: (MXDSS01) IMPORTANT: Analytic workspace string is read-only. Therefore, you will not be able to use the UPDATE command to save changes to it.

1 2768

ORA-34344: (MXDSS03) Analytic workspace string is not attached.

1 3505

ORA-34346: (MXDSS04) The string analytic workspace cannot be detached.

1 2950

ORA-34348: (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.

1 3248

ORA-34350: (MXDSS06) string is an open analytic workspace.

1 3941

ORA-34357: (MXDSS10) string is not an alias of analytic workspace string.

1 2883

ORA-34358: (MXDSS14) number other users reading

1 2907

ORA-34359: (MXDSS11) string appears twice in the alias list.

1 3234

ORA-34360: (MXDSS15) number other users writing

1 2829

ORA-34361: (MXDSS12) number other user reading

1 2860

Un-Answered Questions { Database Errors }

How will you Handle Error in SQL SERVER 2008?

2403

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

1710

what is new g/l functionality

2611

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

1680

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

2705

How to view the error log for any specific instance?

2486

ORA-26094: stream format error: input column overflow

2808

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2539

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

2453

write a database figure to implement the master detained relationship.

2936

ORA-26084: direct path context already finished

1949

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

2225

ORA-16626: failed to enable specified object

2218

What is Mutex error in Triggers?

3069

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

2155

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