L&T Interview by Vinay on 24th May 2022

1) How move database files to another location in SQL server Always ON Availability groups?
2) Database is in Simple recovery mode, is it possible replication to configure?
3) Business owner required truncate permission in replication?
4) Migration in cluster environment with 2 nodes
5) Application is running slowness for last 3 days? without Blocking, Deadlock and long running queries
6) Tempdb segregation?(N-1)
7) Full backup @ Every 6 hour and log backup every 1 hour, Database crash @ 4:15 PM, But user has
done some modifications @3:30 PM, he is need to up to 3:30 PM data
8) How to restore database by using Full back up into other server?
9) There is no SQL SMSS, How to identify SQL server version?