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-00003: Invalid SQL Identifier at column number in line number of file string

1 3047

PCC-00004: Mismatched IF/ELSE/ENDIF block at line number in file string

1 2824

PCC-00005: Unsupported datatype in line number of file string

1 2817

PCC-00007: Invalid WHENEVER condition at column number in line number of file string

1 2936

PCC-00008: Invalid WHENEVER action at column number in line number of file string

1 3472

PCC-00009: Invalid host variable at column number in line number of file string

1 2694

PCC-00010: Statement out of place at line number in file string

1 3199

PCC-00011: Already in a declare section at line number in file string

1 2799

PCC-00012: Not in a declare section at line number in file string

1 2879

PCC-00013: Unable to open include file "string" at line number in file string

1 2801

PCC-00014: Undeclared SQL Identifier "string" at line number in file string

1 2862

PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

1 3544

PCC-00016: Unable to open a cursor at line number in file string

1 4026

PCC-00017: Unable to parse statement at line number in file string

1 2769

PCC-00018: Expected "string", but found "string" at line number in file string

1 2836

Un-Answered Questions { Database Errors }

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

1940

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2868

what is the instrument that used in Mechanical Energy??

2679

ORA-26079: file "string" is not part of table string.string

1956

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

1676

What is the use of NOLOCK locking hint?

1783

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

2430

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2720

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

3665

ORA-26076: cannot set or reset value after direct path structure is allocated

1963

IMP-00064: Definition of LOB was truncated by export

6412

NZE-28868: Peer certificate chain check failed.

2798

NZE-28890: Entrust Login Failed

1874

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

3382

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

1742

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