Interview Questions - WPF, SQL, Threading
Question 11. What is the use of into keyword in LINQ? 'into' keyword lets us save the intermediate result into a variable. We can further write LINQ query against this variable. static string[] names = { "Kapil Malhotra", "Michael Jackson", "Miami Sinha" }; static void Main(string[] args) { var result = from name in names where name.StartsWith("M") ...
Question 1. What is LINQ? LINQ stands for Language INtegrated Query. LINQ allows us to write queries over local collection objects and remote data sources like SQL, XML documents etc. We can write LINQ query on any collection class which implements the IEnumerable interface. Question 2. What is Sequence and Query Operators in LINQ? Sequence is a collection class on which you like to q...
Question 1. What is Object Oriented Programming (OOPS)? OOPS is a technique to develop modules. These modules are assembled together as software. OOPS works on the objects. Everything in OOPS is object. Object is made up of states and behaviors. Objects communicate with each other by sending messages to each other. Object hierarchy are built using Aggregation and Composition. Some popula...
Question 1. What is the difference between Threads and Tasks? Tasks are wrapper around Thread and ThreadPool classes. Below are some major differences between Threads and Tasks: A Task can return a result but there is no proper way to return a result from Thread. We can apply chaining on multiple tasks but we can not in threads. We can wait on Tasks without using Signalling. But in T...
22. What is SQL Server Trigger? A trigger is a special stored procedure which automatically executes when you execute any insert, update, or delete commands on table or view. 23. Can we execute a Trigger directly? No 24. How many types of Triggers available in SQL Server? There are two types of Triggers: Instead-of Trigger After Trigger 25. What is SQL Instead-of T...
1. What is SQL Temporary Table? A temporary table is a table which developer creates at runtime only for the scope of a query or for the scope of the connection. You can do all CRUD operations on the table. There are two kinds of temporary tables: a. Local temporary table b. Global temporary table Local temporary table: This table is available only to the scope of a query. It a...
21. How can we find resources from ResourceDictionary and apply on controls? ResourceDictionary stored resources as key value pairs and you have a method called FindResource in every control to find the resource from the ResourceDictionary. Every resource is stored as reference type so you have to cast the object to the original type. btn1.Background = (Brush)btn1.FindResource("backgro...
Q 21. What is the class hierarchy of wait handles? Q 22. What is ManualResetEvent and how it is different between AutoResetEvent? ManualResetEvent is also a synchronization mechanism similar to AutoResetEvent which works on bool variable. If the bool variable is false, it blocks the thread. If true, it unblocks the threads. ManualResetEvent provides the same methods as AutoResetE...
43. What is the function name for getting the current date in SQL Server? We can use GETDATE() with SELECT statement for getting the current date. SELECT GetDate() 44. Print the name of distinct employee whose date of birth is between 01/01/1950 to 12/31/1970. SELECT DISTINCT Name FROM Employee WHERE DOB BETWEEN '01/01/1950' AND '12/31/1970' 45. Count the total number of em...
1. What is WPF? Windows Presentation Foundation (WPF) is a successor of Windows Forms. WPF is a UI presentation framework for developing Windows based applications. It uses the DirectX technology for rendering their controls on the screen. 2. What are the features of WPF? WPF main features are: WPF is resolution-independent. It uses the hardware acceleration for graphics renderin...
