Which clause filters JOIN results?

The _____ SQL command changes one or more fields in a record.

The datatype for single precision floating point number is ____________ 

The left and right joins are also known as __________ 

 Which is the MySQL instance responsible for data processing? 

The indicator of presence or absence of a word in search is used in which mode? 

 To perform a delete on a single-table, how is the name of a column qualified?
 

Which mode tells the server to recognize || as the string concatenation operator? 

Which of the following options correctly describes the DML (Data Manipulation Language) category?

What will be the output of the following query?

 SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’ OR LEFT (lname, 1) =’F’;