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-39105: Master process string failed during startup. Master error:

1 4755

ORA-39106: Worker process string failed during startup. Worker error:

1 2931

ORA-39107: Master process string violated startup protocol. Master error:

1 4367

ORA-39108: Worker process string violated startup protocol. Worker error:

1 3214

ORA-39109: Unprivileged users may not operate upon other users' schemas

1 5917

ORA-39110: error deleting worker processes

1 3283

ORA-39111: Dependent object type string skipped, base object type string already exists

1 7271

ORA-39112: Dependent object type string skipped, base object type string creation failed

1 8252

ORA-39113: Unable to determine database version

1 5435

ORA-39114: Dump files are not supported for string jobs

1 3408

ORA-39115: %s is not supported over a network link

1 3081

ORA-39116: invalid trigger operation on mutating table string.string

1 3362

ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

1 4223

ORA-39119: worker process interrupt for delete worker processes call by master process

1 3613

ORA-39120: Table string can't be truncated, data will be skipped. Failing error is: string

1 8863

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1788

NZE-28890: Entrust Login Failed

1882

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?

2723

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

8820

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

2453

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

2155

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

2705

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

1680

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

6652

what is new g/l functionality

2612

How will you Handle Error in SQL SERVER 2008?

2403

ORA-26095: unprocessed stream data exists

3572

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

2656

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

2805

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

1747

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