Skip to main content
Login Register

Menu

Home Quizzes Categories Current Affairs GK AI ToolsNEW Play Live Contact
Login Create free account
Medium Free Computer & Technology Database

Database Quiz

Refresh your understanding of databases, SQL and the concepts behind storing and managing data.

100 Questions
No limit Duration
50% To pass
1.00 Marks / correct

Instructions

  • This quiz has 100 questions.
  • There is no time limit on this quiz.
  • You need 50% to pass.
  • There is no negative marking.
  • You can mark questions for review and return to them before submitting.
  • Correct answers and explanations are shown after you submit.

Sample Questions & Answers

A preview of 12 questions from this quiz, each with the correct answer and a written explanation. Attempt the full, timed quiz to be scored and earn XP.

  1. Question 1

    What is the primary purpose of a database?

    • To store and manage structured data Correct answer
    • To compile source code
    • To render web pages
    • To manage computer memory
    Explanation: A database is designed to store, organize, retrieve, and manage data efficiently.
  2. Question 2

    Which language is primarily used to query relational databases?

    • HTML
    • SQL Correct answer
    • CSS
    • XML
    Explanation: SQL, or Structured Query Language, is the standard language used to work with relational databases.
  3. Question 3

    Which SQL command retrieves data from a table?

    • GET
    • SELECT Correct answer
    • FETCH TABLE
    • READ
    Explanation: SELECT is used to retrieve rows and columns from one or more database tables.
  4. Question 4

    Which SQL command adds new rows to a table?

    • ADD
    • INSERT Correct answer
    • CREATE
    • APPEND TABLE
    Explanation: INSERT adds new records to a database table.
  5. Question 5

    Which SQL command modifies existing rows?

    • CHANGE
    • UPDATE Correct answer
    • MODIFY TABLE
    • ALTER ROW
    Explanation: UPDATE changes values in existing rows that match its condition.
  6. Question 6

    Which SQL command removes rows from a table?

    • REMOVE
    • DELETE Correct answer
    • DROP ROW
    • ERASE
    Explanation: DELETE removes rows from a table, optionally based on a WHERE condition.
  7. Question 7

    Which SQL command creates a new table?

    • MAKE TABLE
    • CREATE TABLE Correct answer
    • NEW TABLE
    • BUILD TABLE
    Explanation: CREATE TABLE defines a new table and its columns and constraints.
  8. Question 8

    Which SQL command removes an entire table and its definition?

    • DELETE TABLE
    • REMOVE TABLE
    • DROP TABLE Correct answer
    • CLEAR TABLE
    Explanation: DROP TABLE removes the table definition and its stored data.
  9. Question 9

    Which SQL clause filters rows based on a condition?

    • FILTER
    • WHERE Correct answer
    • HAVING ONLY
    • WHEN
    Explanation: The WHERE clause restricts rows according to a specified condition.
  10. Question 10

    Which SQL clause sorts query results?

    • SORT BY
    • ORDER BY Correct answer
    • GROUP BY
    • ARRANGE
    Explanation: ORDER BY sorts the result set using one or more specified columns.
  11. Question 11

    Which SQL clause groups rows that share values?

    • GROUP BY Correct answer
    • ORDER BY
    • COLLECT BY
    • CLUSTER BY
    Explanation: GROUP BY groups rows with matching values so aggregate calculations can be performed per group.
  12. Question 12

    Which SQL clause filters groups after aggregation?

    • WHERE
    • HAVING Correct answer
    • FILTER GROUP
    • AFTER
    Explanation: HAVING filters grouped results after GROUP BY and aggregate calculations.

Login/Register to attempt the full quiz and earn XP.

Login Create free account

Explore more: All Computer & Technology quizzes · Database

Database and SQL Practice

Good database knowledge starts with understanding tables, relationships, keys and queries. This quiz brings those concepts together so you can check your understanding of SQL and relational database fundamentals.

Frequently Asked Questions

This quiz has 100 questions and no time limit.

You need at least 50% to pass this quiz.

No, there is no negative marking on this quiz.

Yes. You can attempt this quiz again at any time, though first-attempt XP bonuses apply only once.

Sign in to attempt this quiz and earn XP.

Login to Start Create free account

Related Quizzes