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-24902: invalid subscription name or name-length in subscription handle

1 3267

ORA-24903: invalid namespace attribute passed into OCI call

1 2955

ORA-24904: invalid callback attribute passed into OCI call

1 3029

ORA-24905: invalid recepient protocol attribute passed into OCI call

1 3198

ORA-24906: invalid recepient attribute passed into OCI call

1 3167

ORA-24907: invalid pair of callback and recepient protocol attributes

1 2641

ORA-24908: invalid recipient presentation attribute

1 3209

ORA-24909: call in progress. Current operation cancelled

1 7783

ORA-24950: unregister failed, registeration not found

1 5525

ORA-24960: the attribute string is greater than the maximum allowable length of number

1 9256

ORA-25000: invalid use of bind variable in trigger WHEN clause

1 6208

ORA-25001: cannot create this trigger type on views

1 7970

ORA-25002: cannot create INSTEAD OF triggers on tables

1 7340

ORA-25003: cannot change NEW values for this column type in trigger

1 3216

ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers

1 3312

Un-Answered Questions { Database Errors }

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

2701

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

2269

what is new g/l functionality

2681

ORA-26082: load of overlapping segments on table string.string is not allowed

1823

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2948

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

6722

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

2523

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

3916

ORA-16627: No standby databases support the overall protection mode.

4042

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.

1709

ORA-26095: unprocessed stream data exists

3642

NZE-28868: Peer certificate chain check failed.

2868

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.

2856

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

1736

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2868

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