IBM Interview Question

Q. What is TUF(Transaction undo file)? Q.AAG - inner concepts Q. Azure sql db vs azure sql managed instance scenario-based: Q. Fix High CPU Q. unable to log in forthe user and has all the required permissions Q. DB went to suspect state ? Q. Tempdb collation - we use CMD to connect to the server Q Best recommendations for tempdb Q. Give me some DMV lists and uses? Q Definition - clustered index - wrong Q. What is a Heap index - No clustered index and few non-CI. Q. How do you fix a slow database issue? Jobs are running slower than expected Q. log shipping - Def. Q. Logspace issue - shrink, take a backup, create a new log file for a temporary purpose, go to properties, and increase the size. Q. Failover types Q. Synchronous and Asynchronous commit in AAG. Q. Performance tuning for an long-running query Q. Lazy writer and checkpoint Q. Fix -Orphan user Q. TDE?(Transparent data encryption) Q. What is are difference between any two SQL servers (From 2016 to 2019 or 2019 to 2022)