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-22314: method information mismatch in ALTER TYPE

1 3133

ORA-22315: type "string" does not contain a map or order function

1 3522

ORA-22316: input type is not a collection type

1 3070

ORA-22317: typecode number is not legal as a number type

1 2917

ORA-22318: input type is not an array type

1 3102

ORA-22319: type attribute information altered in ALTER TYPE

1 3272

ORA-22320: missing user version string

1 3062

ORA-22321: method does not return any result

1 3121

ORA-22322: error table "string"."string" has incorrect structure

1 2890

ORA-22323: error table "string"."string" does not exist

1 2926

ORA-22324: altered type has compilation errors

1 6981

ORA-22326: cannot change a type to FINAL if it has subtypes

1 3273

ORA-22327: cannot change a type to NOT INSTANTIABLE if it has dependent tables

1 2712

ORA-22328: object "string"."string" has errors. string

1 3326

ORA-22329: cannot alter a non-object type

1 3109

Un-Answered Questions { Database Errors }

What is the use of NOLOCK locking hint?

1788

ORA-26095: unprocessed stream data exists

3572

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

2107

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

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

2733

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

8820

How will you Handle Error in SQL SERVER 2008?

2403

mount: mount to NFS server failed: System Error: Connection timed out

3668

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2522

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

1941

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1620

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1680

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.............

2804

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

2410

what is new g/l functionality

2612

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