Transactional log Questions for Interviews

1. What is a transactional log file?
2. Transactional log is an Audit log?
3. Transactioanl log is an Data recovery tool?
4. Is there any third party tools that can get audit or data recovery info from the log?
5. The transactional log is mainly used by?
6. How does SQL uses the log ?
7. What is Inactive transaction?
8. Inactive transactions are necessary for database recovery?
9. What is Write - Ahead log?
10. How many transactional log files you can create in single database ?
11. What is minimum and maximum size of transactional log file ?
12. Is it possible to create a database without transactional log file ?
13. I have a scenario in which a volume is having file system compression and in that I have data and log files resides. Now SQL Server will support ?
14. When you create a database by using T-SQL and SSMS what is the default size of transactional log file?
15. How many transactional log files can create in single database?
16. What is the extension of transactional log file ?
17. what is the use of transactional log file ?
18. Which statement tells SQL Server to rollback a transaction in case of a power failure?
19. The transactional log file is logically divided in to smaller segments that are referred to as ?
20. What is the meaning of truncating a transactional log file ?
21. After truncating a transactional log file it will decrease the size of ldf file ?
22. If transactional log is full what to do ?
23. Sometimes SQL Server wont allow you to do log back when transactional log is full what to do ?
24. When transactional log is full why SQL server wont allow to take log back up?
25. If a transactional log is deleted how can you restore the database through T-SQL ?
26. A log file can be part of a filegroup?
27. VLFs has a fixed size ?
28. Is it possible to fix the number of VLFs in a transactional log ?
29. The size and number of VLFs is configurable ?
30. SQL Server determines the size of VLFs dynamically or statically ?
31. Why transactional log is not being truncated ? give me two reasons ?
32. Which trace flag is used to continuity of the log is not broken ?
33. Error 9002 indicates what ?
34. To find out why space in the log cannot be reused which table we need to check?
35. Why the transactional log space cannot be reused?
36. After you manually truncate the transactional log file what you need to do?
37. The Backup operation or Truncate method will reduce the log size?
38. To Reduce the transactional log file size what you need to do?
39. The DBCC SHRINK FILE T-SQL statement can only shrink the transactional log ?
40. The DBCC SHRINK FILE T-SQL statement can truncate the log ?
41. After running SHRINK FILE command the target size specified by you is not decreased what sql server will do ?
42. What are the actions required to shrink the transactional log file at a target size specified by you?
43. When you run DBCC SHRINK FILE ('logical log file name',2) here 2 indicates what ?
44. Which permission is required to perform DBCC SHRINK FILE or DBCC SHRINK DATABASE
45. If you can't able to shrink the log, it might be due to an?
46. which is the command is used to see running transactions ?
47. which command is used to see the virtual log files in a transactional log ?
48. SQL Server how determines the size of VLFs?

Hi I will post some more questions on transactional log file. It will be updated daily.