Help improve our content!

Vote questions up, thumbs up , or down, thumbs down .

Question Categories

All Subjects w/ Images (423)

All Subjects (20390)

Databases Worksheets - Create Printable Tests and Worksheets

Create printable tests and worksheets from Databases questions. Select questions to add to a test using the checkbox above each question. Remember to click the add selected questions to a test button before moving to another page.

The Databases questions below are in the following grade levels:

Databases : None

Which type of sub query can be evaluated independently?
1. correlated
2. uncorrelated

Databases : None

Write a query to list the the colors in the table Colors. The output of the query should look like this:

unique colors
Blue
Green
Orange
Red
- SELECT DISTINCT
    C.color
    FROM
      Colors C
    ORDER BY
      color;

Databases : None

Write a query to count the number of times each color appears in the table Colors. Your output should look like this:

color count
Blue 2
Green 1
Orange 1
Red 3
- SELECT
    C.color,
    count(*) AS count
    FROM
      Colors C
    GROUP BY
      color
    ORDER BY
      color;