70-516 · Question #45
You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses Integrated Windows authentication. The application accesses data in a Microsoft SQL Server 2008 database…
The correct answer is C. command.CommandText = "USE [pubs]; exec uspLoginAudit;". Working with Multiple Active Result Sets
Question
You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses Integrated Windows authentication. The application accesses data in a Microsoft SQL Server 2008 database that is located on the same server as the application. You use the following connection string to connect to the database. Integrated Security=SSPI; Initial Catalog=AdventureWorks; The application must also execute a stored procedure on the same server on a database named pubs. Users connect to the ASP.NET application through the intranet by using Windows-based authentication. You need to ensure that the application will use connection pooling whenever possible and will keep the number of pools to a minimum. Which code segment should you use?
Options
- Acommand.CommandText = "USE [pubs]; exec uspLoginAudit;";
- Bcommand.CommandText = "exec uspLoginAudit;";
- Ccommand.CommandText = "USE [pubs]; exec uspLoginAudit;";
- Dcommand.CommandText = "exec uspLoginAudit;";
How the community answered
(31 responses)- A19% (6)
- B3% (1)
- C71% (22)
- D6% (2)
Explanation
Working with Multiple Active Result Sets
Topics
Community Discussion
No community discussion yet for this question.