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

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

Here is the JSON string DECLARE @jsonInfo VARCHAR(MAX) SET @jsonInfo = N'{ "info":{ "type":1, "address":{ "town":"Hyd", "state":"TS" "country": "India" }, "tags":["sport", "Water Polo"] }, "type":"Basic" }' what is the output of below query ? JSON_QUERY(jsonString, '$.info.address.town')

NOTE: This is objective type question, Please click question title for correct answer.

The table includes a DATETIME column named EventTime that stores the date and time of each Event. There is a non-clustered index on the EventTime column. To create a report that displays the total number of events happened on the current day, You need to write a query that will return the correct results in the most efficient manner. Which T-SQL query should you use?

NOTE: This is objective type question, Please click question title for correct answer.

which inbuilt function can be used to know the id value of the last row that was inserted, rather than re-run another query just to get the maximum id value ?

NOTE: This is objective type question, Please click question title for correct answer.

which of the following clause is used to return SQL resultset in JSON format in SQL Server2016?

NOTE: This is objective type question, Please click question title for correct answer.

what is the alternate option to maintain log/history tables in SQL Server 2016?

NOTE: This is objective type question, Please click question title for correct answer.

Which of the following tool is used to identify rules and patterns in the company data and determine why things happen and predict what will happen in the future?

NOTE: This is objective type question, Please click question title for correct answer.

which of the following SQL statement is used to remove a log file called logfile1 from a database called DB1?

NOTE: This is objective type question, Please click question title for correct answer.

which options makes a SQL table as temporal table in SQL Server 2016?

NOTE: This is objective type question, Please click question title for correct answer.

can we create Temporal Table with out Primary Key column?

NOTE: This is objective type question, Please click question title for correct answer.

what are the columns to be defined for Temporal Table?

NOTE: This is objective type question, Please click question title for correct answer.

which of the following clause is used to define DATETIME2 columns in Temporal Table?

NOTE: This is objective type question, Please click question title for correct answer.

What happens if you define DATETIME2 columns as Nullable in Temporal table ? CREATE TABLE Employee ( [EmployeeID] int NOT NULL PRIMARY KEY CLUSTERED , [Name] nvarchar(100) NOT NULL , [ValidFrom] datetime2 (2) GENERATED ALWAYS AS ROW START NULL , [ValidTo] datetime2 (2) GENERATED ALWAYS AS ROW END , PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo) ) WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.EmployeeHistory));

NOTE: This is objective type question, Please click question title for correct answer.

Can we update DATETIME2 columns that are defined as GENERATED ALWAYS ON in Temporal Table?

NOTE: This is objective type question, Please click question title for correct answer.

Can we TRUNCATE a Temporal Table?

NOTE: This is objective type question, Please click question title for correct answer.

Can we mark an existing table as Temporal table?

NOTE: This is objective type question, Please click question title for correct answer.

can we drop versioning enabled tables (Temporal table)? DROP TABLE dbo.TableName

NOTE: This is objective type question, Please click question title for correct answer.

What is the best alternate for SQL Profiler as it is being deprecated in future releases?

NOTE: This is objective type question, Please click question title for correct answer.

What is the default extended event session to capture Deadlocks?

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.

Bookmark It

Interview Questions and Answers Categories

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

MSBI (SSIS, SSRS, SSAS)

Web Services, Remoting