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-02409: Expecting an expression of some REF type

1 3657

PCC-02410: Expecting an expression of some Collection type.

1 3148

PCC-02411: Invalid type for INDICATOR descriptor item host variable

1 2785

PCC-02412: FOR clause not permitted in OBJECT GET or SET statement

1 2878

PCC-02413: Number of attributes does not match number of host variables

1 2985

PCC-02414: This attribute does not exist in the specified Object

1 3358

PCC-02415: Cannot manipulate Object attributes in an OBJECT GET or SET

1 2575

PCC-02416: The Object in an OBJECT GET or SET must not be an array

1 2727

PCC-02417: Illegal type conversion between attribute and host variable

1 3038

PCC-02418: Array size mismatch between Object and REF host variables

1 3332

PCC-02419: Host variable arrays not allowed in an OBJECT SET or GET

1 2671

PCC-02420: Incomplete (or missing) type specification

1 6519

PCC-02421: This host variable requires the use of an indicator variable

1 2975

PCC-02422: Invalid value specified for the given context option

1 4111

PCC-02423: Host variable has an invalid type for this option value

1 2955

Un-Answered Questions { Database Errors }

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

3665

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2868

ORA-26032: index string.string loading aborted after string keys

2104

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

2210

When do you get "getwmicomexception"?

2678

What is live lock, deadlock and what is Lock escalation?

2430

write a database figure to implement the master detained relationship.

2934

IMP-00064: Definition of LOB was truncated by export

6411

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

3151

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

3984

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

2221

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.

2797

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

1963

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

1616

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

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