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-24410: scrollable cursor max size exceeded

1 3302

ORA-24411: Session pool already exists.

1 3225

ORA-24412: Cannot reinitialize non-existent pool

1 3246

ORA-24413: Invalid number of sessions specified

1 5771

ORA-24414: Only number sessions could be started.

1 2933

ORA-24415: Missing or null username.

1 8421

ORA-24416: Invalid session Poolname was specified.

1 6761

ORA-24417: Session pool size has exceeded the maximum limit

1 3610

ORA-24418: Cannot open further sessions.

1 4570

ORA-24419: Proxy sessions are not supported in this mode.

1 3237

ORA-24420: OCISessionRelease must be used to release this session.

1 3265

ORA-24421: OCISessionRelease cannot be used to release this session.

1 3354

ORA-24422: error occurred while trying to destroy the Session Pool

1 4873

ORA-24430: Null values for sqltext and key were specified.

1 3374

ORA-24431: Statement does not exist in the cache

1 3806

Un-Answered Questions { Database Errors }

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

1768

hp asking for replication floppy to do reinstall 25254 server assistant

2880

What is Mutex error in Triggers?

3064

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

2739

write a database figure to implement the master detained relationship.

2934

How to view the error log for any specific instance?

2486

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

2432

When do you get "getwmicomexception"?

2680

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

1941

[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 severity level errors are managed in TRY-CATCH block?

2223

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

1616

ORA-16626: failed to enable specified object

2218

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2212

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

8818

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