Monday, 15 September 2014

WPF Interviews Q&A Part-1


1. What is WPF?
WPF is the latest presentation API by Microsoft Windows. It is 2D and 3D graphic engine. Its capabilities include:-
·          All the common user controls. For example, check boxes, buttons, sliders etc.
·          Supports flow and fix format documents
·          all the functionality of Flash and HTML
·          Data binding
·          Multimedia
·          Animation

2. What are the types of documents supported by WPF?
Two types of the documents supported by Windows Presentation Foundation (WPF) are the Flow format and fixed Format document. Flow format document alters the content to fit the screen size while fixed format document present content irrespective of the screen size.

3. Name the namespace required for working with 3D.
The namespace required for working in 3D is System.Windows.Media.Medi3D.

4. Is it right to say that WPF has replaced DirectX?
No, WPF can never replace DirectX. WPF cannot be used to create games with stunning graphics. WPF is meant to be a replacement for windows form, not DirectX.

5. What are dependency properties?
Properties that belong to a specific class but can be used for another are called the dependency properties.

6. How can the size of StatusBar be increased proportionally?
By overruling the ItemsPanel attribute of StatusBar with a grid. The grid’s columns can be appropriately configured to get the desired result.

7. What are Freezable objects in WPF?
An object, which has its state locked down, so that it becomes unchangeable, is known as a freezable object. Such objects perform better. It is also safer if they are required to be shared between threads. 
8. Why should WPF be preferred over Adobe Flash?
WPF is a more recent technology and thus has the latest development tools. It supports a broader range of programming languages and has a robust control reuse.

 9. How is Silverlight different from WPF browser application?
One of the major differences is that .NET framework is required for running WPF browser applications on the client machine. But Silverlight runs using only the plug-in. Another point of difference is that applications made in WPF depend on the OS as .NET Framework only runs on Windows. On the other hand, the Silverlight plug-in can be installed on those OSs also, which are not Windows.

10. Name the methods present in the DependencyObject.
It has three objects, namely:
·          SetValue
·          ClearValue
·          GetValue

11. Write about PRISM.
PRISM is a framework for creating complex applications for WPF, Silverlight or Windows Phone. PRISM utilizes MVVM, IC, Command Patterns, DI and Separation of Concerns to get loose coupling.

12. Is it possible to use Windows Forms in a WPF application?
Yes, Windows form can be used in WPF. Windows form can appear as a WPF pop. The controls of this Window form can be placed besides WPF controls in a WPF page by utilizing the functions of the WindowsFormsHost control that comes preinstalled.

13. Describe CustomControl briefly.
CustomControl widens the functions of existing controls. It consists of a default style in Themes/Generic.xaml and a code file. It is the best way to make a control library and can also be styled or templated.

 14. Name the common assemblies used in WPF?
·          PresentationFoundation
·          WindowsBase
·          PresentaionCore

15. Define Path animations in WPF
Path animation is a type of animation in which the animated object follows a path set by the Path geometry.

16. Can WPF applications be made without XAML?
Yes WPF applications can be created without XAML as using XAML in WPF is a matter of choice.

 17. What are the types of windows in WPF?
WPF has three types of windows:
·          Normal Window
·          Page Window
·          Navigate Window

18. How can elements in a ListBox be sorted?
Sorting can be done by using a property of the ItemsCollection object. ItemsCollection contains an attribute, SortDescriptions, which holds System.ComponentModel.SortDescription instances. Every SortDescription instance defines how the elements should be sorted and indicates if the sort is descending or ascending.
For instance, this code sorts elements of ContentControl on the basis of their word count property:
myItemsControl.Items.SortDescriptions.Add(new SortDescription(“WordCount”, ListSortDirection.Descending));

19. How is MVVM different from MVC?
MVC stands for Model-View Controller and.MVVM stands for Model-View ViewModel.
In MVVM, View Model is used instead of a controller. This View Model is present beneath the UI layer. It reveals the command objects and data that the view requires. It acts like a container object from which view gets its actions and data.

20. Explain Routed events in WPF.
An event, which can invoke handlers on more than one listeners present in an element tree, instead of the single object which called the event, is known as a Routed event.

21. How is System.Windows.Media.Visual dll utilized in WPF?
It is used whenever a requirement for creating custom user interface arises. It is a drawing object, which gives instructions for making an object. These instructions include opacity etc. of the drawing. The Visual class also bridges the functionalities of WPF managed classes and the MilCore.dll.

22. What are the various layout panels in WPF?
They are:
·          Stack Panel
·          Grid Panel
·          Canvas Panel
·          Dock Panel
·          Wrap Panel


23. Name the important subsystems in WPF
The major subsystems are:
·          Windows.Controls.Control
·          Windows.DependancyObject
·          Windows.FrameworkElement
·          Windows.Media.Visuals
·          Object
·          Threading.DispatcherObject
·          Windows.UIElements

24. What does BAML mean in WPF?
BAML is the abbreviation for Binary Application Markup Language. It is nothing but XAML that has been tokenized, parsed and changed into binary form. BAML is a compressed declarative language, which gets loaded and parsed quicker than XAML.

 25. What is Difference between Page and Window Controls in WPF?
The basic difference is that Window Control presides over Windows Application while Page Control presides over the hosted Browser Applications. Also, Window control may contain Page Control, but the reverse cannot happen.

