buy domain website and hosting


SQL Interview Questions and Answers

Languages and Programming

Qus: What is SQL Cache Dependency in ASP.NET?

Ans: SQL Cache Dependency in ASP.NET: It is the mechanism where the cache object gets invalidated when the related data or the related resource is modified.

Qus: Explain the concepts of Post Cache Substitution in .NET

Ans: Post Cache Substitution: It works opposite to fragment caching. The entire page is cached, except what is to be kept dynamic. When [Output Cache] attribute is used, the page is cached.

Qus: Explain the use of localization and Globalization.

Ans: Users of different countries, use different languages and others settings like currency, and dates. Therefore, applications are needed to be configurable as per the required settings based on cultures, regions, countries.

Qus: Explain the concepts of CODE Page approach. What are the disadvantages of this approach?

Ans: Code Page was used before Unicode came into existence. It was a technique to represent characters in different languages.

Qus: What are resource files and explain how do we generate resource files?

Ans: Resource files are files in XML format. They contain all the resources needed by an application. These files can be used to store string, bitmaps, icons, fonts.

Qus: What are Satellite assemblies and how to generate Satellite assemblies?

Ans: To support the feature of multiple languages, we need to create different modules that are customized on the basis of localization. These assemblies created on the basis of different modules are knows as satellite assemblies.

Qus: Define AL.EXE and RESGEN.EXE.

Ans: Al.exe: It embeds the resources into a satellite assembly. It takes the resources in .resources binary format.

Qus: Explain the concepts of resource manager class.

Ans: Resource Manager class: It provides convenient access to resources that are culture-correct. The access is provided at run time.

Qus: What is Windows communication foundation, WCF?

Ans: WCF is a framework that builds applications that can inter-communicate based on service oriented architecture consuming secure and reliable web services.

Qus: Explain the important principle of SOA.

Ans: A service-oriented architecture is collection of services which communicate with one another other.

Qus: Explain the components of WCF - Service class, Hosting environment, END point.

Ans: WCF Service is composed of three components: Service class: It implements the service needed, Host environment: is an environment that hosts the developed service.

Qus: Difference between WCF and Web Services.

Ans: WCF can create services similar in concept to ASMX, but has much more capabilities. WCF is much more efficient than ASP.Net coz it is implemented on pipeline.

Qus: What are different bindings supported by WCF?

Ans: BasicHttpBinding, WSHttpBinding, WSDualHttpBinding.

Qus: What is duplex contract in WCF?

Ans: Duplex contract: It enables clients and servers to communicate with each other. The calls can be initiated independently of the other one.

Qus: Explain the different transaction isolation levels in WCF.

Ans: Read Uncommitted: - Also known as Dirty isolation level. It makes sure that corrupt Data cannot be read. This is the lowest isolation level.

Qus: What are Volatile and Dead letter queues?

Ans: Volatile Queues: There are scenarios in the project when you want the message to deliver in proper time. The timely delivery of message is very more important and to ensure they are not lost is important too. Volatile queues are used for such purposes.

Qus: What is Windows workflow foundation?

Ans: Windows Workflow Foundation (WF): It is a platform for building, managing and executing workflow-enabled applications, for designing and implementing a programming model .
Qus: Explain the types of Workflow in Windows Workflow Foundation.

Ans: There are 3 types of workflows in WWF: Sequential Workflow: The sequential workflow style executes a set of contained activities in order, one by one and does not provide an option to go back to any step.

Qus: What are XOML files? Explain their uses.

Ans: XOML is an acronym for Extensible Object Markup Language. XOML files are the markup files. They are used to declare the workflow and are then compiled with the file containing the implementation logic.

Bookmark and Share




Gallery

Related Topics

Comments



Submit Reviews:


(Enter the characters seen on the image below.)



Promotional Ads

Advertisement

Packers and Movers in Chandigarh
Plot No 636, Near HP Gas Agency, Dariya, Chandigarh - 160101
Plot No 636, Near HP Gas Agency, Dariya, Chandigarh - 160101
Delhi

Maharaja Agrasen Hospital Super Speciality Hospital in Dwarka
H3VH+C7Q, Pocket 4, Sector 1 Dwarka, New Delhi 110075
Delhi

GET DIPLOMA IN DRESS DESIGNING| CONTACT-9810450615
A-100 3rd Floor, Mohan Garden, Nawada, opposite metro pillar no.747, near Uttam Nagar.
Delhi

PRIMARY TEACHER TRAINING(PTT)| SIPVS UTTAM NAGAR
A-100 3rd Floor, Mohan Garden, Nawada, opposite metro pillar no.747, near Uttam Nagar.
Delhi

Aplonis Healthcare
SCF-461, 1st floor
Motor Market, Sector-13,
Delhi

Jaggery Powder
431, Vijaya Lodge Building, Rangai Gowder Street, Town Hall, Coimbatore-641001, Tamil Nadu, India, Town Hall, Coimbatore-641001, Tamil Nadu, India
Coimbatore
Delhi

Self Drilling Anchor Bolt Systems
F-418 Office Block City Centre Mall Siliguri West Bengal - 734010
F-418 Office Block City Centre Mall Siliguri West Bengal - 734010
Delhi

Assured low-cost full body checkup at your home.
Mayur Colony, Kothrud
Pune
Delhi

HP Laptop Service Center in Dilshad Garden
197 B, Pocket F, Dilshad Gardenn Delhi,
Delhi

Interior A to Z
284/4, Chhatarpur Extension, Chhatarpur, New Delhi, Delhi 110074
Delhi
Delhi