ADO.NET Interview Questions and Answers (445) - Page 12

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

445 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

You are implementing an application that must use a trusted connection to access data from a SQL Server database named NorthWind on a server called dataServer. You need to ensure that the application can have more than one pending request per connection, and, in particular, have more than one active default result set per connection What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing an ASP.NET Web application that connects to a Microsoft SQL Server database using the following connection string: server=.;database=NorthWind;Integrated Security=SSPI;Min Pool Size=10;Max Pool Size=100 Users authenticate to the Web application using their Microsoft Windows credentials. You must determine how many connection pools the application will create to ensure that connection resource usage is optimized. How many connection pools will the application create?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing an ASP.NET Web application that connects to a Microsoft SQL Server database using the following connection string: server=.;database=NorthWind; User Id=application1; Password= h85hEveR; Min Pool Size=10;Max Pool Size=100 You must determine how many connection pools the application will create to ensure that connection resource usage is optimized. How many connection pools will the application create?

NOTE: This is objective type question, Please click question title for correct answer.

You are creating an application that uses a relational database. Your application supports several database types. Upon installation of your application, an administrator will select the specific database to use. You must choose a data access strategy to support multiple databases. Your solution should use the data provider that offers the best performance. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You deploy a number of ASP.NET Web applications to a single server. The applications connect to Microsoft SQL Server databases and rely on connection pooling to minimize the cost of opening connections. You find that after a period of several days, pool fragmentation begins to consume excessive memory. You must fix the problem without affecting connection pool creation. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your ASP.NET application uses connection pooling to connect to a database. You find that the following exception is logged when the application is under heavy load: Exception: System.InvalidOperationException Message: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. You must fix the problem without causing undue overhead to build connections. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your ASP.NET application uses connection pooling to connect to a database. You find that the following exception is logged repeatedly after the application runs for a few hours: Exception: System.InvalidOperationException Message: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Once this exception occurs, the application is no longer able to connect to the database. You find that when you restart the application, it can connect again for a few hours. You must fix the problem and make sure that it no longer occurs. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are designing an ASP.NET Web application that connects to a Microsoft SQL Server database. This application will have thousands of concurrent users. You must choose a connection strategy that optimizes database resources. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your application uses the Microsoft .NET Framework Data Provider for SQL Server to access a Microsoft SQL Server database. You connect to the database using integrated security and query all rows in a table. You want to catch and log any exception that is caused if the credentials provided do not have read access to the table in the database. You do not want to handle other exception types. Which exception should you use?

NOTE: This is objective type question, Please click question title for correct answer.

You are reviewing the following code, which executes a command based on the user input entered into a TextBox control: SqlConnection conn = new SqlConnection("Persist Security Info=False;"+ "Integrated Security=SSPI;database=northwind;server=dataServer"); string commandText = string.Format("SELECT * FROM Customers WHERE LastName='{0}'", txtBoxLastName.Text); SqlCommand cmd = new SqlCommand(commandText, conn); You must make recommendations to improve security. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing a WPF application that must access data from a SQL Server database named northwind on server dataServer. You need to connect with a trusted connection that uses the identity of the currently logged-on user. Which connection string should you choose?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing an ASP.NET Web application that must access a SQL Server database named northwind on server dataServer. You need to connect with SQL Server login account credentials created for the application. Which connection string should you choose?

NOTE: This is objective type question, Please click question title for correct answer.

You are designing an ASP.NET Web application that will connect to a Microsoft SQL Server database using predetermined credentials. You must choose the most secure strategy for storing connection strings. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing an ASP.NET Web application that will connect to a Microsoft SQL Server database using predetermined credentials. You need to encrypt the Web.config configuration section that contains the connection string. Which tool should you use?

NOTE: This is objective type question, Please click question title for correct answer.

You are designing an application that will use Entity Framework to access a SQL Server database. The application must adhere to the following security requirements: * Applications cannot store connection strings that include user and password information and applications cannot prompt the user for this information. * Nonadministrator Windows logins can only be granted permission to read from tables and execute stored procedures. You need to ensure that your connection type and Entity Data Model meet these requirements. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are reviewing an application that accesses a SQL Server database. The application uses the following connection string: MultipleActiveResultSets=True;Encrypt=True;Persist Security Info=True; user id=username;password=password;database=northwind;server=dataServer where username is the SQL Server login and password is the password associated with that account. You need to minimize the chance that malicious code can access SQL login credentials. Which configuration string parameter should you set?

NOTE: This is objective type question, Please click question title for correct answer.

You add the following method to an application that uses LINQ to SQL: public Person LookupStudent(intstudentId) { using (var dataContext = new SchoolDataClassesDataContext()) { return dataContext.Persons.FirstOrDefault(p =>p.PersonID == studentId); } } You find that the following code throws an exception when attempting to iterate the child entities given by the StudentGrades property: var student = LookupStudent(studentId); foreach (var g in student.StudentGrades) { // } You need to modify the LookupStudent method to fix the exception. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing a Windows Communication Foundation (WCF) service that uses Entity Framework. Several service methods will return entities; other methods will write changes made to entities to the database. You need to decide when to create the ObjectContext and how to configure the ObjectContext to use minimal memory. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing a library that uses Entity Framework. You create several repository classes to isolate domain objects from details of Entity Framework persistence. You create a unit of work class to track the changes to entities during one logical transaction. When a logical transaction enlists operations using different repository objects, the repositories will share a unit of work instance. You need to decide where to create ObjectContext instances. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing a Windows Communication Foundation (WCF) service that uses Entity Framework to return POCO entities. The POCO entities do not need to track changes as the changes occur or support lazy loading of the related objects. You need to ensure that POCO entities can be easily serialized with the default DataContractSerializer. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

1
...
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
...
23

More ADO.NET Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting