Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Data Types in SQL

Introduction
Sequences
Summary
15. Question 1

Instruction

Okay, let's start with the first question!

Exercise

A zoo in Ohio needs a table to keep track of their animals. Create a table named animal with the following columns:

  1. id – The primary key, it's an integer value that's always generated automatically. Start with the value of 2 and only generate even numbers.
  2. name – Up to 32 characters.
  3. type – Up to 32 characters.
  4. year_born – An integer value.