What are the differences between a dbms and rdbms?
What do you understand by sub-queries in sql?
What are cursors give different types of cursors?
Is database a storage?
Define primary and unique key?
What is the first step in creating a database?
How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?
1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD
What is database optimization?
What are the different types of keys in database?
What is the use of GRANT option in EXP command ?
Which is fastest database?
Which is the most used database?