What are different types of data models?
What is alternate key?
What are the features of rdbms?
What is the role of database server in database management system?
when All datafiles related to a Tablespace are removed ?
What is artificial key?
Enlist various transaction phases.
What is a string in database?
what are the acid properties in dbms?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping
What is 'cross join'? Or what is cartesian product?
What is database implementation?
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
Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.
What are the key constraints in dbms?