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-00101: reserved for future use

1 3209

PLS-00102: parser stack overflow because nesting is too deep

1 4438

PLS-00103: %s

1 3347

PLS-00104: empty argument list in call of procedure 'string' must be omitted

1 3406

PLS-00105: at most one forward declaration of type 'string' is permitted

1 2788

PLS-00108: declarative units must be a single variable declaration

1 2779

PLS-00109: unknown exception name 'string' in PRAGMA EXCEPTION_INIT

1 4694

PLS-00110: bind variable 'string' not allowed in this context

1 5422

PLS-00111: end-of-file in comment

1 4975

PLS-00112: end-of-line in quoted identifier

1 3753

PLS-00113: END identifier 'string' must match 'string' at line string, column string

1 4712

PLS-00114: identifier 'string' too long

1 7165

PLS-00115: this PRAGMA must follow the declaration of 'string'

1 3563

PLS-00116: Duplicate where-clause in table expression

1 3532

PLS-00117: Duplicate connect-by clause in table expression

1 3264

Un-Answered Questions { Database Errors }

[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

2722

What is the use of NOLOCK locking hint?

1784

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

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

ORA-26094: stream format error: input column overflow

2797

ORA-16626: failed to enable specified object

2216

hp asking for replication floppy to do reinstall 25254 server assistant

2879

NZE-28890: Entrust Login Failed

1877

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

2445

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

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

2105

IMP-00064: Definition of LOB was truncated by export

6413

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.

2870

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

1616

How will you Handle Error in SQL SERVER 2008?

2401

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