3. Creating and Removing Databases and Tables

Question 1

What is a data type?

Answer 1

A data type defines what type of value a column can contain.

Question 2

Which statement will produce a new table within a database?

Answer 2

CREATE TABLE tablename;

Question 3

Which statement will produce a new database?

Answer 3

CREATE DATABASE databasename;

Question 4

What data type defines that numbers or integers can be used in a column?

Answer 4

int

Question 5

How do you define the maximum length of letters and numbers for a varchar data type?

Answer 5

varchar(10)

*The ‘10’ can be any number.

Question 6

True or false: when using the CREATE DATABASE statement on its own, there is data contained inside the database.

Answer 6

False.

Question 7

What statement would produce a new table AND columns?

Answer 7

CREATE TABLE tablename
(
columnname datatype,
columnname datatype
);

Remember to replace the word ‘datatype’ with the actual datatype to be used for that column.

Question 8

Which data type allows a column to hold a variable length of letters and numbers (characters) in a column?

Answer 8

varchar

Question 9

Which statement will remove a table from a database?

Answer 9

DROP TABLE tablename;

Question 10

Which statement will remove a database and all of its data?

Answer 10

DROP DATABASE databasename;

Question 11

What do you need to set in a CREATE TABLE statement to allow you to easily enter data later?

Answer 11

The Primary Key e.g.

CREATE TABLE advertisements
(ID int PRIMARY KEY,
Product varchar,
Media varchar,
Price int);

Question 12

If you have set a primary key and data types, what statement would allow you to add values to a particular row?

Answer 12

INSERT INTO table

VALUES (1, ‘text’, 2, ‘text’)