What is difference between index seek vs. Index scan?
What will happen if a column containing char type data is changed to the nchar data type?
What is mean by dml?
What is a transactions?
How will you add a dimension to cube? : sql server analysis services, ssas
What is the difference between commit and rollback?
How to find Duplicate Records In table?
What do you mean by cardinality?
Mention the 3 ways to get a count of the number of records in a table.
Is it important for a database administrator to understand the operating system and file access?
Do you know what is normalization of database? What are its benefits?
What is cdc in sql server?
How to use old values to define new values in update statements in ms sql server?
Is null vs coalesce?
How you can change a cross join into an inner join?