HCL PUNE PL/SQL Interview Questions

Tell me about your self?

11g features?

What are the issues you faced in using Cursors?

What is varry and nested tables?

How the query executed??

Write a query to display even/odd number from a table.?

What is the exception?explain raise_application error?

write a syntax for pivot function?

what is correlated sub query.?

Write syntax to procedure?

When you use function and procedure?

Disadvantage of triggers.?

Diff %type and %row type.?

What cascade constrains.?

What is partitions?

What is cluster index?