1)Procedure to resolve login issues??
2)Automatic failover is not supported in??
a)mirroring)Clustering
c)Log Shipping
3)Repair option work in DBCC checkDB/DBCC CHECKTABLE kept only for backward component
1)repair fast
2)repair build
3)repair allow
4)repair loss
4)To know latest SP installed. Commane
a)@@version
2)@@Servicepack
5)Sysytem table allocated in :
1)Primary file group
2)Secondary filegroyp
6)Details of db?
a)sp_helpdb
b)xp_helpdatabase
c)sp_help
7)db not used in sql server?
a)db owner
b)db accessadmin
c)db security admin
8)which of the following supports replica in sql server2008 and later version?
a)mirror to
b)copy t0
c)move to
9)Best tool used to change the login account details of the user realetd tpo SQL??