1. Question: To backup both the structure and the data of two tables: book and user from test database to file "d:/backup.txt" we use %>mysqldump -u root -p ______ test book user>d:/backup.txt

    A
    --add-drop-table

    Note: Not available
    1. Report
  2. Question: Which is the no data type attribute?

    A
    auto-increment

    B
    binary 

    C
    index

    D
    string

    Note: Not available
    1. Report
  3. Question: ______ utility offers a convenient means for determining which databases, tables, and columns exist on a given database server.

    A
    mysqlshow

    Note: Not available
    1. Report
  4. Question: ______ is a robust transactional stroge engine.

    A
    InnoDB

    Note: Not available
    1. Report
  5. Question: The ______ storage engine stores table data in a comma-separated format similar to that supported by many applications.

    A
    CSV

    Note: Not available
    1. Report
  6. Question: ______ storage engine as a basic template for understanding how these engines are created.

    A
    EXAMPLE

    Note: Not available
    1. Report
  7. Question: The A) ______ storage engine greatly compresses any data found in a table of this type by using the B) ______ compression library.

    A
    ARCHIVE

    B
    zlib

    Note: Not available
    1. Report
  8. Question: How many MySQL privilege system revives around concepts?

    A
    2

    B
    3

    C
    4

    D
    5

    Note: Not available
    1. Report
  9. Question: The ______ storage engine operates just like the MyISAM engine except that it won't store any data.

    A
    BLACKHOLE

    Note: Not available
    1. Report
  10. Question: How many ways password stored hashed format?

    A
    One

    B
    Two

    C
    three

    D
    Four

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