Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

DRG-13012: language column must be a char, varchar, or varchar2 type

1 3010

DRG-13100: index is not partitioned

1 3102

DRG-13101: partition string does not exist in this index

1 3492

DRG-13102: index partition name must be specified

1 4206

DRG-13103: index table string is partitioned

1 2793

DRG-13104: indexes do not have equivalent settings for string

1 3255

DRG-13200: failed to load dictionary file string

1 3013

DRG-13300: document size bigger than string bytes

1 2852

DRG-13301: syntax error in token data when expecting string, at line string

1 2932

DRG-13302: number of wildcard offsets must be in the range string..string, at line string

1 2800

DRG-13303: value of wildcard offset must be in the range string..string, at line string

1 3092

DRG-13304: character referenced by wildcard attribute is not a wildcard character, at line string

1 3100

DRG-13305: 'off' attribute value must be in the range string..string, at line string

1 2743

DRG-13306: 'len' attribute value must be in the range string..string, at line string

1 2803

DRG-13307: 'off'=string and 'len'=string references character past end-of-file of string character document, at line string

1 3108

Un-Answered Questions { Database Errors }

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

2860

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

2782

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3438

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

3703

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

1799

NZE-28868: Peer certificate chain check failed.

2864

What is Mutex error in Triggers?

3119

ORA-26028: index string.string initially in unusable state

3914

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

2264

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.

2850

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

1732

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3225

ORA-26095: unprocessed stream data exists

3638

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

1665

What is the use of NOLOCK locking hint?

1832

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