Online Access Free 1z1-883 Practice Test

Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?

• A.Check the command-line options provided for the Mysql Server and compare them with default values.
• B.Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
• C.Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
• D.Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?

• A.Table_definition_cache
• B.Max_heap_table_size
• C.Table_open_cache
• D.Tmp_table_size
• E.Table_open_cache_instancs
• F.Max_tmp_tables

What are three actions performed by the mysql_secure_installation tool?

• A.It verifies that all users are configuration with the longer password hash.
• B.It prompts you to set the root user account password.
• C.It asks to remove the test database, which is generated at installation time.
• D.It can delete any anonymous accounts.
• E.It checks whether file permissions are appropriate within datadir.

Which three are properties of the MyISAM storage engine?

• A.Table level locking only
• B.Geospatial indexing
• C.HASH index support
• D.FULLTEXT indexing for text matching
• E.Foreign key support
• F.Table and page level locking support
• G.Transaction support

Which two statements are true about InnoDB auto-increment locking?

• A.InnoDB never uses table-level locks.
• B.Some settings for innodb_autoinc_lock_mode can help reduce locking.
• C.InnoDB always protects auto-increment updates with a table-level lock.
• D.The auto-increment lock can be a table-level lock.
• E.InnoDB does not use locks to enforce auto-increment uniqueness.