Our very own table

We've set up a database inside this course, and the books table is available in the exercise. You'll use SQL to query this table in the next chapter, but for now, it's time to explore what data books holds!

Your task is to choose the option below that best describes the information contained in books. There's no need to do any coding in this exercise; you can answer this question by looking at the books table in the console next to the words "query result." Because some book titles are long, you may need to scroll to the right in order to see all the information that the books table contains.

Possible answers

books contains records for id, title, author, year, and genre.

books contains fields for id, title, author, year, and genre.

books contains records for title, author, year, and genre. id is a unique identifier but not a record.

books contains fields for title, author, year, and genre. id is a unique identifier but not a field.

Exercise

Our very own table

Instructions

Possible answers