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

Database Errors Interview Questions

Questions Answers Views Company eMail

PCB-00109: Unable to open generated source file "string"

1 3018

PCB-00110: Unable to open temporary file "string"

1 2862

PCB-00200: Cannot equivalence PIC N or PIC G variable "string"

1 2782

PCB-00201: Indicator variable string not a group item

1 2690

PCB-00202: Indicator variable string not a group item or table

1 2747

PCB-00203: Nested group item "string" not supported

1 3027

PCB-00204: Group items cannot be used except in INTO or VALUES clause

1 3219

PCB-00205: Cannot use PIC N or PIC G variable in PL/SQL when NLS_LOCAL=YES

1 2710

PCB-00206: Cannot use N quoted literal in PL/SQL when NLS_LOCAL=YES

1 3173

PCB-00207: Invalid use of PIC N or PIC G table variable when NLS_LOCAL=YES

1 2565

PCB-00208: Incorrect type for host variable "string"

1 4194

PCB-00209: Scale is not supported for host variable "string"

1 3424

PCB-00210: DISPLAY-1 only allowed with PIC G and PIC N variables "string"

1 2766

PCB-00211: VARYING not supported with PIC N or PIC G variable "string"

1 2724

PCB-00212: PICTURE clause not allowed for host variable "string"

1 2880

Un-Answered Questions { Database Errors }

How to view the error log for any specific instance?

2431

what is the instrument that used in Mechanical Energy??

2641

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

1637

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2753

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

1666

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2587

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

1580

ORA-26095: unprocessed stream data exists

3519

How will you Handle Error in SQL SERVER 2008?

2357

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.

2765

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

2480

IMP-00064: Definition of LOB was truncated by export

6362

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

3113

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

2395

why we are using shift key in unix shell script

3096

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