Please answer the questions below:

Which SQL command is used to delete both the data and metadata in a table?

Group of answer choices:

DELETE

DROP

REDACT

UNDO

UNWRITE

Based on the relational schema shown above, what is the most likely data type for the field TotalTeams?

Group of answer choices:

BOOLEAN

CHAR

NUMBER

DATE

VARCHAR$2$

Assume we have already created the three tables in the schema shown above. Which of the following is the correct SQL syntax to add a column tracking the position of each athlete?

Group of answer choices:

ADD Position VARCHAR$2(25)$;

MODIFY TABLE ATHLETE ADD Position VARCHAR$(25)$;

ALTER TABLE TEAM ADD Position VARCHAR$2(25)$;

ALTER TABLE TEAM MODIFY Position VARCHAR$2(25)$;

ALTER TABLE ATHLETE ADD Position VARCHAR$2(25)$;

Which type of constraint is used to limit the range of values that can be stored in a column? For example, a constraint that customer birthdays must fall between the years $1900$ and $2021.$

Group of answer choices:

CHECK

KEY

NOT NULL

UNIQUE

RANGE

Which SQL logical operator is used to do partial text matching?

Group of answer choices:$=$

DISTINCT

STRING

LIKE

~

Which of the following is NOT an example of a wildcard operator in SQL$?$

Group of answer choices:

$|$

$*$

$\%$

$\_$

They are all wildcard operators

Based on the relational schema above, which SQL query will return the text for all review with $4$ or $5$ stars?

Group of answer choices:

SELECT $*$

FROM REVIEW;

SELECT ReviewText

FROM REVIEW

WHERE Stars$=4$ OR $5$;

SELECT ReviewText

FROM REVIEW;

SELECT ReviewText

FROM REVIEW

WHERE Stars$=4$ OR Stars$=5$;

SELECT $*$

FROM REVIEW

WHERE Stars$=4$ OR Stars$=5$;

Assume that one hotel's name in the database shown above was misspelled $("$Best Worstern" instead of "Best Western"$).$ Which SQL command will correct this error?

Group of answer choices:

UPDATE HOTEL

SET HotelName $=$ 'Best Western';

UPDATE HOTEL

SET HotelName $=$ 'Best Western'

WHERE HotelName $=$ 'Best Worstern';

UPDATE HOTEL

SET HotelName $=$ 'Best Worstern';

UPDATE HOTEL

SET HotelName $=$ 'Best Western'

WHERE HotelName IS NULL;

UPDATE HOTEL

SET HotelName $=$ 'Best Worstern'

WHERE HotelName $=$ 'Best Western';