Search test library by skills or roles
⌘ K

Adaface Sample MS SQL Questions

Here are some sample MS SQL questions from our premium questions library (10273 non-googleable questions).

Skills

🧐 Question

Medium

MS SQL: enterpriseDB, GROUP BY
Solve
                                    The following T-SQL statements are run on enterpriseDB database:
                                    
 image
                                    uamMembers with MemberPaid as 1 implies that the member payment is complete. We want to find number of paid users for each uamGroup. (If a uamGroup does not have any paid members, we want to have 0 as paid members count). Of the following T-SQL statements, what should we run to achieve this?
                                    
 image

Options:

  • A
  • B
  • C
  • D

Medium

MS SQL: Most recurring errors
Solve
                                    Check out following MS SQL tables:
                                    
 image
                                    We have a status monitoring page to display most recurring errors for each user. Here's the T-SQL statement to achieve this:
                                    
 image
                                    How would you fill the empty blocks to finish the T-SQL statement from following options?
                                    
 image

Options:

  • A - I, B - III, C - VI
  • A - I, B - III, C - VII
  • A - I, B - IV, C - VII
  • A - I, B - V, C - VI
  • A - I, B - IV, C - VI
  • A - I, B - V, C - VII
  • A - II, B - III, C - VI
  • A - II, B - III, C - VII
  • A - II, B - IV, C - VI
  • A - II, B - IV, C - VII
  • A - II, B - V, C - VI
  • A - II, B - V, C - VII
🧐 Question🔧 Skill

Medium

MS SQL: enterpriseDB, GROUP BY
4 mins
MS SQL
Solve

Medium

MS SQL: Most recurring errors
4 mins
MS SQL
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
MS SQL: enterpriseDB, GROUP BY
MS SQL
Medium4 minsSolve
MS SQL: Most recurring errors
MS SQL
Medium4 minsSolve

Adaface questions are trusted by enterprises globally

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

We evaluated several of their competitors and found Adaface to be the most compelling. Great default library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
Join 1200+ companies in 75+ countries.
Prova det mest kandidatvänliga utvärderingsverktyget idag.
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
chatta med oss
40 min tests.
No trick questions.
Accurate shortlisting.