mysql>SHOWGRANTSFORjsmith;

+------------------------------------------------------------------------------+

|Grants for jsmith@% |

+------------------------------------------------------------------------------+

|GRANT USAGE ON ∗.∗ TO jsmith’@’%’ |

|GRANT UPDATE(NamE.ON ‘world’. ‘country’TO ‘jsmith ‘@’%’|.

+-------------------------------------------------------------------------------+

Which two SQL statement can jsmith execute?

Has never been reached.You find that the disk system on the master has failed and as a result, the data on the master is completely Unrecoverable. 

Which two statements are true?

Which two statements are true?

are two major concerns of running an installation with incorrect file privileges?

Which two statements reflect how MySQL Server handles the table definition changes?

SELECR city.CountryCode,contry,Name AS Country_Nae,

FROM world.city

INNER JOIN world.country ON country.Code =city.CountryCode

WHERE country.Continent=’Asia’

AND city.Population >100000

ORDER BY city,Population DESC\G

***********************************1.row*****************************

EXPLATN:

->Sort <temporary>.Poppulation DESC(acctual time =8.306..8.431 row =125 Ioope=1)

->Strem resule(acctual time =0.145..8.033 row =125rows=125 Ioope=1)

->Nested loop inner join (cost=241.12 rows=205) (acctual time =0.141.7.787 row =155 Ioope=1)

->Filter (world.country,Continent =’Asia’)(cost=25.40 rows=34)(acctual time =0.064..0.820 row =51

Ioope=51)

->index lookup on city using CountryCode(Countrycode=world.country.code)(acctual time =4.53..row =10 )

1 row in set (0.0094 sec)

Which two statements are true?

Cluster.setInstanceOption()’host1:3377’,’MenmberWeight’,30)

Cluster.setInstanceOption()’host1:3377’,’MenmberWeight’,40)

Cluster.setInstanceOption()’host1:3377’,’exitStateAction’,”ABORT_SERVER”)

Now examine the partial staus:

“topology”;{

”host1:3377”:

“address”:”host1:3377”,

“mode”:”R/O”,

[...]

“statue”:”ONLINE”,

“version”:”8.0.18”

},

“host2:3377”:{

“address”:”host2:3377”,

“mode”:”R/O”,

[...]

“statue”:”ONLINE”,

“version”:”8.0.18”

},

“host3:3377”:{

“address”:”host3:3377”,

“mode”:”R/O”,

[...]

“statue”:”ONLINE”,

“version”:”8.0.18”

}

}

A permanent network failure isolates host3.

Which two statements are true?