Interview Questions – WPF, SQL, Threading
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 …
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 …
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. 44. Print the name of distinct employee whose date of birth is between 01/01/1950 to 12/31/1970. 45. Count the total number of employees based on …
Q 1. What is the difference between Process and Thread? A process is started when you start an Application. A process is a collection of resources like virtual address space, code, security contexts etc. A process can start multiple threads. Every process is start with a single thread called primary …
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 …
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: 3. What are main WPF …
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 …
41. What is Markup Extension in WPF? Markup Extension decides at runtime how to set a property value. StaticResource, DynamicResource are examples of Markup Extension. Markup Extension are always comes in curly braces { }. The first word inside the curly braces is class name of Markup Extension. 42. How …
61. How can you obtain the SynchronizationContext class? You can use the static property SynchronizationContext.Current property from the UI thread. 62. How many methods are available in SynchronizationContext class? There are two methods: 63. What is the difference between Send and Post methods in SynchronizationContext class? Post method is asynchronous method …
81. What is Property-based Animation in WPF? WPF introduces a property-based animation techniques to make animations in WPF easy. It simply modify the value of control property over an interval of time and the target property must be a dependency property. 82. How many types of Animation support by WPF? There …