1. What is ER diagrams and its different notations.
2. Which data model using in your project.
3. Decode statement and how to use to compare the range of values and its syntax.
4. What are derived tables and derived variables
5. What is data transformation
6. What is DDL and DML
7. What are joins and different types of joins.
8. How to combine 2 resultsets into a single table using aliases
9. What is aliases?
10. What is coalesce, LEFT and RIGHT functions?
11. What are the different string functions?
12. What is trigger?
13. What is normalization and its different normal forms and explain.
14. How to configure toad, SQLserver
15. Is it possible to load tables from flat files?
16. What is ranking?
17. Difference between TRUNC and DELETE?
18. What is GROUP BY clause
19. Write a query to interchange row values as columns and columns as Row values.
No comments:
Post a Comment