70-433 · Question #110
You have a table named Sales.PotentialClients. This table contains a column named EmailAddress. You are tasked to develop a report that returns valid ".com" email addresses from…
The correct answer is C. select * from Sales.PotentialClients. If "at least" expression refer to both "one character before..." and "one character after...", then A is correct. If "at least" expression refer to only "one character before..." which seems the case, then C is correct.
Question
You have a table named Sales.PotentialClients. This table contains a column named EmailAddress. You are tasked to develop a report that returns valid ".com" email addresses from Sales.PotentialClients. A valid email address must have at least one character before the @ sign, and one character after the @ sign and before the ".com." You need to write a Transact-SQL statement that returns data to meet the business requirements. Which Transact-SQL statement should you use?
Options
- Aselect * from Sales.PotentialClients
- Bselect * from Sales.PotentialClients
- Cselect * from Sales.PotentialClients
- Dselect * from Sales.PotentialClients
How the community answered
(22 responses)- A5% (1)
- B18% (4)
- C73% (16)
- D5% (1)
Explanation
If "at least" expression refer to both "one character before..." and "one character after...", then A is correct. If "at least" expression refer to only "one character before..." which seems the case, then C is correct.
Topics
Community Discussion
No community discussion yet for this question.