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

With SQL, how do you select a column named "FirstName" from a table named "Persons"?Select one:a.SELECT Persons.FirstNameb.SELECT FirstName FROM Personsc.EXTRACT FirstName FROM Personsd.SELECT FirstName.TableName FROM Personse.None of the answers are correct

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

With SQL, how do you select all the records from a table named "Persons" with the criteria that the column named "FirstName" is "Peter" and the column named "LastName" is "Jackson"?Select one:a.SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'b.SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'c.All of the answers are correctd.SELECT FirstName='Peter', LastName='Jackson' FROM Persons

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

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