Explain what a database is?
what is the use of foreginkey
Who are end users in dbms?
What are triggers? How many triggers you can have on a table?
what is difference between primary key and unique key ?
Explain the cube operator?
Can an extended stored procedure be called from inside a user-defined function?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Explain about xml databases?
what is Normalization?
How to create an external table.
How you can make a parameterized view?
How would you design a database for an online site, which would average a million hits a day?