Which SQL statement is used to retrieve all columns from a table?OptionsSELECT FIELDSSELECT ALLSELECT *SELECT COLUMN

Which SQL clause is used to specify the columns to retrieve in a query?OptionsSELECTWHERECOLUMNFROM

Which one of these is used with SELECT clause to fetch all columns from a table? ALL*DISTINCTAS

Which of the following command is used to select all the fields available in the table?Select one:ALL%*#

How would you select all columns from a table named "expenses"?SELECT columns FROM expenses;SELECT * FROM expenses; SELECT ALL FROM expenses;SELECT expenses;

With SQL, how do you select all the columns from a table named "Persons"?Select one:a.SELECT Personsb.SELECT [all] FROM Personsc.SELECT *.Personsd.None of the answers are correcte.SELECT * FROM Persons