MYSQL Interview Practice #2

Q1. Which of the following can add a row to a table?







Q2. If You Want To Undo A GRANT, You Should Use?







Q3. What will be the output of the following query?

Select round(69999.99,-2);






Q4. MySQL runs on which operating systems?







Q5. What will be the output of the below query?

SELECT INSTR("INDIA", "DI");







Q6. Which of these field types would be best to hold a .jpg image?







Q7. To remove duplicate rows from the result which keyword we use with SELECT?







Q8. Which datatypes are treated as arrays?







Q9. What will be the output of the below query?

SELECT LENGTH("WINNER")






Q10. Which clause is used to sort the result of SELECT statement?