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

Database Errors Interview Questions

Questions Answers Views Company eMail

LPX-00208: unknown DTD keyword "~s"

1 3590

LPX-00209: PI names starting with XML are reserved

1 11835

LPX-00210: expected '~1c' instead of '~2c'

1 5483

LPX-00211: attribute default must be REQUIRED, IMPLIED, or FIXED

1 3512

LPX-00212: comment must not contain "--"

1 4556

give full details of this ORA-12988: cannot drop column from table owned by SYS

Oracle,

8 21817

In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?

4 9012

Trying to transfer data from Prod region to Test region.So,exporting data from Prod table(e.g xyz in prod) into a temporary table(e.g abc) and then inserting into Test table(e.g xyz in prod),but not able to insert data from one db2 table to another,the error coming out is 'foreign key vaue is not valid'

1 5900

what is meant by write off and write on in sap?

Reliance Communications, Wipro,

5 13722

I've got a database (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0) installed on a server. Via the network I try to connect to the database via a frontend DEVELOPER 2000 R 2.1 (SQL*Plus: Release 3.3.4.0.0 ) while connecting to database I've got the following error- message: ORA-12637: Packet receive failed

2 5838

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.

Investment Bank,

2747

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

HCL,

6596

ORA-13601 encountered when generating server alert SMG-3503

DB Experts,

12103

imp-00038: could not convert to environment character set's handle error occurs while importing oracle 10g data into oracle 9i database.

1 19957

I am experiencing an error failed to retrieve data from data base. it is an oracle table. Is there a limit on the number of fields that can be a report. My table has 321 fields and I do not have all of them in the report yet.

1 6520

Un-Answered Questions { Database Errors }

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

6702

What is Mutex error in Triggers?

2999

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

1895

How will you Handle Error in SQL SERVER 2008?

2342

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

2178

IMP-00064: Definition of LOB was truncated by export

6350

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

3103

write a database figure to implement the master detained relationship.

2878

What is the use of NOLOCK locking hint?

1713

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2492

RMAN-05017: no copy of datafile number found to recover

2346

When do you get "getwmicomexception"?

2630

hp asking for replication floppy to do reinstall 25254 server assistant

2817

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

2609

ORA-26094: stream format error: input column overflow

2739

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