Mysql Multiple Choice Questions

  1. How to see currently running queries in MySQL?
    1. SHOW PROCESSLIST;
    2. SHOW FULL PROCESSLIST;
    3. SHOW PROCESSLIST\G
    4. All the above
Answer :
D
Explanation:
Added By : Deeksha


  1. How to set value of "query_cache_size" MYSQL system variable
    1. SET GLOBAL query_cache_size = 41980;
    2. SET GLOBAL VARIABLE query_cache_size = 41980;
    3. SET VARIABLE GLOBAL query_cache_size = 41980;
    4. None of the above
Answer :
A
Explanation:
Added By : Rohit

  1. Query to check value of MYSQL system variable
    1. SHOW VARIABLES
    2. SHOW VARIABLES GLOBAL
    3. SHOW GLOBAL VARIABLES
    4. A & C Both
Answer :
D
Explanation:
Added By : Rohit


  1. Mysql is ____ ?
    1. Object Oriented Database
    2. XML Database
    3. Relational Database Management System (RDBMS)
    4. NoSQL Database
Answer :
C
Explanation:
Added By : Jagdish Gupta

Post Your Question
Social Sharing
Search