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-32584: missing LOG keyword

1 3274

ORA-32585: duplicate specification of a supplemental log attribute

1 2939

ORA-32586: multiple specification of a supplemental logging attribute

1 3016

ORA-32587: Cannot drop nonexistent string supplemental logging

1 5715

ORA-32588: supplemental logging attribute string exists

1 16848

ORA-32589: unable to drop minimal supplemental logging

1 5434

ORA-32590: log group specification not allowed here

1 2946

ORA-32591: connect string too long

1 2998

ORA-32592: all columns in log group can not be no log columns

1 2998

ORA-32593: database supplemental logging attributes in flux

1 8471

ORA-32600: RETENTION and PCTVERSION cannot be used together

1 2889

ORA-32601: value for retention cannot be provided

1 3103

ORA-32602: FREEPOOLS and FREELIST GROUPS cannot be used together

1 3318

ORA-32603: invalid FREEPOOLS LOB storage option value

1 4719

ORA-32604: invalid REBUILD option

1 3107

Un-Answered Questions { Database Errors }

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.

2889

ORA-26030: index string.string had string partitions made unusable due to:

1950

what is the instrument that used in Mechanical Energy??

2695

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2224

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

8834

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.

2550

ORA-26084: direct path context already finished

1959

write a database figure to implement the master detained relationship.

2955

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

2670

NZE-28890: Entrust Login Failed

1887

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

1694

How to view the error log for any specific instance?

2495

ORA-16626: failed to enable specified object

2231

ORA-26094: stream format error: input column overflow

2821

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.

1671

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