Question

Assume that a table a has been created that has one attribute called a_value of type varchar(20). Records have been inserted, and for one of those records a_value is the string 'Zechariah'. For which of the following queries will this record be returned correctly?

		select * from a where a_value like 'Zech%';
		select * from a where a_value = 'Zech*';
		select * from a where a_value = 'Zech';
		select * from a where a_value = 'Zech'*;

Answer 1

Assume that a table a has been created that has one attribute called a_value of type varchar(20).

Records have been inserted, and for one of those records a_value is the string 'Zechariah'.

queries will this record be returned correctly is
select * from a where a_value like 'Zech%';

So, answer is option 1

select * from a where a_value like 'Zech%';