MySQL Tutorial

1:

Which of the following is not a valid table name in MySQL?

  1. employee

  2. select

  3. employee.skill

  4. employeeSkills

2:

Which of the following statements about CHAR and VARCHAR is correct?

  1. A CHAR column always takes up the same amount of disk space, regardless of its contents.

  2. VARCHAR s are padded with spaces when they are stored on disk.

  3. A CHAR column, on average, takes up less disk space than an equivalent VARCHAR column.

  4. A VARCHAR column always takes up the same amount of disk space, regardless of its contents.

3:

Before we can create tables in a database, we must first

  1. create the indexes for the tables

  2. create the database

  3. create the database and select it for use

  4. create all the table columns

4:

Which of the following CREATE TABLE statements is syntactically correct?

  1. create table department departmentID int not null auto_increment primary key, name varchar(20) type=InnoDB;

  2. create table department type=InnoDB ( departmentID int not null auto_increment primary key, name varchar(20) );

  3. create department ( departmentID int not null auto_increment primary key, name varchar(20) ) type=InnoDB;

  4. create table department ( departmentID int not null auto_increment primary key, name varchar(20) ) type=InnoDB;

5:

To delete an entire database (called dbname) and all its contents, you would type

  1. drop all tables on dbname;

  2. drop database dbname;

  3. drop dbname;

  4. delete database dbname;

Related

Категории