Free Practice Exam -
70-461 - SQL Server 2012
Question 1 of 15
You're designing a new SQL Server 2012 query for the HR department. The query will find records from the persons table for people whose name starts with 'Ja'. Which WHERE statement would be the correct choice?
where (name like 'Ja%')
where (name = 'Ja%')
where (name > 'Ja')
where (name like '%Ja%')
That was the correct answer, well done!
Sorry, that was the wrong answer
If you're using a wildcard search (%) then you must use the like keyword and not equals (=).
Exam Progress
Move on to the next question
Home
Microsoft Exams
Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Home
Copyright © Accelerated Ideas 2005-2020
All rights reserved