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 3304

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

1 7113

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

1 6705

ORA-01091: failure during startup force

1 3661

ORA-01092: ORACLE instance terminated. Disconnection forced

1 4067

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

2 11385

ORA-01095: DML statement processed zero rows

1 3407

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

1 5102

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

1 8514

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

1 3110

ORA-01100: database already mounted

Oracle, Wipro,

3 37676

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

1 4103

ORA-01102: cannot mount database in EXCLUSIVE mode

1 4625

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

4 27459

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

1 7154

Un-Answered Questions { Database Errors }

write a database figure to implement the master detained relationship.

2934

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?

2721

NZE-28890: Entrust Login Failed

1877

ORA-26094: stream format error: input column overflow

2797

mount: mount to NFS server failed: System Error: Connection timed out

3666

RMAN-05017: no copy of datafile number found to recover

2410

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

1616

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

3383

[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

2722

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

3988

hp asking for replication floppy to do reinstall 25254 server assistant

2879

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

2155

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

6650

ORA-26084: direct path context already finished

1949

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

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