List of interview questions posted by Bandi- Page 1

311 records found.

Category Interview Questions Title
Sql Server What is the default extended event session to capture Deadlocks? 31-Aug-2017 15346
Sql Server What is the best alternate for SQL Profiler as it is being deprecated in future releases? 31-Aug-2017 15103
Sql Server can we drop versioning enabled tables (Temporal table)? DROP TABLE dbo.TableName 31-Aug-2017 14637
Sql Server Can we mark an existing table as Temporal table? 31-Aug-2017 8003
Sql Server Can we TRUNCATE a Temporal Table? 31-Aug-2017 8792
Sql Server Can we update DATETIME2 columns that are defined as GENERATED ALWAYS ON in Temporal Table? 31-Aug-2017 4279
Sql Server 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)); 31-Aug-2017 4342
Sql Server which of the following clause is used to define DATETIME2 columns in Temporal Table? 31-Aug-2017 3459
Sql Server what are the columns to be defined for Temporal Table? 31-Aug-2017 3629
Sql Server can we create Temporal Table with out Primary Key column? 31-Aug-2017 4265
Sql Server which options makes a SQL table as temporal table in SQL Server 2016? 31-Aug-2017 3252
Sql Server You have below table CREATE TABLE Inventory (ItemID int NOT NULL PRIMARY KEY, ProductsInStore int NOT NULL, ProductsInWarehouse int NOT NULL) How to create a computed column that returns the sum total of the ProductsInStore and ProductsInWarehouse values for each row ? 29-Aug-2017 3161
Sql Server Which Path parameter in the below JSON code snippet would NOT result in an error when used by JSON_VALUE in strict mode? DECLARE @jsonInfo VARCHAR(MAX) SET @jsonInfo = N'{ "info":{ "type":1, "address":{ "town":"Hyd", "state":"TS" "country": "India" }, "tags":["sport", "Water Polo"] }, "type":"Basic" }' 29-Aug-2017 2525
Sql Server In which order should the below clauses be used in the query that works out the count of products within each category by grouping on the category, filtering by categories that contain more than one product and then sorting the results in category order ? 29-Aug-2017 2283
Sql Server The id_num column of the below table is an auto increment column but what do the 2 numbers after the IDENTITY clause mean? CREATE TABLE new_employees ( id_num int IDENTITY(100,10), fname varchar (20), minit char(1), lname varchar(30) ) 29-Aug-2017 2526
Sql Server What is wrong with the below T-SQL batch statement ? @find varchar(30); SET @find = 'ABC'; SELECT LastName FROM Person WHERE LastName = @find; 29-Aug-2017 2610
Sql Server 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, '$') 29-Aug-2017 2777
Sql Server 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? 29-Aug-2017 2768
Sql Server 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 ? 29-Aug-2017 2460
Sql Server which of the following clause is used to return SQL resultset in JSON format in SQL Server2016? 29-Aug-2017 2447

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