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-00236: snapshot operation disallowed: mounted controlfile is a backup

1 11458

ORA-00237: snapshot operation disallowed: controlfile newly created

1 4619

ORA-00238: operation would reuse a filename that is part of the database

1 3310

ORA-00250: archiver not started

1 4045

ORA-00251: LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string

1 4229

ORA-00252: log string of thread string is empty, cannot archive

1 3572

ORA-00253: character limit string exceeded by archive destination string string

1 3718

ORA-00254: error in archive control string 'string'

1 8155

ORA-00255: error archiving log string of thread string, sequence # string

1 3912

ORA-00256: cannot translate archive destination string string

1 3483

ORA-00257: archiver error. Connect internal only, until freed.

1 4353

ORA-00258: manual archiving in NOARCHIVELOG mode must identify log

1 7248

ORA-00259: log string of open instance string (thread string) is the current log, cannot archive

1 3813

ORA-00260: cannot find online log sequence string for thread string

1 3581

ORA-00261: log string of thread string is being archived or modified

1 7300

Un-Answered Questions { Database Errors }

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

2181

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2300

NZE-28890: Entrust Login Failed

1932

ORA-26094: stream format error: input column overflow

2859

What is Mutex error in Triggers?

3129

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

2803

hp asking for replication floppy to do reinstall 25254 server assistant

2967

ORA-16626: failed to enable specified object

2278

ORA-26029: index string.string partition string initially in unusable state

2235

ORA-26076: cannot set or reset value after direct path structure is allocated

2035

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

1669

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

2500

How will you Handle Error in SQL SERVER 2008?

2446

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2867

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

1990

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