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

MySQL - Quiz(MCQ)

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

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

Correct Answer : SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Recently Updated in MySQL Questions

What is the shebang line?

Correct Answer : #!

Explanation : The Perl scripts are text files, which can be ceated using any text editor. All Perl scripts generally begin with a #! (shebang) line. A script is a file containing a sequence of commands.

The line that is written at the top of the script to write a Perl script using CGI.pm is ______

use CGI

put CGI

include CGI

use this CGI

Correct Answer : use CGI

Explanation : In order to write a Perl script that uses the ‘CGI.pm’ module, a ‘use CGI’ statement is included near the beginning of the script that imports the function names of the module.

What does CGI stand for?

Computer Gateway Interface

Computer Generated Interface

Common Generated Interface

Common Gateway Interface

Correct Answer : Common Gateway Interface

Explanation : The ‘CGI.pm’ module is so called because it helps write scripts that use the ‘Common Gateway Interface’ protocol which defines how a web server communicates with other programs.