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-01922: CASCADE must be specified to drop 'string'

1 10627

ORA-01923: CASCADE aborted, objects locked by another user

1 3072

ORA-01924: role 'string' not granted or does not exist

1 8500

ORA-01925: maximum of string enabled roles exceeded

2 4052

ORA-01926: cannot GRANT to a role WITH GRANT OPTION

1 7643

ORA-01927: cannot REVOKE privileges you did not grant

1 7545

ORA-01928: GRANT option not granted for all privileges

1 3683

ORA-01929: no privileges to GRANT

1 10959

ORA-01930: auditing the object is not supported

1 3368

ORA-01931: cannot grant string to a role

1 6088

ORA-01932: ADMIN option not granted for role 'string'

1 13398

ORA-01933: cannot create a stored object using privileges from a role

1 3835

ORA-01934: circular role grant detected

1 7468

ORA-01935: missing user or role name

2 15969

ORA-01936: cannot specify owner when creating users or roles

1 10429

Un-Answered Questions { Database Errors }

What is the meaning of lock escalation and why/how to stop this?

2650

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

3154

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

8816

what is new g/l functionality

2611

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

3987

What is Mutex error in Triggers?

3064

ORA-26027: unique index string.string partition string initially in unusable state

6744

How will you Handle Error in SQL SERVER 2008?

2401

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

2445

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

1706

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

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

2155

what is the instrument that used in Mechanical Energy??

2680

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

2432

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

2105

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