MYSQL INTERVIEW QUESTION & ANSWERS
| 31. |
What statement do you use to drop the test database? |
| |
DROP DATABASE ‘database name’ |
| 32. |
Can we use a single DROP TABLE statement to drop several tables simultaneously? |
| |
Yes, DROP TABLE table1, table12, table13;
|
| 33. |
Tell me the result for the following statement. SELECT 1/0; |
| |
|
| 34. |
Explain SELECT statement. |
| |
SELECT can serve to evaluate expressions, but it’s more commonly used to retrieve values from a table. To retrieve information from a table, it’s necessary to identify the table by adding a FROM table_name clause following the list of
values to display.
|
| 35. |
What command do you use to display the structure of the table? |
| |
DESCRIBE ‘ table_name’;
|
