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-02363: Indicator variable must be a structure

1 3347

PCC-02364: Host struct and its indicator must have the same number of fields

1 3105

PCC-02365: Indicator array size cannot be smaller than host array size

1 6509

PCC-02366: Command line argument MODE=ANSI may not be used with DBMS=V6

1 2963

PCC-02367: This indicator variable must be declared as type short

1 5599

PCC-02368: An EXEC TOOLS host variable context name is not type char

1 3287

PCC-02369: An EXEC TOOLS host pointer variable is not a pointer

1 3053

PCC-02370: An EXEC TOOLS MESSAGE host variable is not type char

1 2851

PCC-02371: Illegal FOR clause

1 2866

PCC-02372: FOR clause not allowed in SELECT statement

1 2829

PCC-02373: Invalid declaration in EXEC SQL DECLARE section

1 2846

PCC-02374: SQLCHECK value exceeds command line value

1 4773

PCC-02375: SQL statement found outside the body of a function

1 4323

PCC-02376: You may not declare SQLCODE when DEF_SQLCODE = TRUE

1 3119

PCC-02377: Arrays of implicit varchars are not permitted

1 2851

Un-Answered Questions { Database Errors }

write a database figure to implement the master detained relationship.

2934

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

2593

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2520

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

2799

NZE-28890: Entrust Login Failed

1873

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1647

IMG-02003: 2FF03 - incorrect color histogram feature specification

1704

ORA-26082: load of overlapping segments on table string.string is not allowed

1766

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

1940

ORA-16627: No standby databases support the overall protection mode.

3984

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

2647

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

1962

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

6650

hp asking for replication floppy to do reinstall 25254 server assistant

2878

How will you Handle Error in SQL SERVER 2008?

2401

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