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

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-24350: OCI call not allowed

1 3670

ORA-24351: invalid date passed into OCI call

1 3153

ORA-24352: invalid COBOL display type passed into OCI call

1 3085

ORA-24353: user buffer too small to accommodate COBOL display type

1 8729

ORA-24354: number fetched too large to fit in COBOL display type buffer.

1 3212

ORA-24355: attempt to store a negative number in an Unsigned Display type.

1 5901

ORA-24356: internal error while converting from to COBOL display type.

1 3157

ORA-24357: internal error while converting from to OCIDate.

1 3408

ORA-24358: OCIBindObject not invoked for a Object type or Reference

1 5075

ORA-24359: OCIDefineObject not invoked for a Object type or Reference

1 6144

ORA-24360: Type Descriptor Object not specified for Object Bind/Define

1 5273

ORA-24361: basic bind call not invoked before invoking advanced bind call

1 2945

ORA-24362: improper use of the character count flag

1 3440

ORA-24363: measurements in characters illegal here

1 3308

ORA-24364: internal error while padding blanks

1 2936

Un-Answered Questions { Database Errors }

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

1823

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

3714

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

2701

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

4042

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

2669

write a database figure to implement the master detained relationship.

3019

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

2722

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

2868

When do you get "getwmicomexception"?

2735

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

6794

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

2471

NZE-28890: Entrust Login Failed

1932

[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

2779

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

2502

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2788

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