Show the contents of the table TEAM using a DML statement.
SELECT * FROM TEAM;
Explanation
The question asks to show the contents of the TEAM table using a DML statement. According to the context, DML (Data Manipulation Language) includes SQL statements such as insert, select, update and delete. To display or show the contents of a table, the SELECT statement is used. The asterisk (*) is used to select all columns from the table. After executing this query, the output would display the four rows that were inserted: (1, Team Titan), (2, Team Rockers), (3, Team Magnet), and (4, Team Hurricane).
Solution Steps
Step 1: Identify that showing contents requires a SELECT statement (a DML command).
Step 2: Use SELECT * to retrieve all columns from the TEAM table.
Step 3: Write the complete SQL query: SELECT * FROM TEAM;