Which of the following is not a valid table name in MySQL?
employee
select
employee.skill
employeeSkills
Which of the following statements about CHAR and VARCHAR is correct?
A CHAR column always takes up the same amount of disk space, regardless of its contents.
VARCHAR s are padded with spaces when they are stored on disk.
A CHAR column, on average, takes up less disk space than an equivalent VARCHAR column.
A VARCHAR column always takes up the same amount of disk space, regardless of its contents.
Before we can create tables in a database, we must first
create the indexes for the tables
create the database
create the database and select it for use
create all the table columns
Which of the following CREATE TABLE statements is syntactically correct?
create table department departmentID int not null auto_increment primary key, name varchar(20) type=InnoDB;
create table department type=InnoDB ( departmentID int not null auto_increment primary key, name varchar(20) );
create department ( departmentID int not null auto_increment primary key, name varchar(20) ) type=InnoDB;
create table department ( departmentID int not null auto_increment primary key, name varchar(20) ) type=InnoDB;
To delete an entire database (called dbname) and all its contents, you would type
drop all tables on dbname;
drop database dbname;
drop dbname;
delete database dbname;