Practice Test GeeksCIW Certified Internet Web Professional Practice Practice Test
← All CIW Flashcard Decks

CIW Database Design & SQL Flashcards

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

Read the first 6 CIW Database Design & SQL flashcards as text

  1. What is the purpose of a primary key in a relational database table?

    Answer: To uniquely identify each row in the table

    A primary key is a column or combination of columns whose values uniquely identify every row, preventing duplicate records.

  2. Which SQL command is used to retrieve data from a database table?

    Answer: SELECT

    The SELECT statement queries one or more tables and returns a result set matching the specified columns and conditions.

  3. What does normalization achieve in database design?

    Answer: Reduces data redundancy and ensures data integrity by organizing tables logically

    Normalization organizes database tables to minimize redundancy and dependency, typically following normal forms (1NF, 2NF, 3NF).

  4. What is a foreign key in a relational database?

    Answer: A column that references the primary key of another table to establish a relationship

    A foreign key enforces referential integrity by ensuring that a value in one table matches an existing value in the referenced table's primary key.

  5. Which SQL clause is used to filter query results based on a condition?

    Answer: WHERE

    The WHERE clause filters rows before any grouping or aggregation occurs, returning only records that meet the specified condition.

  6. What type of SQL JOIN returns only rows that have matching values in both tables?

    Answer: INNER JOIN

    An INNER JOIN returns only the rows where the join condition is satisfied in both tables, excluding unmatched rows from either side.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. ciwcertified.com — Test delivery, eligibility, renewal, retake policy, score release, score validity, exam format, passing score, time limit, fees · verified Oct 2026