Author: Anonymous

Where can a CTE that yields a table of one column and several rows be utilized?

What is a valid reason for implementing a one-to-one relationship using shared primary keys?

What is a primary reason for employing a Common Table Expression (CTE) in SQL?

Why might a database designer create an artificial attribute as a key?

In which situation should you use GROUP BY instead of DISTINCT in a SELECT query?

What does COUNT(*) return when used in a SELECT statement without a WHERE clause?

When you have a complex SQL query that involves several steps, what is the recommended approach to solve it?

You want to list the names of all owners who currently own at least one ship. You use a CTE to define the list of owned ships first. Which query gives the correct result?

How is a one-to-many relationship physically represented in a relational schema?

Why is a scalar subquery useful in an SQL expression?