Previous                                                                                                                             Next

Sunday, 14 September 2014

SSRS Interviews Question Answers




Interview Questions and Answers for SQL Server Reporting Services (SSRS)
Question: What is SQL Server Reporting Services?
Answer: SSRS is reporting tool which comes with Microsoft SQL Server. It’s a part of BI suite which SQL Server incorporates with it.
SSRS is free with Microsoft SQL Server and used to create reports for client purpose. With reporting service reports can be created in different format such as tabular, matrix.
Question: What are the different types of possible reports?

Answer:    

Report can be of three types in terms of format

1.      Tabular Report: In this format report will come in tabular format. Fields for which data required are in columns and data comes in the form of row. It’s a static report no change in the format is possible at run time (i.e. No of columns will remain same)
2.      Matrix Report: Matrix reports are the dynamic reports and columns can be changed at run time according to the data.
3.      Chart Report: In chart report chart can be used in report for graphical representation of the data. You can create dashboard using various charts and gauge.
Question: What is the extension for report file?
Answer:  Report file saves with the extension of .rdl and same file exist at report server.
Question: What are the shared data sources in SSRS?
Answer:  Shared data source is the source which can be shared across the different reports. Then need of created a separate data source each time can be removed. Reports firing on same databases can used the same data source.
Question: What are the different types of report?
Answer:  Using BIDS reports can be created in two ways. I.e. two ways to retrieve the data from SQL Server data source.
1.      TSQL Reports: TSQL Reports are made up of plain SQL Query. Data source in this case is SQL server database engine.
2.      MDX Reports: MDX reports are created through cubes. For this data source is analysis services cubes.




Question: Explain SSRS 2005 architecture?
Answer:    SSRS 2005 architecture
1.      Report Designer
2.      Report Builder
3.      Report manager
4.      Report server
5.      Report Server database
6.      Report Sources
Question: What is the report rendering?
Answer:   Report rendering is to call the report from server to application. Report rendering can be possible through different ways.
Question: What are the different types of report rendering methods?
There two methods through which we can render the report.
1.      URL Method
2.      SOAP Method
Question: What is the report server?
Answer:   Report server is the server where we deploy the report. I.e. it’s a holding place for reports. Applications access report server to view the report.

Question: What are the different folders on report server?
Answer:   There are two folders which exist on report server.
1.            Report Server: Report server contains the xml code of rdl.
2.            Report: Report folder stores the actual RDL file and which can be run by clicking on it on server.

Question: What is the report rendering?
Answer:    Report rendering is to call the report from server to application. Report rendering can be possible through different ways.
Question: What are the different types of report rendering methods?
Answer:    There two methods through which we can render the report. 
 
1.      URL Method
2.      SOAP Method
Question: What is the report server?
Answer:    Report server is the server where we deploy the report. I.e. it’s a holding place for reports. Applications access report server to view the report.
Question: What are the different folders on report server?
Answer:    There are two folders which exist on report server.
1.            Report Server: Report server contains the xml code of rdl.
2.            Report: Report folder stores the actual RDL file and which can be run by clicking on it on server.
 Question: What is URL Methods of rendering?
Answer:    
1.            URL Method is report rendering method in which you provide the report details through URL.
2.            URL method contains the report server details, parameter details and login details in the URL itself to view the report in report viewer control.
Question: What is report subscription?
Answer:  Report subscription is to schedule the resource on particular time and to send a mailer to particular users. You can find this functionality on report server for each report.
Question: What is the RDL file?
Answer:   RDL File stands for report definition language. It contains the report definition which located on report server. It contains the report layout and data source and datasets.
Question: What are the Matrix reports and what are their uses?
Answer:   Matrix reports are the reports which used to generate data dynamically i.e. table structure is not static and it can be changed at run time.
Question: How to pass cascaded parameters in report?
Answer:   Cascaded parameters are the parameters which are depended on other parameters. These parameters can be created in parameter section in upper window while creating the report.
Question: How to implement group by in report?
Answer:   Group by can be implemented by adding a group on row in table data part. Adding group will two group rows for this row on above and below of this particular row. Below row can be used for subtotal of this group which is specified in above row. By repeating the same operation on group row can created a group on group.

Question: What are the drilldown reports? Give one example.
Answer:   Drill down reports is the reports which can collapse or expand as per requirement i.e. information can be drilled down in to minor level information if required. For example when you group by the data at particular group. At the group level you can get the sum or any other information which you want to see. When you expand it you will get the row level data. For drill down there will be + sign on the row through which you can drill.
Question: What are sub reports and how to create them?
Answer:   Sub reports are the reports which can be called in main report and can be generate through main report.
Parameters can be passed from main report to sub report and basis of that report can be generated.
Question: What is the report model project?
Answer:   Report model project is for creating Adhoc reporting. You can create the adhoc reports through report builder. Report model project can be created on bids or report server. This model can have simple view. And using
Question: What is report server project?
Answer:   Report Server Project contains the RDL file and it need to be deployed on report server to view the report files to application and user. It a solution where we design our reports. You can add it by going into BIDS clicking on new item and then selecting reports server project. Once the solution is created you can start creating reports.
Question: What is the report builder?
Answer:   Report builder is used to create small reports and it a define interface. You can’t change the report interface in report builder it pre designed. You can just drag columns in the report. Report builder creates reports on database objects available with report model project.


-->