SQL Interview Questions and Answers for Freshers - 1

Question: 1

When do you use SQL Profiler?

SQL Profiler utility allows us to basically track connections to the SQL Server and also determine activities such as which SQL Scripts are running, failed jobs etc.

Question: 2

What is a Join in SQL Server?

Join actually puts data from two or more tables into a single result set.

Question: 3

What are the types of indexes available with SQL Server?

There are basically two types of indexes that we use with the SQL Server.

Clustered and

The Non-Clustered.

Question: 4

What is an Index?

When queries are run against a db, an index on that db basically helps in the way the data is sorted to process the query for faster and data retrievals are much faster when we have an index.

Question: 5

What is a stored procedure?

It is nothing but a set of T-SQL statements combined to perform a single task of several tasks.

It is basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.