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 3005

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

1 2827

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

1 2951

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

ICICI,

1 13183

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

1 3547

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

1 2832

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 3024

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

1 12472

ORA-22166: collection is empty

1 3074

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 3785

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 2927

Un-Answered Questions { Database Errors }

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

1941

What is the use of NOLOCK locking hint?

1788

hp asking for replication floppy to do reinstall 25254 server assistant

2886

What severity level errors are managed in TRY-CATCH block?

2225

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

1970

How will you Handle Error in SQL SERVER 2008?

2403

ORA-26094: stream format error: input column overflow

2808

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2733

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

3993

write a database figure to implement the master detained relationship.

2936

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

1958

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2539

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

2667

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

2155

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

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