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-01231: cannot make read write - file string is offline

1 2827

ORA-01232: cannot start online backup - file string is being made read-only

1 2984

ORA-01233: file string is read only - cannot recover using backup controlfile

1 2813

ORA-01234: cannot end backup of file string - file is in use or recovery

1 2834

ORA-01235: END BACKUP failed for string file(s) and succeeded for string

1 3871

ORA-01236: Error string occurred during initialization of file header access

1 3089

ORA-01237: cannot extend datafile string

2 7855

ORA-01238: cannot shrink datafile string

1 3109

ORA-01239: database must be in ARCHIVELOG mode to use external cache

1 3340

ORA-01240: too many data files to add in one command

1 3136

ORA-01241: an external cache has died

1 2878

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

1 5141

ORA-01243: system tablespace file suffered media failure

1 4025

ORA-01244: unnamed datafile(s) added to controlfile by media recovery

1 5373

ORA-01245: offline file string will be lost if RESETLOGS is done

2 20573

Un-Answered Questions { Database Errors }

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

2662

why we are using shift key in unix shell script

3165

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

2410

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

1768

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

8818

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2520

What is Mutex error in Triggers?

3064

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6650

hp asking for replication floppy to do reinstall 25254 server assistant

2880

How will you Handle Error in SQL SERVER 2008?

2401

what is the instrument that used in Mechanical Energy??

2680

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

6745

IMP-00064: Definition of LOB was truncated by export

6413

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

1706

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

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