This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Working With XML Data – 1”. 1. Which of the reasons will force you to use XML data model in SQL Server? a) Your data is sparse or you do not know the structure of the data b) Your data represents containment … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Hierarchies”. 1. Which of the following code snippet insert the top level manager ‘Jeff Brown’ as hierarchy root? a) INSERT INTO Employees VALUES (1, ‘Jeff Brown’, NULL, hierarchyid::Root()); b) INSERT INTO Employees VALUES (1, ‘Jeff Brown’, NULL, hierarchyid::GET()); c) INSERT INTO Employees … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Constraints”. 1. Which of the following is not a class of constraint in SQL Server? a) NOT NULL b) CHECK c) NULL d) UNIQUE 2. Point out the correct statement. a) CHECK constraints enforce domain integrity b) UNIQUE constraints enforce the uniqueness … Read more
This set of SQL Server Questions and Answers for experienced people focuses on “Modifying Data – 2”. 1. The EXISTS keyword will be true if ____________ a) Any row in the subquery meets the condition only b) All rows in the subquery fail the condition only c) Both of these two conditions are met d) … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Modifying Data – 1”. 1. The query given below will give an error. Which one of the following has to be replaced to get the desired output? SELECT ID, name FROM 1_Order WHERE instructor=1; a) _Order b) 2Order c) 3Order d) Instructor … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Subqueries”. 1. Select __________ from instructor where dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary? a) Mean(salary) b) Avg(salary) c) Sum(salary) d) Count(salary) 2. The ________ connective tests for set membership, where … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Ranking”. 1. Which of the following is not a ranking function? a) RANK b) NTILE c) ROW_NUMBER d) All of the mentioned 2. Point out the wrong statement. a) The ROW_NUMBER function simply assigns sequential numbering to the records of a result-set … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Windowing”. 1. Which of the following is a set function? a) RANK b) NTILE c) Window d) All of the mentioned 2. Point out the correct statement. a) Windowing functions were added to the standard SQL:2003 b) Windowing functions were added to … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Powershell”. 1. Which of the following command is used to get child items in powershell? a) Get-Child b) Set-Alias c) Get-Command d) Get-ChildItem 2. Point out the wrong statement. a) Get-Command retrieve basic information about a command b) Trace-Command trace an expression … Read more
This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Aggregation of Data”. 1. Aggregate functions are functions that take a ___________ as input and return a single value. a) Collection of values b) Single value c) Double value d) All of the mentioned 2. SQL applies predicates in the _______ clause … Read more
