Skip to main content

Posts

Showing posts with the label MySQL Test Answers Upwork 2019

MySQL Test Answers Upwork 2019

What kind of joins does MySQL support? Answers: dual join right join natural join middle join STRAIGHT_JOIN What is true regarding the SET data type? Answers: A SET can have zero or more values A SET value may contain a comma A SET can have a maximum of 64 different members MySQL stores SET values as strings None of the above is true Which of the following are true in case of Indexes for MYISAM Tables? Answers: Indexes can have NULL values BLOB and TEXT columns can be indexed Indexes per table cannot be more than 16 Columns per index cannot be more than 16 Below is the table “messages,” please find proper query and result from the choices below. Id   Name   Other_Columns ————————- 1    A       A_data_1 2    A       A_data_2 3    A       A_data_3 4    B  ...