⟩ Can a view be updated/inserted/deleted? If Yes - under what conditions?
A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.
A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.
Tell us how do you open a Cluster Administrator?
Tell us what is the difference between a Navigational database and a Relational database?
Do you know what is a primary key?
Do you know what is SQL Server service and its importance?
Tell me what's your process for troubleshooting database problems?
Tell us what are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Tell us on a Windows Server 2003 Active – Passive failover cluster, how do you find the node which is active?
Do you know what is the importance of a recovery model?
Tell us how do you trace the traffic hitting a SQL Server?
Tell me what are the new features in SQL Server 2005 when compared to SQL Server 2000?