1z1-908 무료 덤프문제 온라인 액세스

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 statement was blocked by MySQL Firewall.
• B.John has not activated the role.
• C.The DBA needs to execute FLUSH PRIVILEGES.
• D.John needs to reconnect to the database.

Which statement is true about InnoDB persistent index statistics?

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

Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

• A.You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
• B.It fails if at least one of the roles does not exist.
• C.It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
• D.It fails if any of the roles is specified in the mandatory_roles variable.
• E.You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
• F.Existing connections can continue to use the roles' privileges until they reconnect.

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

• A.primary indexes
• B.table data
• C.doublewrite buffer
• D.InnoDB Data Dictionary
• E.change buffer
• F.user privileges

Which three are characteristics of a newly created role? (Choose three.)

• A.It can be granted to user accounts.
• B.It can be renamed using the RENAME ROLE statement.
• C.It is stored in the mysql.role table.
• D.It is created as a locked account.
• E.It can be protected with a password.
• F.It can be dropped using the DROP ROLE statement.