zyBooks catalog

Help$/$FAQ

Julie Morgan $-$

ACTIVITY $||2\mathrm{.}8\mathrm{.}7$: Inserting, updating, and deleting rows.

Jump to level $1$

CREATE TABLE Country $($

Name VARCHAR $(60),$

PopDensity DECIMAL $(7,2),15$t$064$ POPPCt FLOAT,

Code SMALLINT DEFAULT $0,$

Continentcode CHAR $(2)$ DEFAULT $\text{'}$AA$\text{'},$

Over$65$PopPct FLOAT

;

A row is inserted into Country with Name 'Valhalla' but with no other values specified.

What is Valhalla's ContinentCode?

EX'AB' or NULL

What is Valhalla's PopDensity?

Ex: $5\mathrm{.}00$ or NULL

What is Valhalla's Code?

Ex: $5$ or NULL

$(\frac{2}{12})$

Feedback?