What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Why do we use cursors?
What is dense_rank?
What is a nested table in word?
What is meant by Materialized view?
2 Answers iGate, Marlabs, Polaris,
Explain the insert into statements in sql?
What are pl/sql exceptions? Tell me any three.
What is a temp table?
What is dynamic SQl and how you will create and execute dynamic sql?
What are the different types of joins in sql?
what is the forward decleration in packages?
Explain lock escalation? : Transact sql
Can a view be updated/inserted/deleted?If Yes under what conditions?