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
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?
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?
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?
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?
Great Collection for interview questions. Want to learn how to drop all tables?
ReplyDeleteCan you plz share with me pdf?Wonderful collection to learn
ReplyDelete