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-00316: SQL FORMS statements are Oracle extensions

1 2545

PCB-00317: Group item host variables are Oracle extensions

1 2892

PCB-00318: ARRAYLEN is an Oracle extension

1 3824

PCB-00319: EXEC ORACLE statements are an Oracle extension

1 2831

PCB-00320: VARYING host variable "string" is an Oracle extension

1 2821

PCB-00321: Implicit varchar host variables are an Oracle extension

1 3286

PCB-00322: EXEC SQL LOB statements an Oracle extension

1 2908

PCB-00400: %s

1 3248

PCB-00401: Character string not properly terminated

1 8639

PCB-00402: Pseudo-text not properly terminated

1 3047

PCB-00403: EXEC statement cannot begin in Area A

1 4674

PCB-00404: %s

1 2791

PCB-00500: No EXEC SQL CONTEXT USE statement encountered

1 4078

PCB-00501: Runtime context variable "string" not of correct type

1 2842

PCB-00502: This statement can only be used with THREADS=YES

1 2683

Un-Answered Questions { Database Errors }

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

3912

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

2253

write a database figure to implement the master detained relationship.

3009

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

2857

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

1729

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

2706

hp asking for replication floppy to do reinstall 25254 server assistant

2960

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2298

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

3224

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

2714

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

2857

ORA-26094: stream format error: input column overflow

2854

ORA-26027: unique index string.string partition string initially in unusable state

6790

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

2696

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.

2849

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