1. Question: SQL stands for ______.

    A
    Structured Query Language

    B
    Structured Queue Language

    C
    Standard Query Language

    D
    Structured Query Level

    Note: Not available
    1. Report
  2. Question: Which of the following are MySql Features?

    A
    Replication

    B
    Query Caching

    C
    Storage

    D
    Security

    Note: Not available
    1. Report
  3. Question: What are the MySql License Options?

    A
    MySql Open Source License

    B
    MySql Personal Edition License

    C
    Commercial License

    D
    Enterprise Edition License

    Note: Not available
    1. Report
  4. Question: Which of the following are MySql 5.0 Features?

    A
    Complete Foreign key Support

    B
    Stored Procedure Support

    C
    Integrated Report support

    D
    Batch Query Support

    Note: Not available
    1. Report
  5. Question: What are the storage engine of MySql?

    A
    HDD

    B
    InnoDB

    C
    MyISM

    D
    Backup

    Note: Not available
    1. Report
  6. Question: How to set the administrator password?

    A
    SET ADMINISTRATOR FOR root@localhost=PASSWORD('secret');

    B
    SET ROOT PASSWORD FOR root@localhost=PASSWORD('secret');

    C
    SET PASSWORD FOR root@localhost=PASSWORD('secret');

    D
    SET PASSWORD FOR Admininstrator@localhost=PASSWORD('secret');

    Note: Not available
    1. Report
  7. Question: Which of the following are true about MySqL Client?

    A
    capable of managing almost every conceivable aspect of a MySQL server, including creating, modifying, and deleting tables and databases

    B
    Capable of Database backup, Restore etc

    C
    Viewing Configuration Variables and System Status

    D
    none

    Note: Not available
    1. Report
  8. Question: Where is the greatest use of mysql server?

    A
    Full text indexing and searching

    B
    Query caching

    C
    Replication

    D
    Security

    Note: Not available
    1. Report
  9. Question: Which is the correct coding for executing variables of mysql?

    A
    mysql>show variable "table_type"

    B
    mysql>show variables like "table_type"

    C
    mysql>show stats

    D
    None

    Note: Not available
    1. Report
  10. Question: Which of the following are not data type?

    A
    ENUM()

    B
    SET()

    C
    BINARY

    D
    NATIONAL

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