SQL (Part 1/2)

The SQL command to create a database schema is...

• CREATE SCHEMA

• CREATE TABLE

• CREATE DATABASE

• CREATE INDEX

In SQL, the truth value of (FALSE OR NULL) is...

• TRUE

• FALSE

• NULL

You’re creating a table for a pizza delivery app.

Which column should NOT allow NULL values?

• pizza_size VARCHAR(20)

• delivery_address VARCHAR(100)

• extra_cheese BOOLEAN

• customer_comments TEXT

You’re creating a table for a library.

Which column should be the primary key?

• book_title VARCHAR(100)

• author_name VARCHAR(100)

• book_id INT

• publication_date DATE

You’re creating a table for a movie database.

Which column should be a foreign key?

• movie_title VARCHAR(100)

• release_year INT

• director_id INT

• genre VARCHAR(50)

A relation may have multiple foreign keys.

• Yes.

• No.

Each table can contain more than one primary key.

• True

• False

Your friend accidentally runs

DROP TABLE users;

instead of

CREATE TABLE users;.

What happens?

• The table is created successfully.

• The table is deleted forever.

• The table is renamed to "users_backup".

• The database explodes.