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-01586: database must be mounted EXCLUSIVE and not open for this operation

1 7218

ORA-01588: must use RESETLOGS option for database open

1 5572

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

3 20958

ORA-01590: number of segment free list (string) exceeds maximum of string

1 3153

ORA-01591: lock held by in-doubt distributed transaction string

1 3881

ORA-01592: error converting Version 7 rollback segment (string) to Oracle 8 format

1 3128

ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

1 3222

ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed

1 3537

ORA-01595: error freeing extent (string) of rollback segment (string))

1 5353

ORA-01596: cannot specify system in string parameter

1 3016

ORA-01597: cannot alter system rollback segment online or offline

1 4779

ORA-01598: rollback segment 'string' is not online

1 3837

ORA-01599: failed to acquire rollback segment (string), cache space is full

1 3884

ORA-01600: at most one "string" in clause "string" of string

1 2639

ORA-01601: illegal bucket size in clause "string" of string

1 3066

Un-Answered Questions { Database Errors }

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

1677

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.

2799

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2639

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

2650

what is the instrument that used in Mechanical Energy??

2680

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

3383

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

2223

RMAN-05017: no copy of datafile number found to recover

2410

why we are using shift key in unix shell script

3164

ORA-16626: failed to enable specified object

2217

ORA-26084: direct path context already finished

1949

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

2155

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

2662

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

3862

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

1941

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