Mastering Database Management

0 of 79 lessons complete (0%)
Exit Course
Back to lesson

Lab Tutorial 2 Quiz

You don’t have access to this lesson

Please register or sign in to access the course content.

  1. 1. Find the total number of flights departing from each airport.

    1

  2. 2. Retrieve the number of reservations made by a specific passenger.

    1

  3. 3. Retrieve passenger information for a given reservation ID.

    1

  4. 4. List all flights with available seats for a specific date and destination airport.

    1

  5. 5. Find all passengers with reservations on a specific flight.

    1

  6. 6. List all reserved seats for a specific flight.

    1

  7. 7. Retrieve the total number of available seats for a specific flight.

    1

  8. 8. List all passengers who have not made any reservations.

    1

  9. 9. Retrieve the details of a reservation, including passenger and flight information.

    1

  10. 10. Find all flights departing from a specific airport on a given date.

    1