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-01216: thread string is expected to be disabled after CREATE CONTROLFILE

1 5148

ORA-01217: logfile member belongs to a different logfile group

1 3134

ORA-01218: logfile member is not from the same point-in-time

1 2902

ORA-01219: database not open: queries allowed on fixed tables/views only

1 9038

ORA-01220: file based sort illegal before database is open

1 5931

ORA-01221: data file string is not the same file to a background process

1 8479

ORA-01222: MAXINSTANCES of string requires MAXLOGFILES be at least string, not string

1 3358

ORA-01223: RESETLOGS must be specified to set a new database name

1 9216

ORA-01224: group number in header string does not match GROUP string

1 3661

ORA-01225: thread number string is greater than MAXINSTANCES string

1 2724

ORA-01226: file header of log member is inconsistent with other members

1 2791

ORA-01227: log string is inconsistent with other logs

1 6423

ORA-01228: SET DATABASE option required to install seed database

1 3380

ORA-01229: data file string is inconsistent with logs

1 3843

ORA-01230: cannot make read only - file string is offline

1 3405

Un-Answered Questions { Database Errors }

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

8818

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

2410

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

2520

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

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

2662

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

2230

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

ORA-26032: index string.string loading aborted after string keys

2105

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

what is new g/l functionality

2611

ORA-26076: cannot set or reset value after direct path structure is allocated

1966

What is the use of NOLOCK locking hint?

1784

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.

1649

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1616

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