M

Mr. Dubey • 52.30K Points
Coach 

Q. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

(A) SELECT * FROM Persons WHERE FirstName=’a’
(B) SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
(C) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
(D) SELECT * FROM Persons WHERE FirstName=’%a%’
Correct : Option (C)

Share

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs

Q. Uses cases are represented as ________ within the system rectangle.

Q. What license is Hadoop distributed under?

Q. For a phase modulated signal, the frequency deviation is proportional to

Q. Any electronic holding place where data can be stored and retrieved later whenever required is

Q. What is the value of the sum of the minimum in-degree and maximum out-degree of an Directed Acyclic Graph?

Q. The role of the is to convert the collector current into a voltage in RTL.

Q. What is on-demand mail relay (ODMR)?

Q. Which of the following is a message queue or transaction system for distributed Internet-based applications?

Q. Choose the correct statements.

Q. Blum Blum Shub Generator is based on which Algorithm?