MS SQL Server - 6 - Installing SQL Server on Windows MCQ

6 – Installing SQL Server on Windows MCQ

Best of luck!

1 / 25

1. What is the minimum Windows version required to install SQL Server 2019?

Windows 8

Windows 10

Windows Server 2016

Windows Server 2012

2 / 25

2. Which of the following editions of SQL Server is NOT available for installation on Windows?

SQL Server Express Edition

SQL Server Community Edition

SQL Server Developer Edition

SQL Server Enterprise Edition

3 / 25

3. Which component of SQL Server allows you to install and manage SQL Server instances on Windows?

SQL Server Configuration Manager

SQL Server Profiler

SQL Server Management Studio (SSMS)

SQL Server Data Tools (SSDT)

4 / 25

4. What is the primary installation option for SQL Server on Windows that includes the Database Engine and SQL Server Management Studio?

Basic

Custom

Complete

Express

5 / 25

5. During the installation of SQL Server on Windows, which service account type is recommended for running SQL Server services?

Local System Account

Virtual Account

User Account

Managed Service Account (MS

6 / 25

6. Which installation option allows you to specify which SQL Server components to install on Windows?

Complete

Express

Custom

Basic

7 / 25

7. What is the default instance name for SQL Server when installing on Windows?

SQLEXPRESS

MSSQLSERVER

SQLServer

DEFAULTINSTANCE

8 / 25

8. Which SQL Server installation component provides a graphical interface for managing SQL Server instances and databases on Windows?

SQL Server Data Tools (SSDT)

SQL Server Profiler

SQL Server Management Studio (SSMS)

SQL Server Configuration Manager

9 / 25

9. What is the primary port used for SQL Server communication on Windows?

3306

80

5432

1433

10 / 25

10. Which SQL Server authentication mode on Windows allows users to log in using Windows accounts?

Mixed Mode Authentication

SQL Server Authentication

Windows Authentication

Integrated Mode Authentication

11 / 25

11. During SQL Server installation on Windows, which feature allows you to configure SQL Server instance settings?

SQL Server Management Studio (SSMS)

SQL Server Configuration Manager

SQL Server Data Tools (SSDT)

SQL Server Profiler

12 / 25

12. Which Windows utility can you use to enable or disable Windows Firewall rules for SQL Server?

Windows Defender

Windows Security Center

Windows Firewall Control Panel

Task Manager

13 / 25

13. In SQL Server installation on Windows, what is the purpose of the “Instance ID” parameter?

It configures the firewall settings.

It identifies the installation instance.

It defines the SQL Server collation.

It specifies the port number.

14 / 25

14. During SQL Server installation on Windows, which option allows you to specify the SQL Server collation?

Database Engine Configuration

Server Configuration

Authentication Mode

Instance Configuration

15 / 25

15. Which command can you use to check the version of the installed SQL Server instance on Windows?

sqlcheck

sqlinfo

sqlcmd -v

sqlversion

16 / 25

16. In SQL Server installation on Windows, which role is granted administrative privileges by default?

Administrator

DBA (Database Administrator)

Power User

sa (System Administrator)

17 / 25

17. What is the default installation directory for SQL Server on Windows?

C:Program FilesMicrosoft SQL Server

C:WindowsSystem32

C:Program Files

C:SQLServer

18 / 25

18. During SQL Server installation on Windows, which option allows you to specify the installation location?

Feature Selection

Instance Configuration

Installation Rules

Server Configuration

19 / 25

19. What is the purpose of the SQL Server Browser service in Windows?

It helps locate SQL Server instances on the network.

It manages database backups.

It generates query execution plans.

It provides access to SQL Server error logs.

20 / 25

20. In SQL Server installation on Windows, which component allows you to install additional features and tools?

Feature Selection

Instance Configuration

Authentication Mode

Server Configuration

21 / 25

21. Which Windows utility can be used to stop and start SQL Server services?

Windows Services Manager

SQL Server Management Studio (SSMS)

SQL Server Configuration Manager

Task Manager

22 / 25

22. In SQL Server installation on Windows, what is the purpose of the “Shared Features Directory”?

It stores user data.

It contains shared components for SQL Server.

It configures instance settings.

It manages backups.

23 / 25

23. Which Windows utility is used to create and manage scheduled tasks for SQL Server, such as backups and maintenance plans?

SQL Server Data Tools (SSDT)

Windows Task Scheduler

SQL Server Configuration Manager

Windows Services Manager

24 / 25

24. What is the purpose of the “Error and Usage Reporting” feature during SQL Server installation on Windows?

It enables automatic error reporting to Microsoft.

It installs additional error-checking tools.

It provides usage statistics to Microsoft.

It configures error log settings.

25 / 25

25. In SQL Server installation on Windows, which feature allows you to install additional language packs?

Authentication Mode

Feature Selection

Instance Configuration

Server Configuration

Your score is

0%

MS SQL Server – 6 – Installing SQL Server on Windows MCQ