The first sheet of the upload template is the ‘Instruction’ sheet which is detailed manual to help you navigate the upload template. All the necessary steps are laid out for easy understanding, we suggest that you refer it while using the template for the first time.


Use this template file to upload multiple Questions to Assess Hands-On Database Query Writing Skills. Follow these steps to Bulk Upload Database Questions –

  • Every Database Question in Mettl needs to refer to a DB Schema (can only be created through Mettl UI). A schema can be used in Multiple Questions.  To add/manage Schema please visit

  • Mettl.com >> Global Settings >> Manage DB Schemas

  • Add the details of a single coding question in one row in the sheet named 'Questions'. Refer to the instructions below to fill the details of a Question.

  • A database question can be attempted in two Database types (MS-SQL, Oracle). Please specify Database types in "DB Types" sheet. At least one DB type per question is mandatory.

  • A database question can be evaluated on multiple datasets. Please specify datasets in sheet named 'Test Cases'.

  • Once you are done adding questions & test cases simply upload this entire file on the Mettl.com. Contents of all sheets other than 'Questions' & 'Test Cases' & 'DB Types' will be ignored.


PFB the details of further Process:

  • Questions: Enter question details in this sheet. Below are the details that are required.

  • Question ID: Enter a unique numeral question ID for all questions. This will be used while assigning test cases to their respective questions.

  • Topic: Enter the ‘Question Bank’ under which you want the question to be saved on the platform. Please note that one question can have only one topic name, however questions for varying topics can be uploaded simultaneously.

  • Difficulty Level: Enter the appropriate difficulty level for the question (Easy, Medium, Difficult).

  • Question Text: Enter the respective text of the question.

  • Database Schema: The name of the database schema the question is based on.

  • The corresponding database schema is needs to be created before uploading the DB Query questions. Visit (Mettl.com >> Global Settings >> Manage DB Schemas)

  • Num Of DB Types: A DB question can be implemented in three Database Types.

    • MSSQL 2008 R2

    • Oracle 11g

    • MySQL 5.5

    • Enter the number of DB types in which you want candidate to attempt this question.


  • Num Of Test Cases: Enter the number of test cases (queries) on the basis of which the query will be evaluated.

  • Custom Category - Other Properties (Optional): Use this field if you want to tag your questions based on any custom criterion. This field will be available if you download the Question later.

    • For example, if you want to tag certain questions based on location & creation date, then value in this field could be -

    • {""location"":""India"", ""date_of_creation"":""01/01/2012""}

    • Please note the format of the values in this field -> {""tag_name1"":""tag_value1"", ""tag_name2"":""tag_value2""}


  • DB Types: Enter all Data Base detail for respective questions in this sheet. Below are the details that are required.

  • Question ID: Enter the Question ID to which this test case is to be assigned.

  • DB Type: Name of the database to be used while attempting question -

    • Currently there are three databases supported by the system namely

    • Oracle

    • MSSQL

    • MYSQL

  • DB Version: Enter the version of the database being used.

    • "11g" for Oracle

    • "2008_R2" for MSSQL

    • "5.5" for MySQL

  • Expected Query: Candidate to responses will be graded against 'Expected Query'. If the response matches, positive mark will be awarded.

  • IsDefault: Default DB Type. If only one DB type is selected for a question, this option has to be True. Else, the default DB type will be the pre-populated type that is shown to the candidate.

  • Order By (Optional): If you want the candidate to assign an order (descending or ascending) to some fields of the output query, then use this field.

    • For example, if candidate is expected to print values of Vegetables & their Prices in descending order, then the value of this field should be 'Prices desc'.

  • Test Cases: Enter all test case detail for respective questions in this sheet. Below are the details that are required.

  • Question ID: Enter the Question ID to which this test case is to be assigned.

  • Test Case Index: Enter the serial number of the test case

  • Test Case Title: Enter the title of the test case. This will be shown in candidate's report.

  • DataSet Name: Name of the dataset to which the test case will refer. A dataset is created while creating a Schema

  • Test Case Marks: Enter marks to be assigned to the test case.

  • IsDefault: Select True/False in order to A default test case will be run when Candidate checks his/her attempt while taking test. At least one Test Case needs of be of default type.