Draw LINQ Architecture and explain on any one of the supporting LINQ component in SQO's
IEnumerable and IQueryable are 2 sets of LINQ supporting components in Standard Query Operators
IEnumerable Data component involves
- LINQ to SQL
- LINQ to Datasets
- LINQ to Entities
IEnumerable integrates with ADO.net in 3 different ways
- Using standard queries like lambda expressions
- Using ADO.net objects like datasets and data tables
- Using Entity framework that allows programmers to develop persistent objects using object relational mapping (ORM) and Entity Data Model (EDM)
Iqueryable component is usually used to access remote data with web services using IQueryable.
List down the Enumerations on Xpath?
- XmlCaseOrder
- XmlDataType
- XmlSortOrder
- XPathNamespaceScope
- XPathNodeType
- XPathResultType
What are Web APIS and how are they classified?
APIs are the programs to provide information depending on the request. APIs receives a request based on the information and then it returns a result. From an object-oriented (OO) standpoint, dealing with an API is much like dealing with a class.
The two most popular web APIs are
- REST (Representational State Transfer)
- SOAP (Simple Object Access Protocol)
What are the pre-requisites to interact with eBay API?
- A regular eBay.com account (www.ebay.com) that will be associated with your development account
- A development account, (http://developer.ebay.com) which is a free account required to access the API
- At least one sandbox user account (http://www.sandbox.ebay.com) to act as a seller for auctions you create during testing
- At least one sandbox user account to act as a buyer for auctions you creates during testing.
Write about SQL Server 2005 reporting life cycle?
Write about 2 databases used by reporting service
ReportServer Database
ReportServer database is the main store for data in Reporting Services. It contains all report definitions, report models, data sources, schedules, security information and snapshots.
ReportServerTempDB
ReportServerTempDB database stores temporary Reporting Services information. Since reporting services works over HTTP, it must maintain some information about each user request. This information is referred to as a session. When a user makes an initial request, this report definition and data are stored in the session cached.
The session cached – “Report server temp DB.” detail length is 10 minutes.
What is a LINQ query expression?
In SQL, a select query is a declarative statement that operates on one or more tables, producing a table. In LINQ, a query expression is a declarative expression operating on one or more IEnumerable objects, returning an IEnumerable object. Thus, a query expression is an expression of iteration across one or more objects, producing an object over which you iterate to collect the result.
What are the 5 main components of a reporting server?
- Report Processor
- Data source Extensions
- Security Extensions
- Rendering Extensions
- Delivery Extensions
Which namespace has to be imported for using Query operators in LINQ?
System.query
What is CURL and list down its functions?
CURL is a client URL library that allows users to connect to different types of servers using protocols like HTTP, https, ftp, gopher, telnet, dict, file, and ldap
CURL Functions are
- CURL_Init
- CURL_Exec
- CURL_Error
- CURL_Close
- CURL_SetOpt
What are the different objects that implement IEnumerable interface?
IEnumerable is obtained from system.collections namespace
Arrays, collections, relational data and XML are the objects that implements IEnumerable interface.
What is the syntax of XSL Pattern?
The XSL pattern is described from XPath specifications, the syntax is the same as that used to select nodes with <xsl:for-each>, <xsl:value-of>, and <xsl:apply-templates> elements. The XSL patterns are classified based on match pattern and select patterns.
Match Pattern Syntax
- Starts with a node (the target), and yields a true/false (match/didn't match) result.
- Starts by testing the node against the node target, and then checks the context, including ancestry and descendants.
- Represents a pattern of contextual information against which a particular node can be tested. Match patterns are quite similar to selectors in cascading style sheets (CSS).
Ex: <xsl:template match="section">
Select Pattern Syntax:
- Starts with a node (the context), and identifies more nodes.
- Starts at the context and drills down into the data.
- Represents a query into an XML document.
Ex: <xsl:value-of select="title"/>
List down at least 6 eBay APIs available
- Shopping API
- Merchandising API
- Trading API
- Client Alerts API
- Notification API
- Research API
Define XSL architecture
What are the functions for navigating scope in reporting services?
Inscope, level and previous
How does CRUD work?
Create – adding the elements using <methodname>.add
query to find the corresponding objects
update those objects
flush the changes using <method name>.submitchanges
Delete – deleting the elements using <methodname>.remove
What are the differences between SAX and DOM?
SAX – Simple API for XML
SAX is an events based push parsing model where the client application sets up event handlers into which the SAX parser pushes nodes while it parses through the XML document.
Microsoft do not support SAX parsing
DOM – Document Object Model
DOM builds a tree object model of the complete XML document and not only allows you to extract data from the XML but also allows you to change/manipulate the XML
Microsoft supports DOM parsing
What are the request parameters to integrate into Amazon?
- Service
- AWSAccessKeyId
- AssociateTag
- Version
- Operation
- ResponseGroup
- SearchIndex
- Keywords
What is persisted stream on the report server?
Persisted stream stores session level rendered output for an individual user in its in-memory.
What is the difference between XSL and CSS?
XSL can be used to transform XML documents into other XML or HTML documents while CSS is purely for style control. Transformations are not supported by CSS.
