DATA4200 - Week 5 :)

What the SELECT statement does?

• Get the first 10 rows on the table

• Get a list of tables in the database

• Get data of all or defined columns from a defined table

• It's not necessary to add the SELECT statement in the query

What the WHERE clause represents in the query?

• It defines which table we will get the data

• It combine two tables

• It is mandatory to have the WHERE in a SQL query

• It defines the condition to filter the data

What is a primary key?

• Is a field in one table, that refers to another table

• It is the row definition of a table (one or many fields)

• It is a column that has information about another column

• It is a column that depends of another column

What is true about a primary key?

• It cannot have null or duplicate values

• It can have empty or null values

• It can have duplicate values

• It cannot have numbers

Why do we need a SQL client (eg. DBeaver)?

• It is not necessary, we could write SQL in the database

• It's the interface to access the database

• It's the only way to create a table in the database

• That is where we store the data and use SQL