DDL, MySQL

Question: How to create a new database?
A
create database Name

B
create new database

C
create db db_name

D
All

Note: Not available
1. Report
Question: How to delete database?
A
create database name

B
drop database name

C
delete database name

D
alter database name

Note: Not available
1. Report
Question: To delete a database we use:
A
mysql>DROP database (database name);

B
mysqladmin>DROP database (database name);

C
mysql>DROP database (database name)

D
mysql>DROP database (database name):

Note: Not available
1. Report
Question: To convert ISAM student table to MyISAM student table, we shall use the command as mysql>______;
A
alter table student type=myisam

Note: Not available
1. Report
Question: What is the proper syntax for deleting a table?
A
DELETE DATABASE IF EXISTS databasename;

B
DROP TABLE tablename;

C
DELETE TABLE tablename;

D
DROP DATABASE IF EXISTS databasename;

Note: Not available
1. Report
Question: What is the proper syntax for creating a table?
A
CREATE TABLE columnnames (tablename);

B
CREATE tablename (columnnames);

C
CREATE columnnames (tablename);

D
CREATE TABLE tablename (columnnames);

Note: Not available
1. Report
Question: Is the following query valid?
Create table foo (id int primary key auto_increment, name varchar);
A
Yes

B
No

Note: Not available
1. Report

Question: How to create a new database?