Database Errors Interview Questions
Questions Answers Views Company eMail

How to view the error log for any specific instance?

1946

When do you get "getwmicomexception"?

2267

Why we can't perform DML operations on Materialized views???

CGI,

1 8324

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

1237

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.

1086

I want query to find the students name who have second highest marks in a table

1 729


Un-Answered Questions { Database Errors }

What is the meaning of lock escalation and why/how to stop this?

2165


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

3403


How to view the error log for any specific instance?

1946


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

1754


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

2234






ORA-26029: index string.string partition string initially in unusable state

1715


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

2022


ORA-26095: unprocessed stream data exists

2805


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

1237


write a database figure to implement the master detained relationship.

2434


IMG-02003: 2FF03 - incorrect color histogram feature specification

1203


hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2170


NZE-28868: Peer certificate chain check failed.

2265


ORA-26084: direct path context already finished

1487


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

2180