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

Database Errors Interview Questions

Questions Answers Views Company eMail

KUP-04083: no directory object specified in LOBFILE clause for column string

1 2949

KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

1 4163

KUP-04085: duplicate directory object string and file string specified for unload

1 2734

KUP-04088: data sampling is not supported by this access driver

1 2663

KUP-04089: column transform string is not the name of a table column

1 2810

KUP-04090: big endian byte order mark found when little endian expected in string

1 2713

KUP-04091: little endian byte order mark found when big endian expected in string

1 3029

KUP-04100: record rejected in file string

1 2844

KUP-04101: record number rejected in file string

1 3949

KUP-04102: record number discarded from file string

1 4431

KUP-04103: error converting zoned decimal field to number for string

1 3040

KUP-04104: zoned decimal field has bad values for string

1 3020

KUP-04105: zoned decimal to number conversion caused overflow for string

1 3623

KUP-04106: precision for zoned decimal number is too large for string

1 2881

KUP-04108: unable to reread file string

1 3227

Un-Answered Questions { Database Errors }

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

1943

How will you Handle Error in SQL SERVER 2008?

2407

What is Mutex error in Triggers?

3076

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

1771

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.

2810

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

2743

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

3673

ORA-16626: failed to enable specified object

2225

write a database figure to implement the master detained relationship.

2940

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

6752

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

1626

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

1960

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3390

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

2229

today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql

2459

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