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-00092: Length and/or scale incompatible with specified Oracle datatype

1 2836

PCC-00093: Invalid or obsolete option, ignored

1 3009

PCC-00094: Array length for char[n] datatype must be >= 2

1 2803

PCC-00095: Missing PROGRAM, SUBROUTINE, FUNCTION, or BLOCK DATA statement

1 2851

PCC-00096: Array FETCH not allowed for mode=ANSI14

1 3309

PCC-00097: Use of DECIMAL and DISPLAY types allowed only for COBOL and PL/I

1 3426

PCC-00098: Scale specification cannot be used in this context

1 2657

PCC-00099: Length cannot be given for types ROWID, DATE, or MLSLABEL

1 2636

PCC-00100: Non integer label is not ANSI

1 3000

PCC-00101: Lower case 'e' in floating point number is not ANSI

1 2705

PCC-00102: FOR UPDATE is an Oracle extension

1 2808

PCC-00103: AT clause is an Oracle extension

1 2948

PCC-00104: FOR clause is an Oracle extension

1 2908

PCC-00105: Keyword WORK required here by ANSI

1 3058

PCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements

1 3375

Un-Answered Questions { Database Errors }

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

1940

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

2661

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

1616

What is the meaning of lock escalation and why/how to stop this?

2648

IMP-00064: Definition of LOB was truncated by export

6412

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

3860

What is the use of NOLOCK locking hint?

1783

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?

2720

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

2730

How to view the error log for any specific instance?

2481

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

2154

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

2222

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.

2798

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

NZE-28890: Entrust Login Failed

1874

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