SQL DBA Tutorial

SQL Server installation interview Questions and Answers

SQL Server installation interview Questions and Answers

1.What is Database Engine?

2.What are the Network Protocols that SQL Server support?

SQL Server support the following network protocols.

3.What permissions are required for a user install SQL Server on a server?

4.What is SQL Server Instance?

  1. Default instance.
  2. Named instance.

Default Instance:

Named Instance:

5. Can we install multiple instance on the same Disk?

YES,We can install multiple instances on the same disk because each installation create it’s own folders.

6. What is the default port number in SQL Server Instance?


7. What is SQL Server Browser Services Port number.


8.Can we change the default port number of SQL Server?

Yes, We can change the default port number of SQL Server.

9. How to get the SQL Server port numbers?

Below are the methods which we can use to get the port information.

DECLARE @portNumber NVARCHAR(10);
EXEC xp_instance_regread
@rootkey = ‘HKEY_LOCAL_MACHINE’,
@key = ‘Software\Microsoft\Microsoft SQL Server\MSSQLServer\SuperSocketNetLib\Tcp\IpAll’,
@value_name = ‘TcpDynamicPorts’,
@value = @portNumber OUTPUT;
SELECT [Port Number] = @portNumber;

10. What is FILE STREAM?

FILE STREAM was introduced in SQL Server 2008 for the storage and management of unstructured data. The FILESTREAM feature allows storing BLOB data(word document,image file,music etc).

11. How many default SQL Server error log files are generated? 

By default 7 (seven) SQL Server error log files was generated. ERRORLOG and ERRORLOG.1 through ERRORLOG.6. The name of the current log file is ERRORLOG with no extension.The log is re-created every time that you restart SQL Server.When the ERRORLOG file is re-created,the previous log is renamed to ERRORLOG.1, and the next previous log (ERRORLOG.1) is renamed to ERRORLOG.2,and so on. ERRORLOG.6 is deleted. 

12. Is It possible to increase the retention of error log files?

Yes,It is possible to change the number of error logs retention.

13. Is there any possibility to find out the ‘SA’ password from log files?

NO,Clear password not stored at anywhere.

14. What is the Summary.txt file location in SQL Server?

C:\Program Files\Microsoft SQL Server\(90\100\110\120\130)\Setup Bootstrap\Log.

15. What information stored in Summary.txt file?

Installation start and stop time,installed components,machine name,product,version and detailed log file information stored in this file.


Get SQL Dba Tutorial Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to MailChimp ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Exit mobile version