Which checkpoints runs just like any other T-SQL statement, once you issue checkpoint command it will run to its completion?

  1. Home
  2. Back

Question:
Which checkpoints runs just like any other T-SQL statement, once you issue checkpoint command it will run to its completion?

1.Automatic

2.Indirect

3.Manual

4.Internal

Posted Date:-2022-02-14 00:42:24

More MCQS Questions and answers

  1. Which of the following is an Advantages of Instances (SQL Server)?
  2. Which of the following statement are true about SQL Server?
  3. Each log record is identified by Log Sequence Number (LSN).
  4. Every database has one primary data file. We can give any extension for the primary data file but the recommended extension is?
  5. How many protocol SQL Server has?
  6. How many types of file groups in SQL Server?
  7. How much maximum file can be there in one database?
  8. In SQL Server 2012 how many types of checkpoints there?
  9. Microsoft SQL Server Initial release on?
  10. MS SQL Server developed by?
  11. MS SQL Server is a ?
  12. Rollback operations are also logged
  13. SQL Server works in client-server architecture, supports how many types of components?
  14. The recommended extension for log file is ?
  15. The size of the page is?
  16. Which checkpoints runs just like any other T-SQL statement, once you issue checkpoint command it will run to its completion?
  17. Which extents are made up of only single object?
  18. Which of the following lies between the host machine (Windows OS) and SQL Server?
  19. Which of the following prepare the execution plan as output by taking query, statistics and Algebrizer tree as input?
  20. Which programming language is used to developed MS SQL?
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!