Хотелось бы услышать мнение по следующим вопросам:
Вопрос 1
You are a database developer for a large travel company. Information about each of the company’s
departments is stored in a table named Department. Data about each of the company’s travel agents and
department managers is stored in a table named Employees. The SQLLogin column of the Employees table
contains the database login for the travel agent or department manager. The Department and Employees table
are shown in the exhibit.
Each department manager has been added to the Managers database role. You need to allow members of this
database role to view all of the data in the department table. Members of this role should be able to insert or
update only the row that pertains to their department.
You grant the Managers database role SELECT permissions on the Department table. What should you do
next?

Exhibit:

Department:
DepartmentId
DepartmentName
TotalB

Employees:
EmployeeId
EmployeeName
SQLLogin

A. Create a trigger on the Department table that checks whether the database login of the user performing the
insert or update operation belongs to a member of that department.
B. Create a view that includes all columns in the Department table and the SQLLogin column from the
Employees table.
C. Include the WITH CHECK OPTION clause in the view definition.
D. Grant INSERT and UPDATE permissions on the Department table.
E. Grant INSERT and UPDATE permissions on the SQLLogin column of the Employees table.

и Вопрос 2:
You are a database developer for a marketing firm. You have designed a quarterly sales view. This view joins
several tables and calculates aggregate information. You create a unique index on the view. You want to
provide a parameterized query to access the data contained in your indexed view. The output will be used in
other SELECT lists.
How should you accomplish this goal?
A. Use an ALTER VIEW statement to add the parameter value to the view definition.
B. Create a stored procedure that accepts the parameter as input and returns a rowset with the result set.
C. Create a scalar user-defined function that accepts the parameter as input.
D. Create an inline user-defined function that accepts the parameter as input.

Дело в том что UCertify и TestKing дают обсолютно разные ответы. Хотелось бы послушать ваши варианты ответов с объяснениями.

По поводу первого вороса я тоже в начале отетила А. Однако есть прекрасная возможность реализовать представление :

CREATE VIEW Solution
AS
SELECT DepartmentID, DepartmentName, TotalBudget, SQLLogin
FROM Department INNER JOIN Employees
ON Department.DepartmentID = Emplyees.DepartmentID
WHERE SQLLogin = USER_NAME()
WITH CHECK OPTION

и тогда верен ответ B.
А насчет второго вопроса так я тоже ответила D. Однако там сказано именно SELECT list если это понимать как список значений в разделе SELECT то верен ответ С. Очень даже возможен вариант когда входным параметром для функции является какое-то поле таблицы. Так что тут можно и подумать.