SQL Interview Questions and Answers for Freshers - 2

Question: 6

Which TCP/IP port does SQL Server run on?

SQL Server runs on port 1433 but we can also change it for better security.

Question: 7

What do you mean by COLLATION?

Collation is basically the sort order. There are three types of sort order Dictionary case sensitive, Dictionary – case insensitive and binary.

Question: 8

Can you explain the role of each service?

SQL SERVER – is for running the databases

SQL AGENT – is for automation such as Jobs, DB Maintenance, Backups

DTC-Is for linking and connecting to other SQL Servers.

Question: 9

What are cursors?

Well cursors help us to do an operation on a set of data that we retrieve by commands such as Select columns from table.

For example: if we have duplicate records in a table we can remove it by declaring a cursor which would check the records during retrieval one by one and remove rows which have duplicate values.

Question: 10

What are the three types of session state modes?

Inproc-session kept as live object in the web server(aspnet_wp.exe)

State server-session serialized and stored in memory in a separate process (aspnet_state.exe), we can use for web form architecture.

SQL Server-Session serialized and stored in SQL server.