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-01088: cannot shut down ORACLE while active processes exist

1 3436

ORA-01089: immediate shutdown in progress - no operations are permitted

1 7216

ORA-01090: shutdown in progress - connection is not permitted

1 6797

ORA-01091: failure during startup force

1 3752

ORA-01092: ORACLE instance terminated. Disconnection forced

1 4148

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected

2 11511

ORA-01095: DML statement processed zero rows

1 3502

ORA-01096: program version (string) incompatible with instance (string)

1 5205

ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 8652

ORA-01099: cannot mount database in SHARED mode if started in single process mode

1 3194

ORA-01100: database already mounted

Oracle, Wipro,

3 37867

ORA-01101: database being created currently mounted by some other instance

1 4207

ORA-01102: cannot mount database in EXCLUSIVE mode

1 4706

ORA-01103: database name 'string' in controlfile is not 'string'

4 27647

ORA-01104: number of controlfiles (string) does not equal string

1 7250

Un-Answered Questions { Database Errors }

What is the meaning of lock escalation and why/how to stop this?

2716

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

2269

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

2589

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2867

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

2788

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

2523

How to view the error log for any specific instance?

2546

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

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

2502

What is the use of NOLOCK locking hint?

1837

[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

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.

2856

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6722

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

1801

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

3440

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