Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

O2U-00202: Invalid data passed to function

1 3216

O2U-00203: Type to be declared must be an object type or a named collection type

1 2888

O2U-00204: Unable to convert from the database character set to the compiler character set

1 2697

O2U-00205: None of the characters in a type name were legal identifier characters

1 2889

O2U-00206: Some characters in a type name were not legal identifier characters

1 2898

O2U-00207: None of the characters in an attribute name were legal identifier characters

1 2856

O2U-00208: One or more characters in an attribute name were not legal identifier characters

1 3011

O2U-00209: Attribute or function name to be translated was not found

1 2799

O2U-00210: Unable to allocate memory

1 3068

O2U-00211: A type without attributes was translated

1 2701

O2U-00212: An error occurred for which no message is available

1 2787

ORA-33000: (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.

1 2834

ORA-33002: (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.

1 2953

ORA-33003: (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.

1 3048

ORA-33004: (XSAGDNGL01) workspace object is not a relationship array.

1 2910

Un-Answered Questions { Database Errors }

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

2264

ORA-26084: direct path context already finished

1994

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

1727

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

1986

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2694

What is the use of NOLOCK locking hint?

1829

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

3219

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

1658

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.

2570

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

3906

write a database figure to implement the master detained relationship.

3007

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

2777

ORA-26095: unprocessed stream data exists

3633

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

2494

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1695

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