HCL 23 SQL Server DBA Interview Question : Real Time Interview Questions

Hey DBA this time we come with SQL Server Interview Questions asked during HCL SQL Server DBA interview. Me and my friends collecting lates...

Hey DBA this time we come with SQL Server Interview Questions asked during HCL SQL Server DBA interview. Me and my friends collecting latest interview questions by attending Interview in famous companies, I am collecting questions from my friends and some time I attend interview to collect questions.
Before that I have posted TCS SQL Server Interview questions, After posting that set we are getting lots of email to post questions related to different MNC. So this time we come with HCL Real Interview questions 


HCL SQL SERVER DBA INTERVIEW QUESTIONS 
(interview attended 3rd Feb 2017)

1). What is @@ERROR? (click on the questions to see answer)

2). What is a linked server?

3). Will Non-Clustered Index used every time by SQL Server Engine? (HCL/Unitedhealth Group)

4). What are different part of a SQL Page?

5). What are the types of database recovery models?

6). What are different types of Collation Sensitivity?

7). What are the disadvantages of using Stored Procedure?

8). Can we call Stored Procedure in a View?

9). What is FILL Factor?

10). How Fixed Length and Variable Length Data types affect performance in Sql server Explain with example?

11). What would be the output of the following script?
SELECT NULL + 5

12). What do you understand by index_id = 0 and Index_id = 1, related to sys.indexes table? What they represent?

13). Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?

14).What would be the output of following query?


15). What is forwarding pointer in SQL Server? How it is helpful in performance optimization?

16). What would be the output of the following script?
SELECT COUNT(*)

17). How do you optimize Stored Procedures?

18). What would be the output of the following script?
    DECLARE @Name VARCHAR(20)
    SET @Name = 'विकास अहलावत'
20). What would be the output of the following query?

21). What Execute in SQL Server First?
A) WHERE
B) SELECT
C) ON
D) FROM
E) TOP

22). Sql server difference between session and connection?

23). Suppose you have following table"TestUpdate".
SELECT * FROM Testupdate

What would be the output of following query?
UPDATE Testupdate SET ID = ID + (SELECT MAX(ID) FROM Testupdate)
SELECT * FROM Testupdate


24). Repeat Rows N Times According to Column Value in SQL Server?
http://www.interviewquestionspdf.com/2017/07/repeat-rows-n-times-according-to-column.html?showComment=1499235700297#c6626106274787159478

Related

SQL SERVER INTERVIEW QUESTIONS 531222399505582048

Post a comment

  1. Great Collection for interview questions. Want to learn how to drop all tables?

    ReplyDelete
  2. Can you plz share with me pdf?Wonderful collection to learn

    ReplyDelete

emo-but-icon

Follow Us

Recent

Comments

Donate

Side Ads

Text Widget

Connect Us

Sql Server 2017 Interview Questions
Sql Server Basic Interview Query Set-1
Sql Server Basic Interview Query Set-2
Sql Server Date-Time Interview Query SET-3
Sql Server Salary Interview Query SET-4
Sql Server Group By Interview Query SET-5
Sql Server Join Interview Query SET-6
Sql Server Tricky Join Interview Query SET-7
Sql Server DDL Interview Query SET-8
Small but very Tricky Sql Server Query SET-9
Very Much Tricky Query (not 4 fresher)SET-10
Sql Server Complex Interview Query SET-11
Sql Server Datatype Interview Questions
Sql Server View Interview Questions
Sql Server Index Interview Questions
TCS Tricky Sql Interview Queries
HCL Sql Interview Queries
Sql Server SP Interview Questions
Sql Server Trigger Interview Questions
Sql Server Temp Table Interview Questions
Sql Server 2016 Interview Questions
Sql Server Performance Tuning Interview Q.
Sql Server Constraints Interview Questions
Sql Server Storage/Size Interview Questions
Sql Server Very Basic Interview Questions
Sql Server Quiz for Fresher
Sql Server Icon Quiz for All
Sql Server 300+ Theoretical Interview Questions
Sql Server Complete Set

ASP.NET AND JQUERY INTERVIEW QUESTION
ASP.NET: Web Config Interview Question
ASP.NET: View State Interview Question
ASP.NET: Session Interview Question
ASP.NET: Session Interview Question 
ASP.NET: Security Interview Question
ASP.NET: Catching Interview Question
C# OOPS Interview Question
MORE Interview Question
JQUERY: Interview Question Set-1
JQUERY: Interview Question Set-2
JAVA-SCRIPT: Interview Question Set-1
JAVA-SCRIPT: Interview Question Set-2
ASP.NET MVC: Interview Question Set-1

POPULAR POSTS
10 MOST DIFFICULT INTERVIEW QUESTIONS
5 BEST INTERVIEW TIPS
YOUR 10 MISTAKE DURING INTERVIEW
2016 TOP 20 GROUP DISCUSSION TOPICS
HOW SQL PERFORMANCE AFFECTED BY DATATYPE
item