陈老师:1415968548 郑老师:2735197625 乐老师:354331153
客服热线:
19941464235/19906632509(微信同号)

客服微信

  • 1
    Which two options describe how MySQL Server allocates memory? (多选题)
    A.Each connection may have its own per-thread memory allocations.
    B.Thread memory is pre-allocated up to thread_cache_size for performance.
    C.Each thread allocates memory from a global pool.
    D.Global memory resources are allocated at server startup.
  • 2
    A MySQL database uses all InnoDB tables and is configured as follows: shell>cat/ etc/ my.cnf [mysqld] log-bin server-id=1 You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections. Which two arguments will you pass to mysqldump to achieve this? (多选题)
    A.--skip-opt
    B.--lock-all-tables
    C.--create-apply-log
    D.--single-transaction
    E.--master-data
  • 3
    A crucial database, ‘db_prod’, just disappeared from your production MySQL instance. In reviewing the available MySQL logs (General, Audit, or Slow) and your own application level logs, you identified this command from a customer facing application: SELECT id FROM users WHERE login=’payback!’;DROP DATABASE db_prod;’ Which three methods could have been used to prevent this SQL injection attack from happening? (单选题)
    A.writing your client code to properly escape all user input
    B.giving limited privileges to accounts used by application servers to interact with their backing databases
    C.using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions
    D.using a hashing or encryption method to secure all user passwords in your MySQL tables
    E.removing any remaining anonymous accounts from your MySQL instance
    F.validating all user input before sending it to the database server
    G.changing all passwords for the MySQL account ‘root’@’%’ immediately after losing an employee who knew the current password