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-01725: USERENV('COMMITSCN') not allowed here

1 3356

ORA-01734: illegal parameters - EXTENT MIN higher than EXTENT MAX

1 3568

ORA-01742: comment not terminated properly

1 13710

ORA-01743: only pure functions can be indexed

1 6744

ORA-01751: Invalid dump undo option

1 3148

ORA-01752: cannot delete from view without exactly one key-preserved table

1 6877

ORA-01754: a table may contain only one column of type LONG

1 5557

ORA-01755: Must specify an extent number or block number

1 4028

ORA-01757: Must specify an object number

1 3432

ORA-01761: DML operation does not map to a unique table in the join

1 3159

ORA-01763: update or delete involves outer joined table

1 3732

ORA-01764: new update value of join is not guaranteed to be unique

1 3484

ORA-01769: duplicate CLUSTER option specifications

1 3534

ORA-01771: illegal option for a clustered table

1 4416

ORA-01772: Must specify a value for LEVEL

1 5269

Un-Answered Questions { Database Errors }

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

8882

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.

2948

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2779

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3229

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2758

ORA-26094: stream format error: input column overflow

2859

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

1736

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

6794

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

2235

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

1669

How will you Handle Error in SQL SERVER 2008?

2446

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

2035

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?

2767

IMP-00064: Definition of LOB was truncated by export

6473

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

1769

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