Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2295

definion of tcp

CA,

1 6554

What is sqlcode -922 & -923?

Cap Gemini,

2 14427

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2942

Is the company liable to deduct professional tax of directors?

1 6512

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

2517

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?

2760

How to Select 38th row details in table without using rownum ?

ProKarma, Sapient, Wipro,

12 20858

display details of employee's who are seniour to there own manager ? ( In a Emp Table )

2 5133

Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user define datatype. at a column. when i want to input the valoue at this column ,i cann't the input value.following the error messasge i have got: ORA-24328 illegal attribute value

1 4422

how to resolve the sqlcode -501 erroe in db2?

Syntel,

2 18988

[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

HCL,

2770

when i open the data base the data base gives error as initalishing or terminating how i log into data base

1 4004

why we are using shift key in unix shell script

IBM, TCS,

3227

hi friends , could u please suggest the best institute in hyd or bangalore for Oracle apps and pl/sql

1 5903

Un-Answered Questions { Database Errors }

ORA-26030: index string.string had string partitions made unusable due to:

1986

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

4036

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

3219

hp asking for replication floppy to do reinstall 25254 server assistant

2953

what is new g/l functionality

2671

what is the instrument that used in Mechanical Energy??

2731

What is the use of NOLOCK locking hint?

1829

2760

ORA-26027: unique index string.string partition string initially in unusable state

6785

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

2253

IMG-02003: 2FF03 - incorrect color histogram feature specification

1756

ORA-26032: index string.string loading aborted after string keys

2171

When do you get "getwmicomexception"?

2731

What is SCD (Slowly Changing Dimensions)? What are its types?

2714

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

2494

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