MS SQL Server - 5 - Installing SQL Server on Linux MCQ

5 – Installing SQL Server on Linux MCQ

Best of luck!

1 / 25

1. What is the primary operating system supported for installing SQL Server on Linux?

Windows

Ubuntu

Red Hat Enterprise Linux

macOS

2 / 25

2. Which package management system is commonly used for installing SQL Server on Linux?

RPM (Red Hat Package Manager)

YUM (Yellowdog Updater, Modifie

APT (Advanced Package Tool)

Pip (Python Package Installer)

3 / 25

3. Which of the following Linux distributions is NOT officially supported for SQL Server installation?

Fedora

CentOS

Ubuntu

Debian

4 / 25

4. Which command is used to import the Microsoft SQL Server GPG key during SQL Server installation on Linux?

curl

rpm

wget

apt-get

5 / 25

5. What is the minimum RAM requirement for SQL Server on Linux?

4 GB

512 MB

1 GB

2 GB

6 / 25

6. Which SQL Server installation option allows you to install the database engine on Linux?

SQL Server Developer

SQL Server Enterprise

SQL Server Express

SQL Server on Linux

7 / 25

7. Which system library is required for SQL Server on Linux and should be installed before SQL Server installation?

libssl

libxml

libc

libncurses

8 / 25

8. What command should you run after installing SQL Server on Linux to set up the SQL Server service?

sqlserver setup

setup-sql-server

systemctl start mssql-server

systemctl setup mssql-server

9 / 25

9. In SQL Server on Linux, which port is used for communication by default?

5432

8080

1433

3306

10 / 25

10. What is the default authentication mode for SQL Server on Linux?

Mixed Mode

Windows Authentication

Integrated Mode

SQL Server Authentication

11 / 25

11. Which command-line tool can be used to configure and manage SQL Server on Linux?

sqlcmd

mssql-conf

SQL Server Configuration Manager

SQL Server Management Studio (SSMS)

12 / 25

12. What command should you use to enable the SQL Server service to start automatically on system boot?

systemctl start mssql-server

systemctl boot mssql-server

systemctl enable mssql-server

systemctl auto-start mssql-server

13 / 25

13. Which directory is the default location for SQL Server data files on Linux?

/usr/local/mssql/data

/home/sqlserver/data

/etc/sqlserver/data

/var/opt/mssql/data

14 / 25

14. What is the recommended way to uninstall SQL Server on Linux?

There is no official uninstallation method

Delete the installation directory manually

Use the package manager (e.g., yum or apt)

Run a Python script

15 / 25

15. Which command is used to connect to SQL Server on Linux and execute queries from the command line?

linuxsql

mssqldb

sqlconnect

sqlcmd

16 / 25

16. Which Linux utility can you use to check the status of the SQL Server service?

systemctl

sqlstatus

srvctl

service

17 / 25

17. What is the default SQL Server collation on Linux?

SQL_Latin1_General_CP1_CI_AS

Latin1_General_CI_AS

utf8_general_ci

en_US.UTF-8

18 / 25

18. How can you change the SQL Server collation after installation on Linux?

Use the COLLATE clause in queries

It cannot be changed after installation

Reinstall SQL Server with the desired collation

Use the ALTER DATABASE statement

19 / 25

19. Which directory contains SQL Server error logs on Linux?

/etc/sqlserver/logs

/usr/local/mssql/logs

/var/mssql/errors

/var/log/mssql

20 / 25

20. What is the purpose of the mssql-conf utility in SQL Server on Linux?

To configure SQL Server memory settings

To configure system-wide settings for SQL Server

To uninstall SQL Server

To change the SQL Server edition

21 / 25

21. Which Linux command can you use to check the SQL Server version after installation?

mssql-conf –query version

systemctl status mssql-server

sqlserver –version

version sqlserver

22 / 25

22. In SQL Server on Linux, which user is granted administrative privileges during installation?

administrator

sa

sysadmin

root

23 / 25

23. What is the default installation directory for SQL Server on Linux?

/usr/local/mssql

/var/opt/mssql

/etc/sqlserver

/opt/sqlserver

24 / 25

24. Which Linux utility can you use to create and manage SQL Server backups?

sqlbackup

sqlcmd

tar

backupd

25 / 25

25. In SQL Server on Linux, how can you specify a custom data directory during installation?

Create a symbolic link to the desired directory

Use the -d flag with the installation script

Edit the /etc/sqlserver.conf file

You cannot specify a custom data directory during installation

Your score is

0%

MS SQL Server – 5 – Installing SQL Server on Linux MCQ