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×

SQLite Online Test

Topics Covered

  • SQL injections
  • Update statements
  • Indexes
  • Database productivity
  • Triggers
  • Pragma
  •  Functions
  • Queries. OR clauses

Useful for hiring

  • Sr. Android Developer – SQLite
  • iOS developer-SQLite
  • SQLite developer

Start hiring job-fit candidates using this assessment

GET A DEMO

"Interview Mocha has provided UNEECOPS with a veritable assessment platform with a comprehensive test library, online test platform, and intelligent reports. This made it easier for us to map different job openings with job-fit candidates and recruit faster."

Nisha Chandila, UNEECOPS,
Talent Acquisition Manager
Question

You have table USERS in your SQLite database with the following fields:
ID INTEGER PRIMARY KEY
NAME TEXT
PHONE TEXT
AGE INTEGER.

You ran the following commands one by one to create indexes:

CREATE INDEX NAME_INDEX ON USERS (NAME);
CREATE INDEX PHONE_INDEX ON USERS (PHONE);
CREATE INDEX ON USERS (PHONE, AGE);

How many indices will be generated by .indices USERS command when these statements get executed?

Answer
    • 1

    • 2

    • 3

    • 4

Question

You are using the SQLite database in your project. You decided to minimize the size of your database file automatically without calling VACUUM function. You know that your database contains up to 10 freelist pages. Which of the following statements will allow you to automate the database clean up?

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

Answer
    • PRAGMA myDB.auto_vacuum = 0;
       

    • PRAGMA myDB.auto_vacuum = 1;
       

    • PRAGMA myDB.auto_vacuum = 2;
       

    • PRAGMA myDB.auto_vacuum = 2;
      PRAGMA myDB.incremental_vacuum(10);
       

Question

You have an SQLite database in your hotel application.

You have the following tables in it:
USERS containing USER_ID, NAME, EMAIL
RESERVATIONS with ID, USER_ID, CHECK_IN_DATE, CHECK_OUT_DATE

You need to get the list of all users bound to their check-in and check-out dates if they are available. Which join can you use to achieve this?

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

Answer
    • INNER JOIN

    • NATURAL INNER JOIN

    • LEFT OUTER JOIN

    • NATURAL LEFT OUTER JOIN

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