Unit 4b

Question 1

Primary storage objects within database

Answer 1

Tables

Question 2

Row data must adhere to rules

Answer 2

Table Constraints

Question 3

Column entry for row must have data

Answer 3

NOT NULL Table Restraint

Question 4

Allows value to be stored only if that value doesn’t already exist in the column

Answer 4

UNIQUE Table Restraint

Question 5

Column entry for row may or may not have data

Answer 5

NULL Table Restraint

Question 6

Uniquely identifies every row stored within table

Answer 6

PRIMARY KEY Table Restraint

Question 7

Signifies key is used as Primary Key in different table, applied to child table, not parent

Answer 7

FOREIGN KEY Table Restraint

Question 8

Allows storage of fixed-length character string

Answer 8

CHAR()

Question 9

no value stored (char with no specified size is

assumed to be 1)

Answer 9

CHAR

Question 10

value stored ‘‘dog ‘’ (7 wasted spaces)

Answer 10

CHAR(10)

Question 11

Add new row of data into Table

Answer 11

INSERT INTO Command

Question 12

Change existing value for a row(s) or column(s) in table

Answer 12

UPDATE Command

Question 13

Allows deleting of table rows

Answer 13

DELETE Command

Question 14

Deleting table from database

Answer 14

DROP TABLE Command