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

Examine this statement and output:

Which two SQL statements can jsmith execute? (Choose two.)

• A.UPDATE world.country SET Name='all';
• B.UPDATE world.country SET Name=CONCAT('New ',Name);
• C.UPDATE world.country SET Name='first' ORDER BY Name LIMIT
• D.UPDATE world.country SET Name='new' WHERE Name='old';
• E.UPDATE world.country SET Name='one' LIMIT 1;

Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?

• A.The DBA needs to execute FLUSH PRIVILEGES.
• B.John has not activated the role.
• C.John needs to reconnect to the database.
• D.The statement was blocked by MySQL Firewall.

Examine this command and output:

Which statement is true?

• A.Firewall_access_granted is the number of connections granted from whitelisted hosts.
• B.Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
• C.Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
• D.Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

Which statement is true about InnoDB persistent index statistics?

• A.Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
• B.Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
• C.Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
• D.Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
• E.Updating index statistics is an I/O expensive operation.

You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

• A.The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
• B.MySQL keeps InnoDB metadata changes in .sdi files in datadir.
• C.MySQL writes SDI to the binary log for distributed backups.
• D.MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
• E.MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.