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-38773: cannot add data file 'string' - file already part of database

1 3478

ORA-38774: cannot disable media recovery - flashback database is enabled

1 8081

ORA-38775: cannot disable flash recovery area - flashback database is enabled

2 9076

ORA-38776: cannot begin flashback generation - flash recovery area is disabled

1 3296

ORA-38900: missing mandatory column "string" of error log table "string"

1 4636

ORA-38901: column "string" of table "string" must be one of the first "number" columns

1 3328

ORA-38950: Source platform string not cross platform compliant

1 2763

ORA-38951: Target platform string not cross platform compliant

1 2914

ORA-38952: Source database not 10.0.0.0 compatible

1 3083

ORA-38954: Cross platform transport is not supported between source platform identifier string and target platform identifier string

1 3127

ORA-38955: Source platform string not cross platform compliant

1 3502

ORA-38956: Target platform string not cross platform compliant

1 2539

ORA-38957: Target database not 10.0.0.0 compatible

1 2725

ORA-38958: Source platform string is in different byte order than target platform string

1 2915

ORA-38959: Failed to update block 0 to new version 10 format

1 2827

Un-Answered Questions { Database Errors }

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

1780

What is Mutex error in Triggers?

3081

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?

2729

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

2530

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2746

what is the instrument that used in Mechanical Energy??

2693

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.

2886

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

2680

When do you get "getwmicomexception"?

2690

ORA-26094: stream format error: input column overflow

2820

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.

2816

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

1692

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

2659

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

6755

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

1758

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