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

Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?

• A.Because InnoDB stores pointers in a log to all the primary keys and shorter keys make this log smaller.
• B.Because InnoDB uses primary keys to locate tables, and shorter keys make quicker lookups.
• C.Because InnoDB uses primary keys to locate table rows, and shorter keys make quicker lookups.

When working with replication, why might you want to stop the SQL thread on the slave while keeping the I/O thread running? (Choose two)

• A.So that events for the slave do not get backlogged on the master.
• B.So that remaining events can be processed while not receiving new events from the master.
• C.So that no changes are made while making backups.

In the following query, the Population column is indexed: mysql> EXPLAIN SELECT Name -> FROM Country -> WHERE Code LIKE '%B%' AND Population > 10000 *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: ALL possible_keys: i_pop key: NULL key_len: NULL ref: NULL rows: 239 Extra: Using where
Which of the following best describes how to deal with the key value of the EXPLAIN output? (Choose two)

• A.Use FORCE KEY
• B.Use USE POSSIBLE_KEY
• C.Use FORCE INDEX.
• D.Use USE INDEX.

The password for the existing user 'kofi'@'agric.comp1.com' must be changed to "Sakila". Which of the following will do that?

• A.SET PASSWORD FOR 'kofi'@'agric.comp1.com' = 'Sakila'
• B.SET PASSWORD FOR 'kofi'@'agric.comp1.com' = PASSWORD('Sakila')
• C.SET PASSWORD 'Sakila' FOR 'kofi'@'agric.comp1.com'
• D.SET PASSWORD('Sakila') FOR 'kofi'@'agric.comp1.com'

The account 'ulf'@'localhost' has previously been created with the statement
GRANT ALL PRIVILEGES ON *.* TO 'ulf'@'localhost' IDENTIFIED BY 'w01f' This account should no longer be used, so you issue the following command:
REVOKE ALL PRIVILEGES ON *.* FROM 'ulf'@'localhost'
After executing this statement, you inspect the server and find that no clients are connected using that account. However, the next day you notice that the account 'ulf'@'localhost' is indeed connected to the server. Why is it still possible for the account 'ulf'@'localhost' to connect to the server?

• A.Specifying GRANT ALL PRIVILEGES ON *.* effectively created an administrator account, which cannot be disabled through the REVOKE statement
• B.The ON *.* clause should not be specified when disabling an account
• C.The REVOKE statement used does not remove the USAGE privilege from the account, allowing new connections with that account.
• D.The REVOKE command was not followed by a FLUSH PRIVILEGES command, so the account was never actually disabled