Microsoft SQL Server 2012 Online Developer Test

Topics covered

Querying Microsoft SQL Server 2012 database, Architecture and Editions of SQL Server 2012, Sorting and Filtering Data, Built-In Functions, Implementing Error Handling, Transactions, Design & implementation of a Data Warehouse with Microsoft SQL Server 2012, Sequence Object, Contained Database, Improvement in FILESTREAM Storage, Enhancements in Transact-SQL Construct, Table-Valued Functions, Extended Events, Refactoring Requirements, XML Data

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

SQL server 2012 online test is designed to check the application and testing skills of a Microsoft SQL Server 2012 Developer – as per Industry Standards. MS SQL Server 2012 is one of the editions of Microsoft SQL Server Products which provides new useful features and enhancements than that of previous.Microsoft SQL Server Developer is generally from programming background who is responsible for designing and implementation of a SQL code.
 

MS SQL Server 2012 Developer Test Contains Questions on Following Topics :
  

  • Querying Microsoft SQL Server 2012 database

  • Architecture and Editions of SQL Server 2012

  • Sorting and Filtering Data

  • Built-In Functions

  • Implementing Error Handling, Transactions

  • Design & implementation of a Data Warehouse with Microsoft SQL Server 2012

  • New SQL Server 2012 Features:

    • Sequence Object

    • Contained Database

    • Improvement in FILESTREAM Storage

    • Enhancements in Transact-SQL Construct, etc.

  • Table-Valued Functions

  • Extended Events

  • Refactoring Requirements

  • XML Data


SQL server 2012 developer pre employment test is designed by our subject matter experts to analyze one’s understanding of this discipline. Using powerful reporting, you can have a detailed analysis of the test results to help you make a better hiring decision and predict the candidate’s performance.

This pre-employment test is useful for hiring:
  • SQL server 2012 developer

  • SQL Server Developer
  • MS SQL Server developer
  • Database Application Developer

Test details:

SQL server 2012 developer knowledge test enables employers and recruiters to evaluate skills and job readiness of candidates. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.

Test Duration              :  20 Minutes

No. of Questions        :  20   (Application Oriented - 15 & Theory-Based - 5)

Type of Questions   :  This test contains MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blanks, Descriptive & True or False Questions.

Microsoft SQL Server 2012 Developer Test

Question #1 of 2

The minimum and maximum value that DATEDIFF function can return is:

    • -2,147,483,648 and +2,147,483,647

    • -9,223,372,036,854,775,808 and 9,223,372,036,854,775,807

    • -2,147,483,648 and 9,223,372,036,854,775,807

Question #2 of 2

Which code will give an error?

1 -SELECT DATEDIFF_BIG(MILLISECOND,
 '12/01/2015','12/30/2015') 
AS 'Difference in MILLISECOND'

2- SELECT DATEDIFF(MILLISECOND,
 '12/01/2015','12/30/2015')
 AS 'Difference in MILLISECOND'

    • 1

    • 2

    • 1,2

Candidate Name
Assessment Name
Invited by
Assessment Date
IP Address
Status
















24.00 Out of 40.00
Pass
60%
03
23 Minutes

Java EE

9/10

Hibernate

3/10

Oracle PL/SQL

7/10

Analytical Thinking

5/10

Note:If score<= 30% then its a Weakness. If score >=70% then its a Strength.

Strengths

Java EE, Oracle PL/SQL, Analytical Thinking

Weaknesses

Hibernate

Happy

It was a good test for me, the questions were on the latest technology of java on which I am currently working. It was a great experience. Thank you!

Take your first step to hire job fit candidate

GET A DEMO

How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Take your first step to hire job fit candidate

GET A DEMO