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-12437: invalid policy option: string

1 3181

ORA-12438: repeated policy option: string

1 2848

ORA-12439: invalid combination of policy options

1 3187

ORA-12440: insufficient authorization for the SYSDBA package

1 7213

ORA-12441: policy string already exists

1 3527

ORA-12442: policy column "string" already used by an existing policy

1 3369

ORA-12443: policy not applied to some tables in schema

1 2867

ORA-12444: policy already applied to table

1 2756

ORA-12445: cannot change HIDDEN property of column

1 3487

ORA-12446: Insufficient authorization for administration of policy string

1 3955

ORA-12447: policy role already exists for policy string

1 3077

ORA-12448: policy string not applied to schema string

1 3130

ORA-12449: Labels specified for user must be of type USER

1 2777

ORA-12450: LOB datatype disabled in LBAC initialization file

1 3618

ORA-12451: label not designated as USER or DATA

1 4145

Un-Answered Questions { Database Errors }

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

2432

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

1768

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

3667

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

6745

ORA-26079: file "string" is not part of table string.string

1958

How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table

2639

hp asking for replication floppy to do reinstall 25254 server assistant

2880

How to view the error log for any specific instance?

2486

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

1941

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

2800

How will you Handle Error in SQL SERVER 2008?

2401

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

2595

write a database figure to implement the master detained relationship.

2934

When do you get "getwmicomexception"?

2680

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

2230

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