MCQOPTIONS
Saved Bookmarks
| 1. |
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute? |
| A. | EXEC sp_defaultdb 'Andrew','FinanceData' |
| B. | GRANT ALL ON FinanceData TO Andrew |
| C. | EXEC sp_addlogin 'Andrew' |
| D. | EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew' |
| Answer» B. GRANT ALL ON FinanceData TO Andrew | |