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-24270: a row already exists in the string table for these parameters

1 3196

ORA-24271: translation type must be either T, S or M

1 3568

ORA-24272: initialization value must be either F or T

1 3326

ORA-24273: translation text is required if translation type is T or S

1 3241

ORA-24274: no row exists in the string table for these parameters

1 3373

ORA-24275: function 'string' parameter 'string' missing or invalid

1 2895

ORA-24276: function 'string' output 'string' maximum value exceeded

1 3147

ORA-02140: invalid tablespace name

1 8162

ORA-02141: invalid OFFLINE option

1 3889

ORA-02142: missing or invalid ALTER TABLESPACE option

1 7748

ORA-02143: invalid STORAGE option

1 14711

ORA-02144: no option specified for ALTER CLUSTER

1 2920

ORA-02145: missing STORAGE option

Oracle,

1 6039

ORA-02146: SHARED specified multiple times

1 3413

ORA-02147: conflicting SHARED/EXCLUSIVE options

1 3042

Un-Answered Questions { Database Errors }

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

2229

How will you Handle Error in SQL SERVER 2008?

2440

ORA-16626: failed to enable specified object

2272

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

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

2857

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

2495

[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

2772

what is new g/l functionality

2673

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1697

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

6790

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

1986

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2857

why we are using shift key in unix shell script

3228

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

2253

What is the use of NOLOCK locking hint?

1832

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