SQL MCQ Set 1 1. SQL Server 2014 supports up to ________ partitions by default. a) 20000 b) 2000 c) 1000 d) 15000 AnswerAnswer: d [Reason:] In versions earlier than SQL Server 2012, the number of partitions was limited to 1,000 by default. 2. Point out the correct statement : a) On x86-based systems, creating…