Which statement retrieves all columns from a table named orders?

• A. SELECT ALL COLUMNS FROM orders;
• B. SELECT * FROM orders;
• C. SELECT COLUMNS FROM orders;
• D. GET * FROM orders;

Answer: (B)

To fetch all columns from a table, use the wildcard * in the SELECT clause. This tells SQL to return every column defined for each row in the table. So the statement SELECT * FROM orders returns all columns for every row in orders.

The other forms aren’t valid SQL or don’t mean “all columns.” Using a word like ALL COLUMNS or COLUMNS isn’t recognized by SQL in this context, and GET is not a valid SQL keyword for selecting data. If you ever need only specific columns, you would list those column names instead of *.