READ Free Dumps For Microsoft- 70-461
| Question ID 15157 | You have three tables that contain data for dentists, psychiatrists, and physicians. You
create a view that is used to look up their email addresses and phone numbers.
The view has the following definition:
You need to ensure that users can update only the phone numbers and email addresses
by using this view.
What should you do?
|
| Option A | Alter the view. Use the EXPAND VIEWS query hint along with each SELECT statement.
|
| Option B | Create an INSTEAD OF UPDATE trigger on the view.
|
| Option C | Drop the view. Re-create the view by using the SCHEMABINDING clause, and then create an index on the view.
|
| Option D | Create an AFTER UPDATE trigger on the view.
|
| Correct Answer | B |
Explanation Reference: http://msdn.microsoft.com/en-us/library/ms187956.aspx
| Question ID 15158 | You use Microsoft SQL Server 2012 to develop a database application.
You create a table by using the following definition:
CREATE TABLE Prices (
PriceId int IDENTITY(1,1) PRIMARY KEY,
ActualPrice NUMERIC(16,9),
PredictedPrice NUMERIC(16,9)
You need to create a computed column based on a user-defined function named
udf_price_index. You also need to ensure that the column supports an index.
Which three Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)
|
| Option A | 
|
| Correct Answer | A |
Explanation