Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1516
Home > Interviews > Sql Server

Sql Server Interview Questions and Answers (1758) - Page 81

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

1758 records found.

Post | Interview Experiences | Interview FAQs | Online Interviews | Exclusive Questions

Get 650+ Questpond's Interview videos on discount

What is LAG function in DENALI?

NOTE: This is objective type question, Please click question title for correct answer.
What is true about the First_Value function in DENALI?

NOTE: This is objective type question, Please click question title for correct answer.
Explain the syntax First_Value(expression [IGNORE NULLS]) Over( [ Partition_By_clause] order by clause [rows_range_clause])

Expression => A table column or built-in function but not analytical functions.

Rows_range_clause => It helps to further limit the effect of analytical function.

If the first value in the set is null, then the function returns null until we specify IGNORE NULLS.

However, if we specify IGNORE NULLS,then First_Value function returns the first non-nullable value else it returns all null values.
What is First_Value function in DENALI?

NOTE: This is objective type question, Please click question title for correct answer.
What is Last_Value function?

NOTE: This is objective type question, Please click question title for correct answer.
What is/are true about the Last_Value function in DENALI?

NOTE: This is objective type question, Please click question title for correct answer.
What is Percent_Rank function?

NOTE: This is objective type question, Please click question title for correct answer.
What is the formula upon which the Percent_Rank function works?

NOTE: This is objective type question, Please click question title for correct answer.
What is the range of values return by Percent_Rank function?

NOTE: This is objective type question, Please click question title for correct answer.
What is Cume_Dist function?

NOTE: This is objective type question, Please click question title for correct answer.
What is the formula for Cume_Dist function?

NOTE: This is objective type question, Please click question title for correct answer.
Suppose we have a set with 35 elements. We need to find the cumulative distribution of the 17th row. What will be the value?

NOTE: This is objective type question, Please click question title for correct answer.
Suppose we have a set with 39 elements. We need to find the relative rank of the 9th row. What will be the value of Percent_Rank function?

NOTE: This is objective type question, Please click question title for correct answer.
What is true about Percentile_Cont function?

NOTE: This is objective type question, Please click question title for correct answer.
What will be the output of Declare @str Varchar(1000) = 'http://www.dotnetfunda.com/articles/show/3158/import-xml-file-and-transform-into-relational-model-for-dynamic-column' SELECT LEFT(SUBSTRING(@str, PATINDEX('%[0-9]%', @str), LEN(@str)),PATINDEX('%[^0-9]%', SUBSTRING(@str, PATINDEX('%[0-9]%', @str), LEN(@str)) + 'v')-1) ?

NOTE: This is objective type question, Please click question title for correct answer.
What will be the output of the below CREATE TABLE [dbo].[tblLocation]( [LocationID] [int] IDENTITY(1,1) NOT NULL, [Latitude] [varchar](100) NOT NULL, [Longitude] [varchar](100) NOT NULL) GO SELECT COL_NAME(OBJECT_ID('tblLocation'),2) AS COLUMN_NAME ; GO DROP TABLE [dbo].[tblLocation]

NOTE: This is objective type question, Please click question title for correct answer.
What will be the output of the below CREATE TABLE [dbo].[tblLocation]( [LocationID] [int] IDENTITY(1,1) NOT NULL, [Latitude] [varchar](100) NOT NULL, [Longitude] [varchar](100) NOT NULL) GO SELECT COL_NAME(OBJECT_ID('tblLocation'),2) AS COLUMN_NAME ; GO DROP TABLE [dbo].[tblLocation]

NOTE: This is objective type question, Please click question title for correct answer.
What will be the output of SELECT PARSENAME('Dotnet.Funda.nice.forum',4)

NOTE: This is objective type question, Please click question title for correct answer.
What will be the output of SELECT PARSENAME('Dotnet.Funda.nice.forum',3)

NOTE: This is objective type question, Please click question title for correct answer.
What will be the output of SELECT PARSENAME('Dotnet.Funda.nice.forum',2)

NOTE: This is objective type question, Please click question title for correct answer.
More SQL SERVER Exclusive Interview Questions & Answers here
Found this useful, bookmark this page to the blog or social networking websites. Page copy protected against web site content infringement by Copyscape
Bookmark It

 Interview Questions and Answers Categories

.NET Certifications
.NET Core
.NET Framework
ADO.NET
AI ML
Android
Angular
AngularJS 1x
Aptitute Test
ASP.NET
ASP.NET AJAX
ASP.NET Core
ASP.NET MVC
ASP.NET Web API
Aurelia
Azure
Best Practices
BizTalk Server
Bootstrap
C#
Cloud
CMS
CSS 3
Data Structures & Algorithms
Design Pattern & Practices
DotNetFunda.Com
Entity Framework
Error and Solution
F#
Function Points (FPA)
HR
HTML 5
IIS
Interview Questions
JavaScript
jQuery
Kinect
LightSwitch
LINQ
Management
Mobile Development
MSBI (SSIS, SSRS, SSAS)
Mule
Networking
News and Community
Node.js
NoSql
OOPS
Oracle
Others
PostgreSQL
PowerShell
Product Reviews
Project Management
Python
QA (Testing)
R Language
Regular Expressions
SEO
SharePoint
SignalR
Silverlight
Sql Server
TypeScript
UML
VB.NET
Visual Studio
WCF
Web Analytics
Web Services, Remoting
Windows 8
Windows Forms
Windows Metro
Windows Phone
WPF
WWF
XML