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-19777: ASM file string cannot be proxy backed up.

1 3514

ORA-19800: Unable to initialize Oracle Managed Destination

1 8952

ORA-19801: initialization parameter DB_RECOVERY_FILE_DEST is not set

1 4751

ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

1 6094

ORA-19803: Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)

1 8214

ORA-19804: cannot reclaim string bytes disk space from string limit

1 6393

ORA-19805: recid string of string is about to be deleted or resized

1 3446

ORA-19806: cannot make duplex backups in recovery area

2 12870

ORA-19808: recovery destination parameter mismatch

1 5889

ORA-19809: limit exceeded for recovery files

1 3831

ORA-19810: Cannot create temporary controlfile file string in DB_RECOVERY_FILE_DEST

1 10280

ORA-19811: cannot have files in DB_RECOVERY_FILE_DEST with keep attributes

2 6757

ORA-19812: cannot use string without DB_RECOVERY_FILE_DEST

1 3350

ORA-19813: cannot have unavailable file string in DB_RECOVERY_FILE_DEST

1 4243

ORA-19815: WARNING: string of string bytes is string used, and has string remaining bytes available.

1 3991

Un-Answered Questions { Database Errors }

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

2264

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

2298

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.

2573

IMP-00064: Definition of LOB was truncated by export

6465

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

1797

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

1760

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

1814

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

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

8875

write a database figure to implement the master detained relationship.

3009

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.

1697

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

1729

why we are using shift key in unix shell script

3228

NZE-28868: Peer certificate chain check failed.

2862

ORA-26084: direct path context already finished

1995

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