What does the query "SELECT NOW()" gives?

 To create or drop events for a database, which privilege should be granted? 

Which feature is used for automatic increment of the column? 

Without the LOCAL keyword, LOAD DATA is _________________

The join where all possible row combinations are produced is called _________ 

Which SQL keyword is used to remove duplicate rows from the result set?

What is preferred when stored procedures are not being used?

   The option that executes all SQL statements in a SQL script irrespective of the number of errors is _______________
 

In the following query “person” stands for

 SELECT person_id, fname, lname, Birth_date    FROM person; 

What will be the output of the following query?

SELECT *
FROM employee
WHERE start_date BETWEEN ‘2007-01-01’ AND ‘2008-01-01’;