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-22055: unknown sign flag value [string]

1 3140

ORA-22056: value [string] is divided by zero

1 3236

ORA-22057: bad integer length [string]

1 3222

ORA-22059: buffer size [string] is too small - [string] is needed

1 4412

ORA-22060: argument [string] is an invalid or uninitialized number

1 10930

ORA-22061: invalid format text [string]

1 3395

ORA-22062: invalid input string [string]

1 22384

ORA-22063: reading negative value [string] as unsigned

1 4374

ORA-22064: invalid NLS parameter string [string]

1 4579

ORA-22065: number to text translation for the given format causes overflow

1 5282

ORA-22130: buffer size [string] is less than the required size [string]

1 3060

ORA-22131: hexadecimal string length is zero

1 3134

ORA-22132: hexadecimal string does not correspond to a valid REF

1 2839

ORA-22140: given size [string] must be in the range of 0 to [string]

1 2930

ORA-22150: variable-length array has not been initialized

1 3084

Un-Answered Questions { Database Errors }

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

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 the use of NOLOCK locking hint?

1788

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

1747

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

2410

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.

2870

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

8820

ORA-26094: stream format error: input column overflow

2808

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

2656

ORA-26076: cannot set or reset value after direct path structure is allocated

1969

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2643

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

2665

NZE-28868: Peer certificate chain check failed.

2803

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

2454

When do you get "getwmicomexception"?

2682

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