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-00034: cannot string in current PL/SQL session

1 3269

ORA-00036: maximum number of recursive SQL levels (string) exceeded

1 6571

ORA-00037: cannot switch to a session belonging to a different server group

1 3867

ORA-00038: Cannot create session: server group belongs to another user

1 3441

ORA-00040: active time limit exceeded - call aborted

1 8854

ORA-00041: active time limit exceeded - session terminated

1 7703

ORA-00050: operating system error occurred while obtaining an enqueue

1 3532

ORA-00051: timeout occurred while waiting for a resource

1 3615

ORA-00052: maximum number of enqueue resources (string) exceeded

1 4051

ORA-00053: maximum number of enqueues exceeded

1 4066

ORA-00054: resource busy and acquire with NOWAIT specified

1 4291

ORA-00055: maximum number of DML locks exceeded

1 4061

ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode

1 4061

ORA-00057: maximum number of temporary table locks exceeded

1 3418

ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)

1 3719

Un-Answered Questions { Database Errors }

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

3704

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

2178

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

1817

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

2662

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.

2945

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

2581

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.

1700

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

2253

When do you get "getwmicomexception"?

2733

what is new g/l functionality

2675

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

3438

ORA-16627: No standby databases support the overall protection mode.

4039

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

6718

ORA-26095: unprocessed stream data exists

3641

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

1989

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