CIW Database Design Specialist 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 Specialist flashcards as text
What is the primary purpose of a primary key in a relational database table?
Answer: Uniquely identify each row in the table
A primary key uniquely identifies every record in a database table and cannot contain NULL values.
Which SQL statement is used to retrieve data from a database?
Answer: SELECT
The SQL `SELECT` statement queries a database and returns a result set of matching rows.
What does normalization in database design primarily aim to eliminate?
Answer: Data redundancy and update anomalies
Normalization restructures tables to minimize data redundancy and prevent insertion, update, and deletion anomalies.
Which type of SQL JOIN returns only rows where there is a match in both tables?
Answer: INNER JOIN
An `INNER JOIN` returns only the rows that have matching values in both joined tables.
In relational database terminology, what is a foreign key?
Answer: A column that references the primary key of another table
A foreign key is a column (or set of columns) that establishes a link between data in two tables by referencing the primary key of another table.
What does the SQL `GROUP BY` clause do?
Answer: Groups rows with the same values so aggregate functions can be applied per group
The `GROUP BY` clause groups rows sharing the same values in specified columns so aggregate functions like COUNT or SUM operate per group.
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
- ciwcertified.com — Exam format, passing score, time limit, test delivery, renewal, score release, score validity, retake policy, eligibility, fees · verified Oct 2026