Practice Test GeeksSQL Practice Test
← All SQL Flashcard Decks

General Concepts Flashcards

7 cards from real SQL practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 General Concepts flashcards as text

  1. What does the acronym SQL stand for?

    Answer: Structured Query Language

    SQL stands for Structured Query Language, used to manage relational databases.

  2. Which category does the SELECT statement belong to?

    Answer: DML (Data Manipulation Language)

    SELECT retrieves data and is part of DML, though some classify it as DQL.

  3. What is a relational database primarily organized into?

    Answer: Tables made of rows and columns

    Relational databases store data in tables consisting of rows and columns.

  4. Which clause is used to filter rows in a SELECT query?

    Answer: WHERE

    The WHERE clause filters rows based on a specified condition.

  5. What does a primary key guarantee for a table?

    Answer: Each row is uniquely identifiable

    A primary key uniquely identifies each row and cannot contain NULLs.

  6. Which SQL command is used to remove all rows but keep the table structure most efficiently?

    Answer: TRUNCATE

    TRUNCATE quickly removes all rows while preserving the table structure.

  7. What is NULL in SQL?

    Answer: The absence of a value

    NULL represents a missing or unknown value, not zero or an empty string.