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-26091: requested direct path operation not supported

1 2758

ORA-26092: only LONG or LOB types can be partial

1 2866

ORA-26093: input data column size (number) exceeds the maximum input size (number)

1 12045

ORA-26094: stream format error: input column overflow

HP,

2801

ORA-26095: unprocessed stream data exists

3568

ORA-26096: transfer size too small for row data (number bytes required)

1 3433

ORA-26097: unsupported conversion for column string (from type number to type number)

1 10135

ORA-26098: direct path context is not prepared

IBM,

1 4478

ORA-26099: direct path context is already prepared

1 2954

ORA-26101: tablespace # in file header is string rather than string for file string

1 2910

ORA-26102: relative file # in file header is string rather than string for file string

1 3981

ORA-26103: V6 or V7 data file used to create control file

1 2728

ORA-26500: error on caching "string"."string"

1 4234

ORA-26501: RepAPI operation failure

1 2932

ORA-26502: error resignal

1 4075

Un-Answered Questions { Database Errors }

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

3862

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

2733

IMP-00064: Definition of LOB was truncated by export

6415

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2721

NZE-28868: Peer certificate chain check failed.

2801

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

2641

ORA-26095: unprocessed stream data exists

3568

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

1679

what is the instrument that used in Mechanical Energy??

2680

What is the use of NOLOCK locking hint?

1786

IMP-00070: Lob definitions in dump file are inconsistent with database.

1743

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.

1651

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.

2802

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

2223

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6652

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