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

Database Errors Interview Questions

Questions Answers Views Company eMail

DRG-11004: duplicate or conflicting value for string

1 3762

DRG-11005: invalid create index parameter string

1 3047

DRG-11006: invalid alter index parameter string

1 3019

DRG-11007: multiple stopwords specified

1 2773

DRG-11008: invalid create index partition parameter string

1 2853

DRG-11100: unable to connect to the database

1 2938

DRG-11101: failed to open file string

1 3713

DRG-11102: assigned lexer can not operate on string language setting

1 3257

DRG-11104: Oracle Text error:

1 3215

DRG-11106: user database session has terminated during this operation

1 3046

DRG-11107: invalid path specification: string

1 2783

DRG-11108: invalid filename specified: string

1 2999

DRG-11109: assigned lexer does not support string query operator

1 2811

DRG-11111: value of string must be between string and string

1 2843

DRG-11112: length of string exceeds maximum of string

1 2835

Un-Answered Questions { Database Errors }

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

2225

[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

2731

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

3863

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6652

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

2454

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

3668

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

2434

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

2599

write a database figure to implement the master detained relationship.

2936

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

3169

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

3385

ORA-16516: The current state is invalid for the attempted operation.

8820

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

2665

What is Mutex error in Triggers?

3069

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2522

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