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

Database Errors Interview Questions

Questions Answers Views Company eMail

PCC-01008: Multiple element records not allowed in DECLARE section

1 2679

PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or "."

1 3436

PCC-01010: Invalid use of NULL character in character literal

1 3733

PCC-01011: USAGE IS BINARY clause must be terminated by "." on same line

1 3265

PCC-01012: DATA DIVISION not found

1 2982

PCC-01013: Invalid use of PIC N array variable "string" at line number in file string

1 3252

PCC-01014: "VARYING" not supported with PIC N PICTURE clause

1 2828

PCC-01015: Cannot equivalence PIC N variable string

1 2920

PCC-01016: "N" character literals not supported in embedded PL/SQL

1 3171

PCC-01017: The SQLCA and a SQLCODE variable cannot both be used

1 3313

PCC-01018: Conversion buffer size can only be specified for character types

1 2716

PCC-01019: Invalid conversion buffer size

1 2761

PCC-01100: You are not authorized to run Pro*FORTRAN

1 2671

PCC-01101: Your Pro*FORTRAN authorization is about to expire

1 3341

PCC-01102: Invalid label at line number in file string

1 3416

Un-Answered Questions { Database Errors }

When do you get "getwmicomexception"?

2678

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

1616

why we are using shift key in unix shell script

3163

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

2731

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

2155

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

2662

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

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

What is the use of NOLOCK locking hint?

1784

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2696

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

3383

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

1743

ORA-26095: unprocessed stream data exists

3561

NZE-28890: Entrust Login Failed

1876

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

1706

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