Which of the following is not a valid aggregate function?

  Which keyword used with UNION does not retain duplicate rows?
 

 Which of these modes is a composite server mode? 

  Is it necessary to insert the value in each column of the table? 

On what does the default case sensitivity of database and table names depends on?

What is meant by the term 'candidate key'?

. What will be the output of the following query?

SELECT *
FROM employee
WHERE start_date>=’2007-01-01’ AND
       Start_date<=’2005-01-01’

If the table 'account' has a column 'cust_id' with the values {1, 2, 2, 3, 3, 5, 6, 7, 8, 8}, what will be the output of the following MySQL statement?

SELECT DISTINCT cust_id
FROM account;

 Which among the following is the correct syntax for modifying the definition of an existing table? 

What will be the output of the following query?

 SELECT * FROM employee WHERE lname LIKE ‘F%’ AND lname LIKE ‘%T’;