1. What is a database schema?

Defines a type of software used for database management. Data is structured and stored by relationships, through tables.

✔ Defines how data is structured, stored and related. It describes the tables, fields, data types and relationships in the database.

Defines how  unstructured data is stored without the use of  the tables or fields. There are the same data types in the database

.

2. Which SQL statement is used to create a new table called “Products” with a column “ProductID” of type integer?

✔ CREATE TABLE Products (ProductID int);

USE TABLE Products (ProductID int);

CREATE TABLE Products (ProductID integar);

3. True or False: A Primary Key is a unique identifier

✔ True

False

4. What is the correct SQL command to insert the values into the “Orders” table?

INSERT Orders NEW (value1, value2);

✔ INSERT INTO Orders VALUES (value1, value2);

ADD INTO Orders VALUES (value1, value2);