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

Database Errors Interview Questions

Questions Answers Views Company eMail

O2F-00326: Some characters in this name were not legal identifier characters

1 2852

O2F-00327: CASE option has an illegal value

1 2884

O2F-00328: Illegal INITFUNC name

1 3006

O2F-00329: Type or option specification expected

1 2896

O2F-00330: Name exceeds 265 bytes in length

1 2848

O2F-00331: A syntactically illegal name was seen in the INTYPE file

1 2606

O2F-00332: A database link may not appear in the name of a user-defined type

1 2755

O2F-00333: An unexpected token appeared where a keyword was expected in the INTYPE file

1 2590

O2F-00334: A user-defined type is listed more than once in the INTYPE file

1 2939

O2F-00335: Internal error in O2F component of OTT

1 2924

O2F-00336: Error reported by subsystem:

1 2732

O2F-00337: Schema not found, or no types found in schema

1 2975

O2F-00338: Illegal or missing package name

1 2951

O2F-00339: CODE option has an illegal value

1 2897

O2F-00340: Name was null

1 3098

Un-Answered Questions { Database Errors }

What is Mutex error in Triggers?

3069

ORA-26094: stream format error: input column overflow

2808

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

mount: mount to NFS server failed: System Error: Connection timed out

3668

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2803

When do you get "getwmicomexception"?

2682

How to view the error log for any specific instance?

2486

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

3863

what is new g/l functionality

2612

What is the use of NOLOCK locking hint?

1788

write a database figure to implement the master detained relationship.

2936

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

2434

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

3169

What is SCD (Slowly Changing Dimensions)? What are its types?

2665

what is the instrument that used in Mechanical Energy??

2682

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