Define join types.
What is a Database Schema and Why is It Important?
When does checkpoint occur?
define aggregate functions.
What are the different types of DBMS architecture?
What do you mean by e-r model?
How to use multiple database server in back end ?
What are partitions in database?
What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?
What is the concept of sub-query in terms of sql?
What are notification services?
What do you understand by ‘atomicity’ and ‘aggregation’?
user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?