Interview Questions Part-15

A common interview Question that confuses many Mid Level DBA's to answer 1) Is Seek better than scan? 2) What is selectivity? 3) Will there be any Data loss if we drop clustered or non clustered index? 4) What is minimal logging? 5) How to make use of tablock hint to reduce the log file usage from 235 GB to 1.2 GB? 6)What happens if we use of maintenance plans for Always On Databases with all defaults? 7) How to generate backup files on primary with backup preference being set to secondary by using maintenance plans?