How to lock records in a table?
Where is data stored in database?
Enlist the disadvantages of query.
What is rdbms and its types?
What is authorization and integrity manager?
What is the meaning of flat file database?
How to drop all foreign keys in database?
How can you get the alternate records from the table in the sql?
Describe the difference between data and database administration.
Define view, sequence and index in DBMS.
What is father dbms?
What is create database?
What does a database contain?
Explain the syntax of named procedure?
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