MySQL
 

  1. Question: Which mysql client option causes mysql to ignore all DELETE and UPDATE queires in which the WHERE clause is omitted?

    A
    -U

    B
    -C

    C
    -e

    D
    -f

    Note: Not available
    1. Report

  2. Question: Which of the following is not mysqladmin commands?

    A
    version

    B
    reload

    C
    status

    D
    variable

    Note: Not available
    1. Report

  3. Question: What is the correct syntax to use mysqladmin to create a database named test2?

    A
    shell>mysqladmin -u root -p create test2

    B
    shell>mysqladmin  create test2 -u root -p

    C
    shell>mysqladmin -u root -p create database test2

    D
    mysql>mysqladmin -u root -p create database test2

    Note: Not available
    1. Report

  4. Question: Which of the following operating systems are supported to run MySQL?

    A
    MySQL runs on which operating systems?

    B
    Any operating system at all

    C
    Unix, Linux, Windows and others

    D
    Unix and Linux only

    Note: Not available
    1. Report

  5. Question: What is the proper syntax used to insert data into a table?

    A
    INSERT INTO tablename VALUES ();

    B
    INSERT VALUES () INTO tablename ();

    C
    INSERT VALUES () INTO tablename;

    D
    INSERT INTO tablename () VALUES ();

    Note: Not available
    1. Report

  6. Question: Which of the following syntax examples will cause an error?

    A
    SELECT column1, column2, column2 FROM tablename;

    B
    SELECT * FROM tablename WHERE columnname LIKE '%keyword%';

    C
    SELECT * FROM tablename WHERE column1 LIKE 'keyword' AND column2 LIKE 'keyword';

    D
    SELECT DISTINCT column1 FROM tablename ORDER BY column1;

    E
    SELECT * FROM pets COUNT(*);

    Note: Not available
    1. Report

  7. 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

  8. Question: What three things need to be specified during an UPDATE statement?

    A
    Database & Table, row

    B
    Database, Column & New Update

    C
    Table, Column & New Data

    Note: Not available
    1. Report

  9. 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

  10. Question: Which is not mysql server client?

    A
    mysql

    B
    mysqldump

    C
    mysqlshow

    D
    mysqlhotcopy

    E
    mysqlimport

    F
    myisamchk

    G
    mysqlcheck

    H
    all

    I
    mysqlexport

    Note: Not available
    1. Report
First1011121314Last
/16
Copyright © 2025. Powered by Intellect Software Ltd