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-08462: raw buffer contains invalid decimal data

1 2650

ORA-08463: overflow converting decimal number to Oracle number

1 3155

ORA-08464: input raw decimal data contains more than 42 digits

1 2740

ORA-08465: input mask contains more than 32 characters

1 2769

ORA-08466: raw buffer length string is too short for string

1 2945

ORA-08467: error converting Oracle number to string

1 2969

ORA-08468: mask option string is not supported

1 3054

ORA-08498: Warning: picture mask 'string' overrides picture mask option 'USAGE IS string' to 'USAGE IS DISPLAY'

1 2626

ORA-08499: Warning: picture mask options 'string' ignored by UTL_PG

1 3102

ORA-09200: sfccf: error creating file

1 2932

ORA-09201: sfcopy: error copying file

1 2807

ORA-09202: sfifi: error identifying file

1 3375

ORA-09203: sfofi: error opening file

1 3440

ORA-09204: sfotf: error opening temporary file

1 3237

ORA-09205: sfqio: error reading or writing to disk

1 3098

Un-Answered Questions { Database Errors }

ORA-26079: file "string" is not part of table string.string

1956

what is the instrument that used in Mechanical Energy??

2679

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

6650

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.

2798

hp asking for replication floppy to do reinstall 25254 server assistant

2878

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

1742

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2719

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

3665

How to view the error log for any specific instance?

2480

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

2443

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.

1647

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

2430

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

1676

ORA-26032: index string.string loading aborted after string keys

2104

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2225

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