what is normalization? Explain different levels of normalization? : Sql server database administration
1237what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
1073what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
968what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
894what are user defined datatypes and when you should go for them? : Sql server database administration
974what is the difference between delete table and truncate table commands? : Sql server database administration
982what is the information that can be stored inside a bit column? : Sql server database administration
920
What are the advantages to use stored procedures?
In which sql server version report builder introduced?
Can we store videos inside the sql server table?
Describe the functionalities that views support.
What is the use of tempdb? What values does it hold?
What are the properties of the relational tables?
What are the hotfixes and patches in sql server?
Write SQL queries on Self Join and Inner Join.
Write an sql query to find first weekday of the month?
Define candidate key, alternate key, and composite key.
What is the difference between getdate and sysdatetime?
What is the difference between join and inner join?
What is sql server agent and what are the two modes of authentication in sql server?
Explain how to send email from sql database?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication