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-30502: system triggers cannot have INSERT, UPDATE, or DELETE as triggering events

1 3749

ORA-30503: system triggers cannot have a REFERENCING clause

1 3341

ORA-30504: system triggers cannot have a FOR EACH ROW clause

1 3124

ORA-30505: system triggers should not reference a column in a WHEN clause

1 2976

ORA-30506: system triggers cannot be based on tables or views

1 6374

ORA-30507: normal triggers cannot be based on a schema or a database

1 5160

ORA-30508: client logon triggers cannot have BEFORE type

1 4142

ORA-30509: client logoff triggers cannot have AFTER type

1 3458

ORA-30510: system triggers cannot be defined on the schema of SYS user

1 5929

ORA-30511: invalid DDL operation in system triggers

1 5900

ORA-30512: cannot modify string.string more than once in a transaction

1 3684

ORA-30513: cannot create system triggers of INSTEAD OF type

1 3236

ORA-30514: system trigger cannot modify tablespace being made read only

1 5081

ORA-30515: suspend triggers cannot have BEFORE type

1 2731

ORA-30550: index depends on a package/function spec/body which is not valid

1 3997

Un-Answered Questions { Database Errors }

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

2619

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

3399

How to view the error log for any specific instance?

2496

NZE-28890: Entrust Login Failed

1891

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

1630

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2738

What severity level errors are managed in TRY-CATCH block?

2242

NZE-28868: Peer certificate chain check failed.

2824

hp asking for replication floppy to do reinstall 25254 server assistant

2904

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

2226

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

6758

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

1725

How will you Handle Error in SQL SERVER 2008?

2418

2756

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

2450

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