Delete Query


  1. A multiple-table delete can apply any join.











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: B

    In MySQL, a multiple table ‘DELETE’ operation can be performed on the tables combined using any kind of ‘JOIN’ operation. The syntax also allows for deleting rows from multiple tables at once.


  1. What is xyz in the following statement?
    DELETE FROM Employee WHERE Emp_id= 0012;











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: C

    The operation being performed in the statement is the ‘DELETE’. The table name is ‘xyz’ and column name is ‘abc’. When this statement is executed, rows having abc value equal to 5 get deleted.


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











  1. View Hint View Answer Discuss in Forum

    NA

    Correct Option: D

    In MySQL, performing the operations ‘UPDATE’ and ‘DELETE’ on a single-table does not require qualifying the column name of the table in the database with the table name of the database.