Câu 32: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

DRAG DROP -You have a Microsoft SQL Server database. The database contains a group of tables created by using the following Transact-SQL statements: You need to write a query that returns all the salesperson's phone numbers and an indicator as to whether you can contact the salesperson using that number. The indicator must meet the following requirements: ✑ If the phone number is a work phone number, the indicator should show the value "˜Allow Calls'. ✑ If the phone number is NULL, the indicator should show the value "˜Unrecognized Phone Type'. ✑ In all other cases, the indicator should show the value "˜Do Not Call'.Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order. Select and Place:

1. A. Lựa chọn A bằng hình ảnh — đáp án hiện tại