You work with a table that has one column for name. Some of these names have prefixes. You want to identify all of the doctors. Which query will return every name that starts with the prefix ‘Dr.’?

Tools of the Trade: Linux and SQL | Weekly challenge 4 Quiz | 

You work with a table that has one column for name. Some of these names have prefixes. You want to identify all of the doctors. Which query will return every name that starts with the prefix ‘Dr.’?

• WHERE name LIKE ‘Dr._’;
• WHERE name = ‘Dr.%’;
• WHERE name LIKE ‘Dr.%’;
• WHERE name = ‘Dr._’;