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-22151: cannot resize non-zero variable-length array to zero elements

1 3003

ORA-22152: destination variable-length array is not initialized

1 2825

ORA-22153: source variable-length array is not initialized

1 2950

ORA-22160: element at index [string] does not exist

ICICI,

1 13182

ORA-22161: type code [string] is not valid

1 3545

ORA-22162: element at index [string] has been previously deleted

1 2830

ORA-22163: left hand and right hand side collections are not of same type

1 4013

ORA-22164: delete element operation is not allowed for variable-length array

1 3023

ORA-22165: given index [string] must be in the range of 0 to [string]

1 12472

ORA-22166: collection is empty

1 3072

ORA-22167: given trim size [string] must be less than or equal to [string]

1 4621

ORA-22275: invalid LOB locator specified

1 4751

ORA-22276: invalid locator for LOB buffering

1 3784

ORA-22277: cannot use two different locators to modify the same LOB

1 3618

ORA-22278: must update the LOB only through the LOB buffers

1 2926

Un-Answered Questions { Database Errors }

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-26076: cannot set or reset value after direct path structure is allocated

1969

ORA-26079: file "string" is not part of table string.string

1958

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

2107

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

1747

ORA-26082: load of overlapping segments on table string.string is not allowed

1768

NZE-28868: Peer certificate chain check failed.

2803

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

2434

How will you Handle Error in SQL SERVER 2008?

2403

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

2665

What is the use of NOLOCK locking hint?

1788

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

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2803

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

1710

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