Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

SQL Server 2005-2008 Assessment Test Online

Useful for hiring

  • SQL DBA Specialist
  • Microsoft SQL Server DBA
  • SQL Server Programmer
  • SQL Server Expert

Start hiring job-fit candidates using this assessment

GET A DEMO

"Our recruitment team loves Interview Mocha especially for their skill assessments, simulators, and friendly support. Since using Interview Mocha, we interview only relevant candidates, and this has reduced our time to hire. Recruitment is no longer an hassle for us."

Christoph, e-Zest GmbH
Question

How to delete records from studentinfo table with the name of student 'Mark Smith'?

Answer
    • DELETE FROM table studentinfo 
      WHERE sname = 'Mark Smith'; 
       

    • DELETE FROM studentinfo 
      WHERE sname = 'Mark Smith'; 
       

    • DELETE FROM studentinfo 
      WHERE COLUMN sname='Mark Smith';
       

    • DELETE FROM studentinfo 
      WHERE sname LIKE 'Mark Smith'; 
       

Question

Which of the following is an SQL trigger supported by Oracle?

Note: There can be multiple correct answers to this question.

Answer
    • BEFORE

    • INSTEAD OF

    • AFTER

Question

Find the SQL statement from below that is equal to the following:
SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

Answer
    • SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

    • SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

    • SELECT NAME IN CUSTOMER WHERE STATE = 'V';

    • SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Test details:

SQL Server 2005 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              :  30 Minutes

No. of Questions        :  30


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.

Test description:

SQL Server 2005/2008 assessment test helps Employers, Recruiters and Hiring managers to assess candidate’s knowledge of SQL Server2005/2008 before an interview. SQL Server 2005 & SQL Server 2008 are the editions of Microsoft’s database product.

This test contains questions on following Topics:
 

  • SQL Server 2005/2008 Query Optimizer

  • DBMS Concepts:-

    • Database Model

    • RDBMS

    • Normalization

    • Generalization and Specialization

    • Database Architecture

  • MS SQL Server:-

    • SQL Server 2005/2008 Database Development

    • SQL Server 2005/2008 Platforms

    • SQL Server 2005/2008 Administration

  • SQL Basics:-

    • SQL Operators

    • SQL Tables

    • SQL Clauses

    • SQL Constraints

    • Create, alter, truncate, drop, rename Query

  • XML Data Types 

 
SQL Server 2008 Online 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.

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO