A logistics company created a shipments table but later deci…

A logistics company created a shipments table but later decided they no longer need it. Which SQL statement should they run to completely remove the table structure and data? DELETE TABLE shipments; TRUNCATE TABLE shipments; DROP TABLE shipments; REMOVE TABLE shipments; Answer: DROP TABLE shipments; Explanation: DROP TABLE removes the table structure and its data entirely. TRUNCATE deletes only the data but keeps the structure. DELETE TABLE and REMOVE TABLE are invalid SQL.

A financial services firm keeps client information in a tabl…

A financial services firm keeps client information in a table called clients. If an analyst only needs to see the first name and last name of each client, which SQL statement should they use? SELECT * FROM clients SELECT firstname, lastname FROM clients SELECT firstname AND lastname FROM clients SELECT name FROM clients Answer: SELECT firstname, lastname FROM clients Explanation: Listing column names separated by commas allows retrieval of only those specific fields. Using * would pull all fields, AND is not valid in a SELECT list, and name would be incorrect unless the table had a single name column.