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

Database Errors Interview Questions

Questions Answers Views Company eMail

PLS-01425: Connect-by clause

1 2877

PLS-01450: This contains a nonconforming data type

1 2759

PLS-01451: The data types of these must be comparable

1 2614

PLS-01452: This function is not part of the ANSI standard

1 2891

PLS-01453: This procedure is not part of the ANSI standard

1 2659

PLS-01454: No operator may be used with values of data type CHAR

1 2635

PLS-01455: The predicates IS NULL and IS NOT NULL are defined only for column specifications

1 2895

PLS-01458: The set clause in an UPDATE statement requires a column name of length 1

1 2766

PLS-01460: Cannot access object on a remote host

1 3311

PLS-01463: STDDEV is not a standard set function

1 2745

PLS-01464: VARIANCE is not a standard set function

1 3094

PLS-01466: Null strings are not allowed

1 2863

PLS-01467: The value list of the IN predicate, if not a subquery, must contain only value_specifications

1 3814

PLS-01468: The first argument of the like-predicate must be a column of type character string

1 3046

PLS-01469: ANSI standard does not permit records

1 2772

Un-Answered Questions { Database Errors }

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

1708

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.

2799

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

2733

write a database figure to implement the master detained relationship.

2934

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2212

What is the use of NOLOCK locking hint?

1784

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

2800

what is the instrument that used in Mechanical Energy??

2680

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

1677

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

2410

What is Mutex error in Triggers?

3064

How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

2721

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

2223

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

2520

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.

2532

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