Database Errors Interview Questions
Questions Answers Views Company eMail

How to view the error log for any specific instance?

1948

When do you get "getwmicomexception"?

2268

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

CGI,

1 8329

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.

1087

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

1 731


Un-Answered Questions { Database Errors }

How will you Handle Error in SQL SERVER 2008?

1945


NZE-28868: Peer certificate chain check failed.

2267


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

1952


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

2862


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

2325






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

3298


ORA-26027: unique index string.string partition string initially in unusable state

6165


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.

1087


[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

2292


what is the instrument that used in Mechanical Energy??

2264


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

3562


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

3407


ORA-26095: unprocessed stream data exists

2810


ORA-16516: The current state is invalid for the attempted operation.

8075


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