Skip to content
GyaniX
Enter GyaniX Universe
← Assessment catalogue

Technology

SQL & Relational Databases Assessment

Learning and self-assessment — AI-reviewed

50 questions75 minutesProctoredLevel: Junior, Mid-level, SeniorEnglishSkill assessment

What this assesses

SQL & Relational Databases: 50 questions across 8 topics, about 75 minutes. Questions were drafted with AI and each one checked in a separate evidence-based review (code run, answers recomputed, sources opened); they are not independently expert-validated.

AI-generated and AI-reviewed — not independently expert-validated. For learning and self-assessment only. Not a hiring, academic or professional qualification.

Databases

  • Aggregation & grouping6 q
  • DDL, constraints & normalisation6 q
  • Indexing & performance7 q
  • Joins7 q
  • Querying & filtering6 q
  • Subqueries & CTEs6 q
  • Transactions & isolation6 q
  • Window functions6 q

Who it is for

  • • College students
  • • Freshers
  • • Working professionals
  • • Career changers
  • • Career re-entry
  • • Employees
  • • Organisation candidates

Levels: Junior, Mid-level, Senior

Structure

  • • 50 questions in 75 minutes, one attempt
  • • Questions drawn from a bank of AI-reviewed questions, each checked with evidence; your paper is fixed when you start
  • • Timer runs on our server; answers save automatically; you can resume after a disconnection
  • • AI tools and outside help are not allowed

Languages and content status

Available to take in: English. You choose the language before you start, and it stays the same for the whole attempt. If your language is not listed, the assessment is not offered in it yet; nothing is switched after you pay.

Questions were drafted with AI and checked one by one with evidence (code run, answers recomputed, sources opened). They have not been validated by an independent expert.

Sample questions

Practice examples of the question style. They are not part of the live assessment.

  1. 1. Sample: table t has four rows whose dept values are 'A', 'A', 'B' and NULL. What does SELECT COUNT(dept) FROM t return?

    • A. 4
    • B. 3
    • C. 2
    • D. NULL

  2. 2. Sample: rows (dept, salary) are (A, 10), (A, 20), (B, 30), (NULL, 5). Which groups does SELECT dept, SUM(salary) FROM t GROUP BY dept HAVING SUM(salary) > 25 return?

    • A. Only B
    • B. A and B
    • C. A, B and the NULL group
    • D. No rows

  3. 3. Sample: with dept values 'A', 'A', 'B' and NULL, how many rows does SELECT * FROM t WHERE dept <> 'A' return?

    • A. 1
    • B. 2
    • C. 3
    • D. 4

Proctoring requirements

  • ✓A laptop or desktop (not a phone)
  • ✓Camera and microphone, switched on throughout
  • ✓Full-screen browser; stay on the assessment tab
  • ✓A quiet room, alone
  • ✓Consent is asked before you start
  • ✓Warnings are shown to you; persistent breaches can end the attempt