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 a stored procedure in a relational database?

    Answer: A precompiled set of SQL statements stored in the database and executed by name

    A stored procedure encapsulates SQL logic on the server side, improving performance through precompilation and enabling code reuse.

  2. Which SQL aggregate function counts the number of rows in a result set?

    Answer: COUNT()

    COUNT() returns the number of rows that match the query condition; COUNT(*) includes rows with NULL values while COUNT(column) excludes them.

  3. What does ER (Entity-Relationship) diagram represent in database design?

    Answer: The entities, attributes, and relationships between tables in a database schema

    An ER diagram visually maps out entities (tables), their attributes (columns), and the relationships between them, serving as a blueprint for database design.

  4. What is the difference between DDL and DML in SQL?

    Answer: DDL defines database structure (CREATE, ALTER, DROP); DML manipulates data (SELECT, INSERT, UPDATE, DELETE)

    Data Definition Language (DDL) commands define or modify the database schema, while Data Manipulation Language (DML) commands work with the actual data stored in tables.

  5. What is a view in SQL?

    Answer: A virtual table defined by a stored SELECT query that simplifies complex queries

    A view presents the result of a predefined SELECT query as if it were a table, allowing users to access complex joins and aggregations through a simple name.

  6. Which SQL keyword eliminates duplicate rows from a SELECT query result?

    Answer: DISTINCT

    SELECT DISTINCT returns only unique rows by removing duplicate values from the specified columns in the result set.

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