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 3686

LPX-00209: PI names starting with XML are reserved

1 11952

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

1 5586

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

1 3623

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

1 4633

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

Oracle,

8 22227

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 9212

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 5997

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

Reliance Communications, Wipro,

5 13925

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 5964

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,

2804

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,

6653

ORA-13601 encountered when generating server alert SMG-3503

DB Experts,

12179

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

1 20049

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 6636

Un-Answered Questions { Database Errors }

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

2155

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2742

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

3668

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

2643

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

1747

[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

2731

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

1683

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

2805

When do you get "getwmicomexception"?

2682

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

3864

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

2666

ORA-26094: stream format error: input column overflow

2808

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

1970

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

2225

2804

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