SQL Basic

Which clause is used with the ALTER TABLE statement?

• JOIN

• SELECT

• INTO

• ADD COLUMN

What is a relational database?

• A database that organizes information into one or more tables.

• A set of data values of a particular type.

• A single record in a table

• A collection of data organized into rows and columns.

What would you need to complete the associated UPDATE statement?

UPDATE ________

SET height = 6

WHERE id = 1;

• A column name.

• A table name.

• The keyword INTO.

• A row name.

What are common data types in SQL?

• PDF, JPEG, GIF, MP3

• id, name, age

• Row, Column

• Integer, Text, Date, Real

Answer explanation

Integer - a whole number. Text - a text string. Date - a date. Real - a decimal number.

What does the INSERT statement do?

• Fetch data from a database.

• Insert a new table into a database

• Insert new rows into a table

• Insert new columns into a table

Answer explanation

You can use the INSERT statement when you want to add new records.

What is a NULL value?

• A value that represents missing or unknown data.

• A numerical value.

• An outdated value.

• A known value.

What is the purpose of the * character?

SELECT * 
FROM celebs;

• It selects new values in the table.

• It only selects columns where values are not empty in the table.

• It selects the leftmost column in the table.

• It selects every column in the table.

Answer explanation

Correct! It allows us to select every column in a table without having to name each one individually.

What does SQL stand for?

Answer explanation

Correct! SQL is a programming language designed to manage data stored in relational databases.

Which of the following statements is correct and complete?

• DELETE FROM icecream WHERE flavor IS NULL;

• DELETE icecream WHERE flavor NULL;

• WHERE flavor IS NULL DELETE FROM icecream

• WHERE flavor IS NULL

What would be correct syntax for a CREATE TABLE statement?

• NEW TABLE meals ( name TEXT, rating INTEGER) ;

• CREATE TABLE meals ( name TEXT, rating INTEGER) ;

• CREATE meals name TEXT INTEGER

• CREATE meals ( name TEXT, rating INTEGER);