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

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.

Post |

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

You add the following method to compare a hashed password with a plaintext password: private bool IsPasswordMatch(byte[] hashedPassword, string text) { byte[] bytes = Encoding.Unicode.GetBytes(text); SHA1Managed SHhash = new SHA1Managed(); } You need to add code to return true if the given password matches the hashed value. Which code segment should you add?

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

Your application retrieves sensitive encrypted data from a data source and decrypts it. You need to minimize risk that a malicious program could retrieve the decrypted text after it is used because the application cannot delete the data from computer memory. Which class should you use to store the decrypted text?

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

You are reviewing an Entity Framework application to ensure that it adheres to security best practices. You need to identify coding practices that present a security risk. Which practice do you identify?

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

You have implemented a database application that uses a SQL Server database. The application has the following characteristics: * The application uses LINQ to SQL to generate commands to retrieve data. * The application uses LINQ to SQL to call configured stored procedures to update data. The application uses Windows Authentication to connect to the database. Your data administrator grants the following SQL Server permissions: * All users are given permissions to read and write to tables used by the application. * All users are given permission to execute stored procedures used by the application. You need to identify violations of the principle of least privilege. Which practice do you identify?

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

Your application requires users to log on with a user name and password. You are implementing a method that uses the SHA1Managed class to hash the password to store. You need to create a hash of the password while minimizing the risk of a dictionary attack. What should you do to minimize the risk of a dictionary attack?

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

You are developing an occasionally connected smart client database application. When the application is offline, users must be able to enter data. When the application returns online, it should upload added data to a corporate Microsoft SQL Server database. You must choose a solution for offline caching and synchronization. Synchronization should require the least amount of developer effort, and caching should require a minimal footprint. What should you do?

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

You are using Microsoft Visual Studio 2010 to develop an occasionally connected smart client. You want to add a Microsoft SQL Server Compact 3.5 database to your project and add code to synchronize this database with an existing corporate SQL Server 2008 database. In Visual Studio 2010, you must start the workflow that creates a local database and generates synchronization classes. What should you do?

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

You are developing an occasionally connected smart client. You use Sync Services to periodically synchronize a local Microsoft SQL Server Compact 3.5 database with a corporate database. After synchronization, you want to log a count of both rows that successfully uploaded and rows that could not be uploaded. You must choose a class that provides this information. Which class should you choose?

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

You are developing an occasionally connected smart client used by service technicians. The application downloads a dataset when online. When the application is offline, the application must persist changes made to the dataset. When the application returns online, the application must upload local dataset changes and refresh the local dataset. You must choose a robust solution for local data persistence and merging. Your solution should require minimal client memory. What should you do?

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

You are developing an occasionally connected smart client. The application uses Sync Services to synchronize a local Microsoft SQL Server Compact 3.5 database table periodically with the corresponding table in a corporate database. The application uses a strongly typed TableAdapter to populate a DataSet from the local table. This DataSet is displayed in a read-only DataGridView. Your application includes code to detect if the application has returned online and requires synchronization. When this condition is detected, you must synchronize data and ensure that the displayed data is up to date. What should you do?

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

You are creating a corporate WPF application that uses Entity Framework. You deploy Entity Framework entities and object context to an assembly named Contoso.Data.dll. The application installs this assembly to the GAC and is shared by other applications. You need be able to do the following: * Version the shared assembly independently of the application. * Deploy the shared assembly with your application. * Ensure that the assembly cannot be uninstalled if another installed application needs it. What should you do?

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

You are deploying an Entity Framework application. You need to deploy it in such a way that you are not required to recompile and redeploy the application every time the conceptual model is updated. Your solution should require minimal effort. What should you do?

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

You manually define the model and mapping files for an Entity Data Model application. You need to ensure that the files are deployed as embedded resources together with the application. Your solution should require minimal effort. What should you do?

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

You are implementing a custom console application to host a WCF Data Service. You need to implement the class that hosts and instantiates the data service. Which class should you extend?

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

You are creating a deployment plan for a Windows Communication Foundation (WCF) Data Service. You need to decide how to host the service. Which application type can you use

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

Which method of the SQlCommand class used to read the data from top to bottom with connected architecture environment?

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

What is Dapper ?

dapper is a Micro- ORM (object-relation Mapper) means does not provides all features of full ORM like LINQ-to-SQL or Entity Framework.

It works across all ADO.Net providers including Sqlite, oracle, MySQL and SQL.

It comprises of a single file (SqlMapper.cs.), which is lives on Google (code.google.com/p/dapper-dot-net/source/browse/Dapper/SqlMapper.cs )

Dapper does not manage your connection's lifecycle.

You can either include the file, as is, in your project. Or install it via nuget.

Main focuses on making the materialization as fast as possible, with no overheads from things like identity managers - just "run this query and give me the typed data.

In which scenario Entity Framework provides better result ?

Select the Entity Framework when you

1) Wan to implement the Data layer.
2) Want to Require strongly typed objects.
3) Want to RA(rapid application) development.

What is Mars in ADO.NET

It was a new feature supported from ADO.NET 2.0 version.
You can have multiple SqlDataReaders open on a single connection with each sqlreader assigned to new SqlCommand

In previous versions, only one batch could be executed at a time against a single connection.

What do you mean by Projection, Eager loading, Deferred(lazy) loading, Navigating in Entity Framework?

Projection :
Selecting specific properties or expressions in a query, rather than the entity being
queried. For example: from c in context.contacts select c.firstname + c.last
name, c.contactID.

Eager loading :
Requesting that related data be returned along with query results from the database.
For example: when querying contacts, eager-load their addresses. The contacts
and their addresses will be retrieved in a single query.

Deferred(Lazy) loading :
Delaying the loading of related data until you specifically request it. For example:
when working with query results for a particular contact, you can make a request
to retrieve that contact’s addresses from the database. When deferred loading happens automatically (implicitly), it is called lazy loading.

Navigating :
Moving from an entity to its related data. For example: navigate from a contact to
its addresses using the contact.Addresses property.