1. What is the diff between Exist and In Operator?
2. What is the Diff between Delete and Truncate and Drop?
3. Can we drop the table if table is having the data?
4. I have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
5. I have executed the Delete command after the I have created table whether deletions will be commit or not? if table is not created?
6. What is RowID? When it will be created? What is the format? What is the diff between RowID and Rownum?
7. Can we use RowID in the where clause? if Yes can we use like follows
8. Where RowID = 12;
9. What is Decode operator and what is the syntax when u have used in Oracle Apps?
10. What is NVL operator and what is the syntax when u have used in Oracle Apps?
11. What is Join and types of Joins and what is Outer Join?
12. What is Set operator and what are the types what is the diff between Set operators and Joins?
13. What is View? What is the advantage? What are the types of views we have?
14. When we can not update the view?
15. What is Materialized view and what is Snap shot?
16. What is the diff between Materialized view and Snap shot?
17. What are the Inline views?
18. What is synonym and what are the types and what is the advantage?
19. What is Index? Advantege of Index? Types of Indexes?
20. What are the Bit mapped Index? Advantage?
21. What is sub-query and what is Co-Related Sub Query and diff between those two?
22. What is the syntax for To Date function?
23. What is diff between Replace and Translate?
24. What are the Pseudo columns we have?
25. How to execute DOS Commands from SQL Prompt?
26. How can we find out no of Indexes we have created against a Table?
27. How to get second max salary from the table?
28. How to delete duplicate rows from the table?
29. What is where clause?
30. What is having clause and what is the diff between these two clauses?
31. How to handle the table level locks and column level locks?
32. What are the constraints we have and how to declare?
33. What is the diff between primary key and Unique?
34. Can we compare two Null values? Can we insert more than one null value in the unique column?
35. How to handle null values?
36. What are CBO and RBO? What is the diff between these two?
37. What are the performing tuning levels?
38. What is Explain plan and what is tkproff?
39. How can u tune the query?
No comments:
Post a Comment