List of interview questions posted by Rajnilari2015- Page 1


376 records found.
 


Category Interview Questions Title
Sql Server What will be the output of --Input Script --Declare a sample table variable DECLARE @tblAssemblyVersion TABLE(Version VARCHAR(20)) --Insert some records to it INSERT INTO @tblAssemblyVersion VALUES ('6.0.0.0'),('3.0.0.0'),('4.5.1.0'),('4.5.8.0'),('4.5.11.0'),('1.1.2.14234'),('1.11.21.14234'),('1.8.2.14234'),('6.0.0.1') SELECT * FROM @tblAssemblyVersion ORDER BY CAST('/'+REPLACE(Version,'.','/')+'/' AS hierarchyID) 20-Mar-2017 3306
Sql Server What will be the output of DECLARE @string VARCHAR(20) = 'Hello how r u?' SELECT STUFF(REPLICATE(',' + LEFT(@string,10),LEN(LEFT(@string,10)) - LEN(REPLACE(LEFT(@string,10), 'o', ''))),1,1,'') 17-Mar-2017 4027
Visual Studio What is Live Unit Testing? 15-Mar-2017 2129
Sql Server What will be the output of the below TSQL Script? DECLARE @t TABLE(Chars VARCHAR(20)) INSERT INTO @T SELECT 'D' UNION ALL SELECT 'N' UNION ALL SELECT 'F' SELECT Chars Data FROM @T FOR XML PATH('') 14-Mar-2017 3636
Sql Server What will be the output of the below TSQL Script? DECLARE @String VARCHAR(MAX) SET @String = 'DNF' ;WITH numberCTE AS ( SELECT 1 AS Rn UNION ALL SELECT Rn+1 FROM numberCTE WHERE Rn<LEN(@String) ) SELECT Characters = SUBSTRING(@String,rn,1) FROM numberCTE 14-Mar-2017 2860
Sql Server What will be the output of the following? DECLARE @String VARCHAR(MAX) DECLARE @Noise TABLE(Noise VARCHAR(100),ReplaceChars VARCHAR(10)) SET @String = 'hello! DNF.!' INSERT INTO @Noise(Noise,ReplaceChars) SELECT '!',SPACE(1) UNION ALL SELECT '@',SPACE(1) UNION ALL SELECT '#',SPACE(1) UNION ALL SELECT '$',SPACE(1) UNION ALL SELECT '%',SPACE(1) UNION ALL SELECT '^',SPACE(1) UNION ALL SELECT '&',SPACE(1) UNION ALL SELECT '*',SPACE(1) UNION ALL SELECT '(',SPACE(1) UNION ALL SELECT ')',SPACE(1) UNION ALL SELECT '{',SPACE(1) UNION ALL SELECT '}',SPACE(1) UNION ALL SELECT '<',SPACE(1) UNION ALL SELECT '>',SPACE(1) UNION ALL SELECT ':',SPACE(1) SELECT @String = REPLACE(@String, Noise, ReplaceChars) FROM @Noise SELECT @String Data 14-Mar-2017 2556
Sql Server What will be the output of the below TSQL Script? DECLARE @Data VARCHAR(MAX) SET @Data = 'hello!DNF.' ;WITH numberCTE AS ( SELECT 1 AS Rn UNION ALL SELECT Rn+1 FROM numberCTE WHERE Rn<LEN(@Data) ) SELECT [Serial Number] = Rn FROM numberCTE 14-Mar-2017 2280
Azure Explain in brief the purpose of ServiceConfiguration.Local.cscfg file 10-Mar-2017 1372
Azure Explain the purpose of ServiceConfiguration.Cloud.cscfg file 10-Mar-2017 1061
Azure What is the purpose of Dataset in Data Factory? 10-Mar-2017 1272
Azure Purpose of Linked Service in Data Factory 10-Mar-2017 898
Azure List out the various Data transformation activities of Data Factory 10-Mar-2017 1037
Azure What is Activity and Pipeline in Data Factory? 10-Mar-2017 1140
Azure Which command of AZCopy will help us to upload multiple files into blob storage 10-Mar-2017 3411
Azure We need to upload a video file into Azure Storage. Which among the below Azure tool utility will help us? 10-Mar-2017 3708
Azure What is Data Factory? Explain the steps for creating a Data Factory 10-Mar-2017 1169
Azure Identify the storage type for JSON in Azure 10-Mar-2017 3570
Others What is the benefit of Unit Testing? 31-Oct-2016 1736
Others What is Arrange-Act-Assert (AAA) phase in Unit testing? 31-Oct-2016 1307
NoSql Write the code for fetching record from Redis using C# 25-Oct-2016 1400

Navigate to page: 1  2 3 4 5 6 7 8 ... 19