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-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

1 3322

ORA-24049: invalid agent name string, names with AQ$_ prefix are not valid

1 3516

ORA-24050: subscribers are not supported for exception queue string

1 3099

ORA-24051: cannot propagate object type payloads that have a REF attribute

1 2999

ORA-24052: cannot propagate object type payloads with LOB attributes to an 8.0 release

1 2954

ORA-24053: PRIMARY_INSTANCE and SECONDARY_INSTANCE must be non-negative

1 3344

ORA-24054: cannot propagate to an Oracle 8.0.3 release or lower release

1 3003

ORA-24055: cannot delete propagation status rows that are in prepared state

1 3084

ORA-24056: internal inconsistency for QUEUE string and destination string

1 4083

ORA-24057: cannot define subscriber with rule for queue string

1 3466

ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

1 3601

ORA-24059: invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string

1 3137

ORA-24060: cannot convert QUEUE_TABLE, string already is compatible with release string

1 3180

ORA-24061: cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_INSTANCE was zero

1 3050

ORA-24062: Subscriber table string inconsistent with queue table string

1 3855

Un-Answered Questions { Database Errors }

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

2264

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

1728

ORA-16626: failed to enable specified object

2272

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

1796

What is the use of NOLOCK locking hint?

1831

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.

1696

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

2782

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2751

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.

2849

ORA-26095: unprocessed stream data exists

3636

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?

2760

When do you get "getwmicomexception"?

2731

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

2517

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.

2945

why we are using shift key in unix shell script

3227

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