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

Database Errors Interview Questions

Questions Answers Views Company eMail

PLS-01703: Cursor name in CLOSE statment must be of length 1

1 2726

PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC

1 2537

PLS-01705: table specified by a cursor not updatable if cursor specification has a UNION or ORDER_BY

1 3634

PLS-01707: In positioned DELETE or UPDATE statement, table must be identified in specification of cursor

1 2551

PLS-01708: In searched DELETE, UPDATE or INSERT, table must not appear in FROM clause of subqueries in search condition

1 2593

PLS-01709: value list of INSERT statement, if specified with value list rather than subquery, must be value specification

1 2764

PLS-01710: In a positioned DELETE or UPDATE statement, the cursor name must be of length 1

1 2881

PLS-01711: A SELECT statement may not contain ORDER_BY, HAVING, or GROUP_BY clause

1 2883

PLS-01712: ANSI does not allow bind variables as INDICATORS

1 2837

PLS-01713: The constraints on these types do not match

1 2797

PLS-01714: ANSI expects a column name not a literal value here

1 2900

PLS-01900: : character to number conversion error

1 3148

PLS-01901: : host bind array too small

1 5109

PLS-01902: : hex to raw conversion error

1 5985

PLS-01903: : non-integer error number

1 3117

Un-Answered Questions { Database Errors }

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

1616

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

2639

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

1941

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

3862

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

3385

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

1768

IMP-00064: Definition of LOB was truncated by export

6413

ORA-16626: failed to enable specified object

2218

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

2432

ORA-26084: direct path context already finished

1949

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

3156

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

2652

why we are using shift key in unix shell script

3165

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

6746

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.

1651

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