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 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

Comments

  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

Contact Form

Send