Which statement is used to remove a trigger? 

 Which header should be included first? 

Which clause is used to rename the existing table? 

 What enables encrypted connections to be established?
 

Which of these is defined to execute when the table is modified only? 

What is the built-in MySQL function that gives you the current time in an SQL statement?

What is the command to disable autocommit and launch a transaction? 

What does ‘name’ represent in the following code snippet?

 CREATE TABLE student  

  (  

      name CHAR(30),   

     roll_num INT,     

   address CHAR(30),   

     phone CHAR(12)  

  ); 

If the 'fruit' attribute in the 'person' table stores data as 'apple, mango, banana', what will be the output of the following SQL command?

SELECT fruit FROM person WHERE person_id=1 ORDER BY fruit;

What is the significance of “ORDER BY emp_id DESC” in the given query?

 SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;