Which Of The Following Query Returns Object Names From #839
Which of the following query returns object names from partition IDs?
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 Performance Tuning and Optimization - SQL Server Blocking - Quiz No.1.
Which of the following query returns object names from partition IDs?
SELECT OBJECT_NAME(p.object_id) AS TableName , i.name AS IndexName FROM sys.partition AS p INNER JOIN sys.indexes AS i ON p.object_id = i.object_id AND p.index_id = i.index_id WHERE partition_id = 72057594038845440 SELECT OBJECT_NAME(p.object_id) AS TableName , i.name AS IndexName FROM sys.partitions AS p INNER JOIN sys.indexes AS i ON p.object_id = i.object_id AND p.index_id = i.index_id WHERE partition_id = 72057594038845440 SELECT OBJECT_NAME(p.object_id) AS TableName , i.name AS IndexName FROM sys.partitions AS p INNER JOIN sys.index AS i ON p.object_id = i.object_id AND p.index_id = i.index_id WHERE partition_id = 72057594038845440
None of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116 Microsoft SQL Server
Online Quizzes
