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-38438: getVarchar not possible due to "string" datatype in the attribute set

1 3265

ORA-38439: invalid operation "string"

1 2843

ORA-38440: attribute set string does not exist

1 2765

ORA-38441: System could not derive the list of STORED and INDEXED attributes.

1 3078

ORA-38442: The ADT "string" is not in a valid state.

1 3721

ORA-38443: An attribute set should be assigned to the expression set for statistics collection.

1 3098

ORA-38444: statistics do not exist for the expression set

1 2865

ORA-38445: TOP clause not allowed with no statistics

1 3347

ORA-38446: Error with embedded ADT "string" in the attribute set.

1 2930

ORA-38447: Type required for the embedded ADT attribute "string" is missing

1 3035

ORA-38448: Indexing predicates with "string" operator is not supported.

1 2962

ORA-38449: table "string" does not exist or is not accessible

1 2549

ORA-38450: error computing a stored attribute for the expression set.

1 2946

ORA-38451: index is in an inconsistent state

1 2839

ORA-38452: Expression Filter index name may not be longer than 25 characters

1 2649

Un-Answered Questions { Database Errors }

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

2445

hp asking for replication floppy to do reinstall 25254 server assistant

2902

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2257

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

2682

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

1949

what is new g/l functionality

2629

When do you get "getwmicomexception"?

2691

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

2421

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

2491

ORA-16626: failed to enable specified object

2230

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

2117

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

1694

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.

2818

NZE-28890: Entrust Login Failed

1887

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

2749

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