1Z0-888 試験問題を無料オンラインアクセス

Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE `/etc/passwd' INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

• A.setting the --local-service=0 option when starting mysqld
• B.setting the --local-infile=0 option when starting mysqld
• C.setting the --open-files-limit=0 option when starting mysqld
• D.executing REVOKE FILE FROM *_*
• E.executing REVOKE FILE ON *_* FROM ` `@'%'
• F.executing REVOKE LOAD FROM *.*

Which statement best describes the purpose of the InnoDB buffer pool?

• A.It is amount of buffers available during a transaction.
• B.It is a pool of memory for SQL query sort operations from within the InnoDB engine.
• C.It caches data and indexes for InnoDB tables.
• D.It caches only the indexes for InnoDB tables.
• E.It holds changes made during a transaction before they are written to the log.

Which two are considered good security practices when using passwords? (Choose two.)

• A.Choose short passwords to save on storage space.
• B.Do not use dictionary-based words.
• C.Store passwords external to the database.
• D.Use one-way encryption for storage of passwords.
• E.Use simple keyboard actions that give mixed letters.

What three are correct statements about MySQL backups? (Choose three.)

• A.They are used to recover data.
• B.They are used to set up a test system.
• C.They are used to prevent data theft.
• D.They are used to prevent data corruption.
• E.They are used to set up the initial binary log files.
• F.They are used to set up a replication slave.

You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario? (Choose three.)

• A.The query benefited from sort_buffer_size increase.
• B.The query benefited from sort_buffer_size and tmp_table_size increases.
• C.The query benefited from tmp_table_size increase.
• D.Session variables are not persistent across server restarts.
• E.sort_buffer_size should match tmp_table_size to be optimal.
• F.Global variables are not persistent across server restarts.