MS SQL Server Databases

@T-Bone

This question paper focuses on the "MS SQL Server" of Databases. These Multiple Choice Questions (mcq) should be practiced to improve the Databases skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

This question paper focuses on the "MS SQL Server" of Databases. These Multiple Choice Questions (mcq) should be practiced to improve the Databases skills required for various interviews (campus interview, walk-in interview, company interview), placement, entrance exam and other competitive examinations.

Questions

1. MS SQL Server is a ?

Mark the correct option

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

Mark the correct option

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

Mark the correct option

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

Mark the correct option

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

Mark the correct option

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

Mark the correct option

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

Mark the correct option

8. The size of the page is?

Mark the correct option

9. Rollback operations are also logged

Mark the correct option

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

Mark the correct option

11. MS SQL Server developed by?

Mark the correct option

12. Microsoft SQL Server Initial release on?

Mark the correct option

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

Mark the correct option

14. How many protocol SQL Server has?

Mark the correct option

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

Mark the correct option

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

Mark the correct option

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

Mark the correct option

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

Mark the correct option

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

Mark the correct option

20. The recommended extension for log file is ?

Mark the correct option

Index of Questions