Question 14 : 70-464 SQL Server 2012 | Free practice exams

Question 14

You've created a simple select statement that returns the customers first name and last name. This statement needs changing so that it only includes the customers first initial and their last name in the result set. There is no column for initial. Which function could you use to get the initial?

SUBSTRING
STUFF
REPLACE
RTRIM

You could do something like this:

SELECT LastName, SUBSTRING(FirstName, 1, 1) AS Initial

This is a sample question. You can start the practice exam by clicking the 'Start Practice Exam' link on the exam page.

Back to practice exam

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