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-31078: error in SQL mapping information

1 2913

ORA-31079: unable to resolve reference to string "string"

1 3195

ORA-31080: type not specified for attribute or element "string"

1 2688

ORA-31081: name not specified for global declaration

1 3262

ORA-31082: invalid attribute "string" specified in declaration of "string"

1 3171

ORA-31083: error while creating SQL type "string"."string"

1 3300

ORA-31084: error while creating table "string"."string" for element "string"

1 4064

ORA-31085: schema "string" already registered

1 8734

ORA-31086: insufficient privileges to register global schema "string"

1 6173

ORA-31087: insufficient privileges to delete schema "string"

1 2900

ORA-31088: object "string"."string" depends on the schema

1 2951

ORA-31089: schema "string" does not target namespace "string"

1 3033

ORA-31090: invalid database schema name "string"

1 3288

ORA-31091: empty string specified as a SQL name

1 2797

ORA-31092: invalid SQL name "string"

1 3193

Un-Answered Questions { Database Errors }

ORA-26094: stream format error: input column overflow

2825

[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

2738

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

3399

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2495

What is live lock, deadlock and what is Lock escalation?

2449

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2553

ORA-16626: failed to enable specified object

2232

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

3189

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.

1673

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

2242

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

2661

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

3875

write a database figure to implement the master detained relationship.

2957

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

1984

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

1695

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