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-00604: error occurred at recursive SQL level string

1 4081

ORA-00606: Internal error code

1 3172

ORA-00607: Internal error occurred while making a change to a data block

1 11110

ORA-00608: testing error [string] [string] [string] [string] [string]

1 3068

ORA-00701: object necessary for warmstarting database cannot be altered

1 10516

ORA-00702: bootstrap verison 'string' inconsistent with version 'string'

1 3826

ORA-00703: maximum number of row cache instance locks exceeded

1 2843

ORA-00704: bootstrap process failure

1 6649

ORA-00705: inconsistent state during start up; shut down the instance, then restart it

1 3711

ORA-00706: error changing format of file 'string'

1 2667

ORA-00710: new tablespace name is the same as the old tablespace name

1 2974

ORA-00711: new tablespace name is invalid

1 2825

ORA-00712: cannot rename system tablespace

1 3060

ORA-00720: ALTER DATABASE RESET COMPATIBILITY command has been de-supported

1 3687

ORA-00721: changes by release string cannot be used by release string

1 3228

Un-Answered Questions { Database Errors }

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

3155

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

2223

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

ORA-16627: No standby databases support the overall protection mode.

3989

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

2697

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

8818

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

2639

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.

2532

why we are using shift key in unix shell script

3165

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2212

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

1768

what is the instrument that used in Mechanical Energy??

2680

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

2448

[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

2723

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