MS SQL Server Databases

Questions

1. MS SQL Server is a ?

2. Which of the following statement are true about SQL Server?

3. Which programming language is used to developed MS SQL?

4. SQL Server works in client-server architecture, supports how many types of components?

5. Which of the following lies between the host machine (Windows OS) and SQL Server?

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

7. How much maximum file can be there in one database?

8. The size of the page is?

9. Rollback operations are also logged

10. How many types of file groups in SQL Server?

11. MS SQL Server developed by?

12. Microsoft SQL Server Initial release on?

13. Which of the following is an Advantages of Instances (SQL Server)?

14. How many protocol SQL Server has?

15. In SQL Server 2012 how many types of checkpoints there?

16. Every database has one primary data file. We can give any extension for the primary data file but the recommended extension is?

17. Which extents are made up of only single object?

18. Each log record is identified by Log Sequence Number (LSN).

19. Which of the following prepare the execution plan as output by taking query, statistics and Algebrizer tree as input?

20. The recommended extension for log file is ?

Index of Questions