TATA TECHNOLOGY PL/SQL Interview Questions

Tell me about your self?

Which version database using in your company?

Can you please major differences in oracle 11h,12c ?

What does instr () and substr () returns. Write syntax for both?

Write a query to delete duplicate rows from a table?

Can use dml commands in triggers?

Constraint vs. Trigger?

Why Materialized view using?

Structure compound trigger?

why use pragma exception inint?

What is a sequence and what is the need of it?

Triggers syntax write?

What happens if a cursor is not closed?

What happens when you try to open a cursor that is already opened?

What is temporary table space? Can you create that?

Can you write triggers for a ddl statement?

Have you knowlege on sql server?