Stack the correct SQL answers

Exercise and reference answers

Questions

1. Answer

   ALTER TABLE

   Question

   Statement that alters structure

   Choices

   1. ALTER TABLE
   2. UPDATE

2. Answer

   UPDATE

   Question

   Statement that changes rows

   Choices

   1. UPDATE
   2. CREATE

3. Answer

   255

   Question

   CHAR(n) allows n up to

   Choices

   1. 255
   2. 355

4. Answer

   65535

   Question

   VARCHAR(n) allows n up to

   Choices

   1. 65535
   2. 6553

5. Answer

   NOT NULL

   Question

   Constraint forbidding NULL

   Choices

   1. NOT NULL
   2. NO NULL

6. Answer

   Join

   Question

   Combines rows of two tables

   Choices

   1. Join
   2. Jump

7. Answer

   Not case sensitive

   Question

   SQL is a language that is

   Choices

   1. Case sensitive
   2. Not case sensitive

Instructions

Pick the correct option each time to build the tower.

Explanation