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-01586: database must be mounted EXCLUSIVE and not open for this operation

1 7324

ORA-01588: must use RESETLOGS option for database open

1 5639

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

3 21119

ORA-01590: number of segment free list (string) exceeds maximum of string

1 3240

ORA-01591: lock held by in-doubt distributed transaction string

1 3992

ORA-01592: error converting Version 7 rollback segment (string) to Oracle 8 format

1 3202

ORA-01593: rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)

1 3311

ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed

1 3633

ORA-01595: error freeing extent (string) of rollback segment (string))

1 5421

ORA-01596: cannot specify system in string parameter

1 3105

ORA-01597: cannot alter system rollback segment online or offline

1 4870

ORA-01598: rollback segment 'string' is not online

1 3921

ORA-01599: failed to acquire rollback segment (string), cache space is full

1 3975

ORA-01600: at most one "string" in clause "string" of string

1 2720

ORA-01601: illegal bucket size in clause "string" of string

1 3142

Un-Answered Questions { Database Errors }

How will you Handle Error in SQL SERVER 2008?

2446

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

2035

RMAN-05017: no copy of datafile number found to recover

2471

What is Mutex error in Triggers?

3129

ORA-26095: unprocessed stream data exists

3642

ORA-26084: direct path context already finished

1999

When do you get "getwmicomexception"?

2735

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

2868

What is the use of NOLOCK locking hint?

1837

IMP-00064: Definition of LOB was truncated by export

6473

IMG-02003: 2FF03 - incorrect color histogram feature specification

1769

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

6721

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

3440

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

2522

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

2668

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