1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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