单项选择题
A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’ The new employee reports that when he logs in， he receives the following error message： "Login failed. The user is not associated with a trusted SQL Server connection." You need to resolve the error and allow the new employee to gain access to SQL1.
What should you do？（）
A.Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.
B.Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.
C.Ensure that the login name is created with square brackets （[]）.
D.Give the login access to a specific database by using the CREATE USER Transact-SQL statement.
相关考题
-
单项选择题
TestKing.com has multiple servers in a distributed environment. You work with two SQL Server 2005 computers named SQL1 and SQL2. Each server uses SQL Server Authentication and they use different logins. You need to write a distributed query that joins the data on SQL1 with the data on SQL2. What should you do？（）
A.Ensure that both SQL1 and SQL2 use the same login name as the security context foreach server.
B.Configure SQL2 as a remote server. Write the query on SQL1.
C.Configure SQL2 as a linked server to impersonate the remote login.
D.Configure SQL2 as a distributed server. Use pass-through authentication. -
多项选择题
TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）
A.Remove all deterministic function calls from within the view.
B.Remove all nondeterministic function calls from within the view.
C.Schema-bind all functions that are called from within the view.
D.Create the view and specify the WITH CHECK OPTION clause. -
单项选择题
You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）
A.Update the view to use an outer join between the Customers and Sales tables.
B.Create a clustered index on the v CustomerSales view.
C.Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
D.Create a stored procedure for the business analysts that uses the v CustomerSales view.
