Differentiate between delete and truncate table?
What is redis good for?
Explain buffer manager?
Explain file manager?
How many indexes can be created on a table?
What are the advantages of using database?
What is a Transformation?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
What are different types of resources?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
What is odm database?
What are the advantages of normalizing a database.
What is the difference between data source and database?
Explain data independence & its types.
What is the Lock Based Protocol used for?