In this article, the interview questions on Java collections are discusses in detail. These interview questions are also give best possible answers which can be easily understood by the students. These are the most frequently asked interview questions which are collected from the interview of multinational companies. This article has best collection of interview questions at one place and it is made for the student’s convenience. It is beneficial to go through the questions presented in this article before facing an interview.

1. Describe Java collections Framework?

A well defined set of classes and interfaces are offered by Java collections Framework which supports specific operations on collections of objects.

2. Define Iterator Interface?

In general, iteration is same as enumeration interface. A collection can be traversed from the starting to end using Iterator interface methods and the elements from underlying collection are removed safely. Generally, iterator method () is used mostly in query operations.

The following are basic methods:

• Iterator.hasNext ();
• Iterator.remove ();
• Iterator.next ();

3. Define Enumeration Interface?

Enumeration interface permits to iterate through collection elements. Iterating through enumeration is same as iterating using iterator. But, there is no support for removal using enumeration.

The following are basic methods:

• Object nextElement ();
• Boolean hasMoreElements ();

4. Differentiate enumeration and iterator interface?

Using enumeration interface you can iterate through all the collection elements. Iterating using enumeration is same as iterating with an iterator. In enumeration, you cannot find removal support.

5. Define Set Interface?

In the concept of mathematics, a set is nothing but a group of items which are unique. It means the group should not have any duplicates. The collection interface must be extended by the set interface. In the collection, duplicates are not permitted by the set. Null is a valid entry in set implementations but it is permitted only once.

6. In collections framework, give the two types of set implementations?

The two types of set implementations available in collections framework are HashSet and TreeSet.

7. Differentiate HashSet and TreeSet?

Java.util.Set interface is implemented using HashSet class to remove the duplicate entries and hashing is used for storage purpose. Mapping between key value and data item is known as hashing and it ensures effective searching.

Java.util.Set interface is implemented by TreeSet class to provide an ordered set, duplicate entries are removed and tree is used for storage.

8. Define a list?

Ordered and unique collection of objects is known as a list. The collection interface is extended by the list interface.

9. Give the list implementations present in collections framework?

The available list implementations in the collections framework are ArayList and LinkedList.

10. Differentiate ArayList and LinkedList?

Java.util.List interface is implemented using ArayList class and arrays are used for storage purpose. In general, array storage is fast but it is not possible to delete or insert the entries in the middle of list. A new array must be constructed to achieve adding and deleting the entries in the middle of list. Any element can be gained access randomly.

Java.util.List interface is implemented by LinkedList class and linked list is used for storage purpose. Elements are allowed to be added, taken from collection by a linked list at any location in container by ordering elements. The elements can be gained access only sequentially using this implementation.

11. To implement a queue, which collection is used?

LinkedList

12. Define map interface?

In general, a map is a special set which does not have any duplication. The stored data is index or look up using key values. It is not an extension of collection interface and map interface has own hierarchy. In the collection, map does not permit duplication. Null is a valid entry in map implementations but it is permitted only once.

13. In collection frameworks, what are the two different types of map implementations?

In the collections framework, the two available map implementations are HashMap and TreeMap.

14. Describe the vector class functionality?

You cannot change the size of an array after setting the array size. In java, this kind of situation deals with vector and automatically it grows and the size is reduced. Only objects are permitted to store by the vector but not primitives. Primitives are converted into objects with the help of wrapper classes for storing primitives before adding to vector. Automatically, vector resizes and reallocates itself.

15. How a primitive data type is stored in vector or collections class?

Primitive data type is wrapped into wrapper classes in the package of java.lang such as float, integer or double.

16. Differentiate vector and ArrayList?

In general, vector and ArrayList are almost same. A growable array is represented by them. The vital difference is that ArrayList is unsynchronized whereas vector is synchronized.

17. Differentiate Hashtable and HashMap?

Both offers key-value access for data and the major difference is as follows:

• HashMap is not synchronized whereas Hashtable is synchronized.
• Null values are allowed by HashMap but are not permitted by Hashtable.
• In HashMap, iterator is fail-safe whereas the enumerator for Hashtable is not a fail-safe.

18. How an array is made larger?

Directly an array is not made larger. A new array must be made and all the original elements are copied into it. Most commonly, it is done using System.arraycopy (). This is done automatically by the vector class as long as the arrays are not primitive data types.

19. Which system class method permits to copy the elements of one array to other array?

System.arraycopy ()

20. Mention the usage of locale class?

Program output is tailored using locale class to conversions of specific political, geographic and cultural region.

21. Give the use of GregorianCalendar class?

Traditional western calendars are supported by GregorianCalendar.

22. Mention the usage of SimpleTimeZone class?

Gregorian calendar is given support by SimpleTimeZone.

You are at the right place to get the best interview questions on Java collections along with appropriate answers. Preparation is mandatory for a candidate before facing an interview and this article helps in preparation process. These are the technical interviews questions which are asked by the employers in the technical round of an interview for the candidate who is attending an interview on Java platform. Finally, the candidate who gives all the correct and best answers to the questions asked by the employer’s is hired by the company. Thus, he is the right person who suits perfectly for the vacant position and company requirements.

Today, it is not an easy thing to get the job due to tough competition. Employers always hire the right candidate who suits to the requirements of that particular position and also company. To get the job, the candidate must beat other candidates, who came for that particular interview by answering all the questions perfectly. The candidate who is attending an interview must have strong communication skills so that he can communicate easily with the employer. Interview is the great opportunity which is given to the student to present his skills and talent in getting the job. The students who do well in an interview by giving all the correct answers to the questions raised by the employers are given the job.

1. Define SharePoint?

SharePoint is a document collaboration platform which is based on the browser is given by Microsoft.

2. Give the features of SharePoint 2010?

The following are the features of SharePoint 2010:

• Enterprise Search FAST Search
• Document Collaboration
• Readymade Silver Light web part
• New Enhance Web Part
• Large lists
• Business Connectivity Services
• Visio Services
• Social Media Investments
• Enhanced collaboration features
• Usage logging and reporting
• Disaster Recovery Innovation or High Availability
• Service Applications
• Sandbox Solutions

3. Differentiate library and list?

Document is used to store library and similar items are present in the lists in rows and columns form. Core documents such as Excel, Word and Power Point is created in the library whereas documents cannot be created in list rather the document can be attached in specific list.

4. Differentiate document library and form library?

Core documents such as MS Excel, word and Power Point is present in the document library whereas a document in XML form is present in the library like InfoPath form.

5. In SharePoint, define Central Admin?

While installing the SharePoint, the default website is Central Admin.

6. Define stsadm command?

All the administrative works such as restore, backup, adding web part to site and installing feature, etc are performed using stsadm command.

7. Define farm?

In the SharePoint context, farm is sued to describe collection of many SharePoint servers and SQL servers that come together to give set of basic SharePoint services that are bound in SQL by single configuration database. Farms range in size from having everything on a machine to scaling out individual SharePoint serve role on the sets of servers which are dedicated. Farm is highest administrative boundary of SharePoint and the things happening in SharePoint happens in farm also. Simply, the collection of many SharePoint servers with a single configuration database is known as SharePoint Farm.

8. In SharePoint, define site definition?

The combination of XML and template is known as a site definition. MPS to meet workspace and STS for blank site and team are site definitions that are available in SharePoint.

9. Define site collection?

The collection of SharePoint site is Site Collection. Logical grouping of several SharePoint sites is a SharePoint site collection. A group of websites with same owner and sharing administration settings are a site collection. Example: permissions. When a site collection is created then top-level site is created in the location of the site automatically. Then, many sub sites are created below top-level site. It is necessary to have a site collection in the web application. A site collection can be created according to the existing web application or web applications are created and create site collection in that particular application.

10. Define site?

The collection of web pages used to store the information in an organized manner is known as a site. List of documents, events, discussion, task and different types of information are stored in the site. Controlled access to share information is provided by the site among users. Shared information is gained access only by the authorized users.

11. In SharePoint, define web parts?

The basic building blocks for the SharePoint user interface is web parts and numerous applications are built and integrated using them. The smallest component in SharePoint is web parts. A page is given much functionality using web parts. The custom web parts and readymade third party web parts are present SharePoint. Visual studio is used to create custom web part.

You can find many web parts in the gallery of SharePoint web part:

• Image web part
• Content editor web part
• Data view web part
• Excel web access web part
• Form web part

12. In SharePoint, define web application?

Web application is a IIS website in the SharePoint. Every web application is connected with one IIS website. a content database is created for every web application.

13. Define CAML?

The abbreviation of CAML is collaborative application markup languages which are in the form of XML. The data which is present in the SharePoint list is retrieved using CAML and it is also used for inserting and updating.

14. Define content types?

WSS provides a reusable thing known as content type. The column for the item in a list or library is defined by the content type and same may be used by different libraries or SharePoint application list. Example: if a list for leave application is created then a column for IT department, HR department is created then it results in nothing. So, content type is used to create own column or site column and this content type is used with any library or list.

15. Define BDC?

The abbreviation of BDC is business data catalogue. For your SharePoint site, it is considered as the middleware and back end data such as Siebel, SAP and any line of business application.

The data from the SharePoint list cannot be modified in BDC and this site is available for you in read only format.

It is given the name as BCS in the SharePoint 2010 and the abbreviation of BCS is business connectivity services. In general, BCS is two ways, which is data in the SharePoint list is edited from the back end database.

16. Define workspace?

Workspace or site is when a new place is required to collaborate on web pages, document libraries and lists. Example: a site may be created to manage a project or team, prepare for meeting or collaborate on document.

17. In SharePoint, workflow is applied to which elements?

Often, workflow associations are created on document libraries and lists directly. You can also create workflow association on content type that is present within content type gallery for content types and current site defined in the list.

Simply, it is applicable:

• At the list level or a document library
• At content type level defined at the scope of the site
• At the site level

18. Give different methods to initiate workflow?

• Manual (standard WSS UI interface)
• Automatic (on item deleted or item added)
• Programmatically through custom code
• Manual (Custom UI Interface)

19. In WF, differentiate method activity and event activity?

One that performs specific action is known as a method activity like updating or creating the task. As a response to the occurred action, an event activity runs.

20. Give SharePoint 2010 workflows?

The following are few additions in the workflow model:

• The workflows of SharePoint 2010 build on workflow engine which provides .net framework 3.5.
• Workflows for the SharePoint sites are created along with the SharePoint lists.
• There is a new graphical workflow designer in SharePoint designer 2010 for creating and deploying workflows to the SharePoint directly.
• Other enhancement in the SharePoint designer 2010 is it permits to modify the workflows of out-of-the-box that come along with SharePoint.

21. Differentiate internet and intranet site?

A normal site which is gained access by anyone on the internet is an internet site. You can create a site for your company which is gained access by anyone on the internet without using any username and password for it.

Intranet is also called as internal network, even though it is hosted on the web but it can be gained access by the individuals who are the members of that particular network. Here, it is necessary to have a username and password which is given to them by the site administrator when they are added.

22. What are the different roles of the users?

In general, the following roles can be assigned to the user:

Contributor:

Content can be added to the existing lists and document libraries.

Reader:

He is given read only access to website.

Web designer:

Document libraries and lists are created and the pages in the website are customized.

Administrator:

The complete control on the website is in the hands of an administrator.

23. For SharePoint 2010, define types of authentication variables?

• Windows
• Claims
• Forms-based authentication

24. What input forms are created for a workflow?

In general, four different input forms are created which includes initiation form, an association form, a task edit form and a modification form. Make sure to know that these are optional forms when the workflow template is created.

25. Define LINQ to SharePoint?

LINQ is the feature of programming languages visual basic .net and C# 3.0.

Each of the languages are added vocabulary to query data resources and SQL-like syntax.

To query libraries and lists in SharePoint, SQL-like syntax is used by the developers using LINQ to SharePoint.

Internally, LINQ to SharePoint converts LINQ query to CAML query to obtain records.

Advantage:

Entities of list are given strongly typed access.

26. Give the tool for creating DataContent classes to use in LINQ queries?

SPMetal.exe

Give advantages and disadvantages of LINQ to SharePoint?

Advantages:

• Entities of list are given strongly typed access.
• Complex queries are simplified.
• Development is fast.

Disadvantages:

• When new columns are added or if the data type is changed then the datacontext class which is used by LINQ is not valid and breaks code.
• Extra layer to definite CAML query

27. Can a SharePoint workflow is created using MS Visio?

It is not possible to create SharePoint workflow using MS Vision but it is used for workflow visualization. In SharePoint designer, flow diagram which is designed in Visio is imported where functionality is added and deployed to SharePoint.

28. How claims identity is used outside SharePoint?

• External partner services
• LOB systems
• Separate SharePoint farms

It is the right place to find great interviews questions on the topic SharePoint and these are the technical interview questions asked to the candidate who is facing an interview in the IT industry. Clearing the technical round of an interview is not an easy task and the candidate must be strong at all the core concepts. This article is helpful in the preparation process as it is a very good collection of interview questions along with best answers.

In the present days, there is a huge requirement on testing and most of the companies are hiring the candidates on testing. This is a popular profession and most of the students are showing interested in this route. Most of the multinational companies are hiring the candidates for testing by offering attractive salary packages. The manual testing interviews questions presented in this article are collected from various sources. These are the most frequently asked questions by the employers in an interview. These are the questions asked to the candidate who is attending an interview in the IT industry on the testing platform. These interview questions are given perfect and easy answers so that the students can understand easily. The student who has a good knowledge on subject can do well in an interview.

1. What makes a perfect test engineer?

It is necessary to possess “test to break” attitude by a good test engineer. They must have an ability to take customers view point, attention to detail and a great desire for quality. Diplomacy and tact are essential in maintaining a supportive relationship with developers. They must be capable of communicating effectively with technical people like developers and non technical people such as management and customers. Experience in software development is essential as it offers deep understanding of developing software process. Judgment skills are mandatory to gain access high risk areas in the application on which testing efforts are focused if there is limited time.

2. What are the qualities possessed by QA engineer?

The qualities possessed by the tester and QA engineer are same. Besides, they must have a complete knowledge on the software development process and the way it suits business approach and the organization goals. It is mandatory to have communication skills and must have a capability to understand several sides of issues. In the organization, it is necessary to have a diplomacy and patience in the initial stages of implementing QA processes. They must have an ability to find issues for and see what is missing for reviews and inspections.

3. What makes you a good test manager?

The following are the qualities that must be possessed by a test manager:

• They must have a good knowledge on software development process.
• Enthusiasm of the team is maintained and a positive atmosphere is promoted.
• To increase the productivity, they must promote teamwork.
• They must promote cooperation between test, software and QA engineers.
• To promote enhancements in QA processes, diplomatic skills are required.
• They must effectively handle the pressures.
• They must possess judgment skills to hire and keep the skilled personnel.
• They should communicate effectively with engineers, customers and managers.
• They must run meetings with focus.

4. Define test case?

A document that describes an action, input or event and response to determine whether the application feature is working perfectly is known as a test case.  Test case identifier, objective, input data requirements, test case name, expected results, test conditions and steps are the particular included in test case. Developing test cases help in finding issues in design or requirements of an application as it needs thinking through operation of an application. This is the reason to create test cases early in the development cycle.

5. In QA, define the documentation role?

The practices of QA are documented in such a way that they are repeatable. It is necessary to document specifications, business rules, designs, configurations, inspection reports, code changes, test cases, plans for the test, user manuals, bug reports, etc. In general, there must be an ideal system to find and obtain documents easily and determine what documentation has a specific piece of information. If it is require, you must use change management for documentation.

6. When the testing is stopped?

It is very difficult to determine. Most of the modern software applications are complex and run in interdependent environment that entire testing is never done. The following are the factors that decide when to stop posting:

• Test cases completed with some pass percentage
• Deadlines such as testing deadlines, release deadlines, etc
• Depleted test budget
• Alpha or beta testing period ends
• Bug rate falls under specific level
• Coverage of functionality, code and requirement reaches particular point

7. Describe the impact of object oriented designs on testing?

Object oriented design which is perfectly designed makes it easy to trace from code to internal design followed by functional design and finally to requirements. There will be minimal affect on black box testing and the white box testing is oriented to the object of an application. A test design is simplified if the application was designed perfectly.

8. Define Software Quality Assurance?

Complete software development process is involved in software QA. Software development process includes supervising and enhancing the process and ensures that issues are found and dealt with.

9. Define software testing?

Operation of an application or system under specific controlled conditions and evaluating results are included in testing. Both the normal and abnormal conditions are included in these controlled conditions. To make things to go wrong intentionally testing is attempted to determine happening of things when they should not and vice versa. Significantly, organizations changes in assigning the roles and responsibilities to QA. They are the combined responsibilities of individuals or a group sometimes. Also, project teams are common which include combination of developers and testers who work together with entire QA processes supervised by the project managers. Generally, it depends on what fits perfectly for the business structure and the size of organization.

10. Define verification and validation?

Typically, meetings and reviews are involved in verification to evaluate code, plans, requirements, documents and specifications. It is done using issues lists, check lists, inspection meetings and walkthroughs. Typically, actual testing is present in validation and takes place after completing verifications.

11. Define walkthrough?

An informal meeting for informational and evaluation purpose is walkthrough. Usually, a little or no preparation is required.

12. Define software life cycle?

When the application first conceived then the life cycle begins and if it not in use then lifecycle ends. Features such as requirements analysis, initial concept, internal design, test planning, functional design, coding, documentation planning, testing, integration, maintenance, document preparation, phase-out, retesting, updates, etc are included in it.

It is the best place for the students who are looking for the manual testing interview questions as they are collected from the interviews conducted from different companies. Before attending an interview preparation is mandatory and this article helps in your preparation process. The candidate who is attending an interview on testing must have a basic knowledge on certain testing tools.  All the major concepts can be revised quickly after going through the interview questions and answers mentioned in this article. Employers always look for the right candidate who suits perfectly for their company requirement and he tests the candidate on various aspects by asking questions. Finally, selects the best candidates among all the students who came for the interview.

In the present days, the profession of software testing is highly recognizable. Software tester is a popular profession and plays a vital role in the day to day life. It is an art to enhance the developed software by using specific tools known as software testing tools. Operating the software under controlled conditions to verify working of software by rectifying errors is known as software testing. Software tester must make sure to deliver the reliable and correct software which is according to the requirements of the user. These are the best interviews questions and answers which are collected from various interviews conducted by multinational companies. Before attending an interview, it is necessary to go through the questions presented in this article as they help in the preparation process.

1. Define CMM and TMM?

CMM is capability maturity model whereas TMM is testing maturity model.

2. Define Agile Testing?

It is testing practice for specific projects with the help of agile methodologies, the development is treated as customer of testing and a test-first design paradigm is emphasized. Test driven development is also seen.

3. Give the methodologies in agile development model?

In general, there are seven agile methodologies, they are:

• Scrum
• Extreme programming
• Crystal
• Agile Unified Process
• Learn Software Development
• Dynamic Systems Development Model
• Feature-Driven development

4. Determine the mclabe cyclomatic complexity associated with a program?

In the software engineering, cyclomatic complexity is extensively used complexity metric. The complexity of a procedure is described by measuring linearly individual paths using its source code.

5. Give the basic elements that are kept in defect report?

• Module name
• Project name
• Defect name
• Defect id
• Defect detected by
• Defect detected on
• Defect resolved on
• Priority, severity and status
• Defect’s snapshot
• Defect resolved by

6. How test results are checked and what you will if the desired results are not obtained?

It is necessary to verify whether the expected result associated with the test case specified in the document of test case is equal to actual result. The test case passes if they are equal and if it is not equal then you must check the difference and the reason for difference. You must raise a defect after narrowing down and then the defect is mapped to the test case.

7. How soak testing is done in the real time?

Soak testing:

Here, the system is run at the high load for long period of time. Example: many transactions are run multiple times in a complete day than expected in a busy day to determine the performance issues that encountered.

8. Differentiate interoperability and compatibility testing?

Interoperability:

To verify whether the software can co exist with the supporting software in system.

Compatibility:

To verify the software, runs effectively on different operating systems according to the needs of the customers.

9. Define fish pond analysis?

In general, it is a software development life cycle process. It is similar to a fish model and thus, it is give this particular name.

10. Differentiate Validation and Verification?

Verification:

In this process, whether the software meets its specification or not is conformed here. To evaluate requirement, documents, code, plans and specification, meetings and reviews are included in it. This can also be done effectively using issues lists, check list and walkthroughs. It is the evaluation of process and verifies whether the right product is built or not.

Validation:

In this process, it is conformed that it is according to the needs of the users. Typically, actual testing is included in the validation and it occurs after verification.

11. In the abnormal condition of the software, which testing method is used?

• Security testing
• Stress testing
• Beta testing
• Recovery testing

12. Define acceptance testing?

This particular testing is performed to allow user to decide whether the software product is accepted or not. Normally, it is enabled to validate software to meet agreed acceptance criteria.

13. Define Ad Hoc testing?

It is a testing phase where tester breaks system by trying functionality of the system randomly and it may also include negative testing.

14. Define application binary interface?

It is a specification which defines portability requirements of applications in binary forms across various system environments and platforms.

15. Define application programming interface?

It is formalized set of software routines and calls that are referenced by application program to gain access to the network services and supporting system.

16. Define automated software quality?

To enhance the quality of software, specific software tools such as automated testing tools are used.

17. Define automated testing?

Software tools are employed by testing to execute tests without manual interference. It is applied in performance, GUI, API, etc testing. The software is used to control execution tests, the actual outcomes are compared with predicted ones, test preconditions are setup and other test reporting and test control functions.

18. Define Backus-Naur form?

It is a Meta language which is formally used to depict the syntax of a language.

19. Define basic block?

It is a sequence many executable and consecutive statements without branches.

20. Define basis path testing?

The test case design technique of white box that use programs algorithmic flow to design tests.

21. Define Basis Set?

Set of tests are derivatives which are obtained using path testing.

22. Define Baseline?

The point at which a deliverable created in the process of software engineering is kept under formal change control.

23. Define Beta testing?

The testing conducted by the customers for the release of software product is Beta testing.

24. Define binary portable testing?

The executable application is tested for portability across system environments and platforms, usually conformation to ABI specification.

25. Define Black Box Testing?

Testing based on specification analysis of a software piece without referring to the internal working. The main aim is to test how the component conforms to the requirements published for component.

26. Define Bottom up testing?

It is a good approach to integration testing where the components at lower level is tested first then used to simplify higher level components testing. This process is repeated until the component which is present on the top in the hierarchy is tested.

27. Define Boundary testing?

In this test the focus is mainly on limit conditions or boundary of the software which is being tested. In these tests, few are stress tests.

28. Define bug?

The fault makes a program to execute in an unanticipated or unintended manner.

29. Define defect?

If there is any missing function or feature in the software which is essential is known as a defect.

30. Define boundary value analysis?

Boundary value analysis is same as equivalence partitioning but it concentrates on corner cases or values that are out of range as described by the specification.

31. Define branch testing?

It is a type of testing in which source code of a program is tested at least once.

32. Define breadth testing?

It is a test suit exercising complete functionality of the product but the features are not tested in detail.

33. Define CAST?

Computer aided software testing.

34. Define capture tool?

It is a test tool which is used to record test input because it is sent to the software under test. The stored input cases are used to reproduce test at later time. These are usually applicable to GUI test tools.

35. Define cause effect graph?

Representing inputs and related outputs graphically effects which are used in designing test cases.

36. Define code complete?

It is a development phase where the complete functionality is implemented and bug fixes are left. The functions which are found in functional specifications can be implemented.

37. Define code coverage?

It is an analysis method which is used to determine parts of the software that is executed by test case suit and which parts are not executed and thus, an additional attention is necessary.

38. Define code inspection?

It is a formal testing technique where the source code is reviewed by the programmer with a group asking questions, analyzing code and logic of the program and finally analyzing compliance using coding standards.

39. Define code walkthrough?

It is a formal testing technique where a group traces source code using a set of test cases while program variables state is monitored manually to analyze assumptions and logic of the programmer.

40. Define coding?

Generating source code is known as coding.

41. Define a component?

It is a software item that is available with individual specification.

42. Define concurrency testing?

It is a Multi-user testing mechanism towards determining effects of gaining access to the same application code, database records or module. It determines and measures level of deadlocking, locking and usage of semaphores and single threaded code.

43. Define data dictionary?

A database which includes definitions for all the data items defined at the time of analysis.

44. Define data flow diagram?

A modeling notation which is used to represent system’s functional decomposition is known as data flow diagram.

45. Define debugging?

It is a process which is used to find and eliminate the causes of failures in the software.

46. Define dependency testing?

In this type of testing application requirements are examined for pre-existing software, configuration and initial states to maintain perfect functionality.

47. Define emulator?

A computer program or system accepts same inputs and generates the outputs according to the given system.

48. Define workflow testing?

It is a scripted end to end testing that duplicates particular workflows which are anticipated to be used by the end-user.

49. Define exhaustive testing?

This type of testing covers different combinations of preconditions and inputs of a software element which is under the test.

These are the technical interviews questions which are asked to the candidate who is attending an interview in the IT industry on testing. Before facing any interview, preparation is mandatory to do well in the interview round. It is very difficult to clear the technical round of an interview because the candidate must be strong at core concepts. This article is helpful in recollecting all the concepts quickly on the day before an interview and thus, helps in clearing the interview process.

The candidate who is interested in getting the desired job must have strong determination and dedication in learning the subject. To get qualified for attending an interview, it is necessary to have a good percentage of marks in the professional education and it is better if consistency of percentage is maintained from high school. Next thing is the student who is attending an interview must prepare well before facing an interview. Preparation is necessary so that the student can recollect and revise all the concepts in very less time so that he will not face difficulty in answering the questions in an interview. Employers hire the best candidate who is according to the company requirements and who is capable of doing all the tasks associated with the vacant position. This article helps in clearing the interview process as it has a good collection of interview questions along with correct and suitable answers.

1. Define OBIEE?

The abbreviation of OBIEE is oracle business intelligence enterprise edition and it is a tool to develop enterprise wide reports. Simply, it is a report generating tool like crystal reports. Earlier, OBIEE is known as Siebel analytical tool which is acquired by oracle. So, do not get confused because now it is called by the name OBIEE tool.

2. In Siebel analytics, describe repository?

Meta data information is stored in repository. It is a file system which is an extension of repository file. All the rules needed for data modeling, security, and caching, aggregate navigation, connectivity is stored in repositories of metadata. Multiple business models are stored in every metadata repository. Multiple repositories can be gained access by Siebel analytics server.

3. In Siebel analytics, describe the end to end life cycle?

The life cycle of Siebel analytics is as follows:

• Business requirements are gathered.
• Source systems are identified.
• ETL is designed to load to DW if source data do not exist.
• Repository is built.
• Dashboard is build or answers are used for reporting.
• Security is defined.
• Select caching mechanism and aggregations based on the performance.
• Testing and QA

4. What were your schemas and explain working of Siebel architecture and the layers?

In the Siebel architecture, there are five parts:

• Clients
• Data sources
• Siebel analytics server
• Siebel analytics web server
• Siebel analytics scheduler

Metadata representing analytical model is developed using Siebel analytics administration tool.

In general, repository is divided into three layers:

Business:

Data sources are modeled into dimension and facts.

Physical:

Data sources are represented.

Presentation:

User’s view of the model is specified.

5. In BMM layer, how the relationship between facts and dimensions are defined?

In BMM layer, complex join is used to define relationship between facts and dimensions.

6. Can a physical join is used in BMM layer?

Yes, it is possible to use physical join in this layer. If there is SCD type two then a complex join is used in BMM layer.

7. In BMM layer, is it possible to use outer join?

Yes, it is possible to use outer join. You have only one option, while doing complex join.

8. Define variable in Siebel?

Variables are used in repository simplify administrative tasks and the metadata content is changed dynamically to regulate to changing data environment. A variable manager is included in the administrative tool to define variables.

9. Define Authentication and what are the different types of Authentication?

The process in which system examines with the help of user id and password that the user is given necessary permissions and authorization to log in and gain access vital information. The analytical server of Siebel authenticates every connection request which it receives.

• LDAP authentication
• External table authentication
• Operating system authentication
• Database authentication

10. Define object level security?

In general, there two types of object level security, they are:

Web level and repository level

Web level:

Here, security is given for the objects which are stored in the web catalog of Siebel analytics such as folder, dashboards pages and reports you view objects for which you are given authorization. Example: manager at the middle level is not given access to dashboard which includes summary information for complete department.

Repository level:

The repository level security is provided in the presentation level by denying or given permission to the users to see specific column or table.

11. Define data level security?

The type and amount of data which is present in the report is controlled by data level security. When the same report is run by different users then the returned results depends on the access rights and roles in organization. Example: the results for all religions are by the sales vice president whereas the sales representative is responsible for seeing the data for that specific region.

12. Differentiate object level security and data level security?

The type and amount of data which is seen in the reports are controlled by the data level security. Securities for the objects that are stored in web catalog of Siebel analytics such as dashboards, folders, dashboards pages and reports are provided by object level security.

13. What is a pipeline and it you see it anywhere in your projects?

Yes, the stages in a specific transaction are known as pipelines such as finance, assessment, etc.

14. How to create filter on repository?

On content tab condition

15. In Siebel analysis, multiple data sources are available or not?

Yes

16. In Siebel analysis, how the expressions and case statements are handled?

To create case when…then… end statement then expression builder is used.

17. Define query repository tool?

• Query repository tool is the utility of OBIEE or Seibel admin tool.
• It permits you to verify repository metadata tool.
• Example: look for the objects based on type and name.
• Verify relationship between metadata objects such as which column in presentation layer maps to some table in the physical layer.

18. Define JDK and why it is required?

The abbreviation of JDK is Java Development Kit, it is a package of software containing minimal tools required to write, debug, compile and run Java applets.

19. Is it possible to migrate presentation layer to different server?

No, it is not possible to migrate and the whole web and RPD files can be migrated.

20. In BMM layer, why there are many LTS?

Performance and query response time are enhanced.

21. Give the full form of RPD?

In general, there is no full form for RPD, it is a repository file. It is also called as Rapidfile Database.

22. How a cache is disabled from two specific tables?

Right click on table then you will find an option saying cacheable in the physical layer.

23. In SAS, which type of protocol is used?

TCP/IP protocol is sued.

The candidate who is looking for the interview questions on OBIEE is at the right place as this article contains most frequently asked interview questions and answers conducted by the multinational companies. This article is helpful in the preparing for an interview because important questions are collected at one place to make it easy for the students. Clearing a technical round of an interview is difficult so thorough preparation is mandatory.

A physician assistant is a medical professional who aidsthe physician to carry out all his activities. The role of the physician assistant is not a difficult task toexecute as it involves the tasks relatedto administration like arranging appointments, informing patients about the doctor’s availability, explaining the treatment procedure to the patients along with cost required for the surgery. The applicant applying for the position of physician assistant under a physician or any hospital needs to acquire minimum educationqualification and clear the interview. The common questions that are placed by any recruiter to the physician assistant are given below.

1. Brief me about yourself?

It is the basic and first question in any interview that the recruiters ask irrespective of the field and position that you are applying for. Start the answer by giving you name followed by your educational qualification, hobbies and interests, family background. Keep the answer short and brief and try to give the complete information within less time.

2.Give your educational qualifications?

It is the most important question and every applicant need to possess minimum educational qualification required for the job. Try to explain briefly about the educational background that you have and how they can help you out in building bright career.

3.Can you give difference between the nurse and medical assistant?

It is common misconception that the roleof both the nurse and medical assistant is same. The interviewers mainly focus on this question if you are new to the field. Make sure that you have a perfect answer for this question. Giving exact answer for this question gives an opinion that the applicant is well versed in the medical field.

4. What are the professional courses and assistance programs that you havecompleted and give the certifications that you have acquired?

Apart from the educational qualification, it is good to complete some certification programs that help you in getting the job easily. Givethe list of certifications (if any) that you have completed. The certification gives you perfect edge overthe other applicants.

5.What is your specialization?

As medical is very vast, every individual gets specialized in a specific field based on their interest. Tell about yourspecialization in the field that may include emergency, internal medicine or any other field. It is goodto be specialized, as it creates positive impact on the mind of the recruiter.

6.What kind of medical services you can offerto the patients?

Answer this question by specifying the type of services that you can offer the patients visiting the hospitals. The services may include order for diagnostic tests, record the patients condition, therapeutic health care etc.

7. Describe your day at work?

Before answering this question, try to make a list oftasks that you need to execute or the tasks that you have done in you previous job. You can brief your daily work that may include assigning priorityto tasks such as office work, offering are to patients, ordering for medical supplies , diagnostic tests, and recording the patientshealthcondition and updating the same in the case sheet.

8.What are the cases that you refer the patients to the physician?

The answer should be very accurate and try to describe the situation when you refer the patients to chief doctors. Explain the situation briefly.

Eg: if the patient needs high level medical care theni will refer the patient to the physician.

9. Howacademics helped you to prepare for this profession?

It is most tricky question and answer for such type of question should be prepared in advance.

Eg:demonstrate how you have handled the education, part timework and voluntary work. And explain about acquiring certification that you have done during the education period. Make the recruiter feel that you can handle multiple tasksand you possess excellent time management skills.

10. List theproblems facedby the American health care industry?

To answer this question, you need to have a good knowledge of health care industry in America. It will be good, if you be up to date with the things happeningin the medical field. Instead of reading few journals thatsharethe information,be prepared for this question and try to collect as much as information before the interview.

11.Why you are willing to become physicianassistant and why not nurse practitioner?

It is an important question that you need to answer perfectly. Try to give the differences that you know between the physician assistant and nurse practitioner. And give the benefits that you have by selecting this field and express the interest that you have towards the role of physician assistant.

12. Have you applied for any other jobs?

The answer to this question should be given honestly and list out the program for which you have applied by giving proper reason for applying to these programs.

13.Why should we hire you and how you are different from other applicants?

You need to speak on the prerequisitesthat you have satisfied for becoming physician assistant, your real timeexperience (if any), courses that you have completed and the certification that you acquired.You need to convince the interviewer and make him believe that you are best when comparedto other applicants.

14.According to you, what does a physician assistant do?

The answer that you give should focuson the practical experiences if you are experienced. And if you are fresher, then try to elaborate on the knowledge that you have about the profession.

15. Can you describe the stressful situation that have undergone and how you managedit?

By asking this question, the interviewer is trying to test your stress management skills and how you work under pressure times. And the way you can handle the emergency situations.  Don’t make the recruiter feel that you become panic easily during the stress times.

16.What are your great strengths and weakness?

The recruiter is trying toestimate you attitude and strengths that you possess. Be prepared for this questionprior to the interview. Make list of great strengths and weakness that you have. While listing weakness try to brief the one’s that does not make a negative impression in recruiter’s mind.

Eg: I have a good memory, good people skills and possess strong leader ship qualities and never forget to give a perfect examplefor strengths.

Eg: A weakness that you can say is I don’t look for the time until the work assigned to me is finished.

17.Brief about your previous employer?

The interviewer is trying to push you into difficultsituation. The answer for this question should start with the name of the previous employer, designation, field that you have worked in, number of years you have worked for the company or under the employer. But never make bad comments about your previous company as it makes a negative impact in the recruiter’s mind.

18. What is the salary that you are expecting?

You need to be alert before answering this question, because if any thing wrong happens you may end up losing the job. So try to push the question back to the recruiter by saying that I think the company has already fixed specific range for the qualified professionals. Check whether the salary range that they offer matches your expectation or not. If not then give your salary scale but don’t argue for the salary.

19.What are the medical books and non medical books that you have read recently?

Start the answer by saying that reading is of one of my hobbies. I always prefer to read books thatare relate to medical field to update my knowledge and some times I also read comic books forrecreation purpose. The main intention to place this question is check how you spend the time wisely.

20. If a patient has HIV, will you offer medical care to him?

Never give answer that I won’ treat such kind of people. The main aim of the physician assistant is to offer care to the patient irrespective of caste,sex, status and the previous medicalcondition. Try to focus mainly on this point so that recruiter feels you have strong commitment towards serving every one.

21.What are the general tasks of physician assistant?

The recruiter is trying to gauge yourknowledge about the role of physician assistant and the tasks that are associated with the job. Beforethe interview, try to know the various tasks thatare to be executed by the physicianassistant working in a hospital.

Eg: the general tasks associatedwith the job are arranging appointments, informing whether doctoris available or not to the patients by attending calls, greeting the patients, assisting the physician incarrying out his daily activities, recording the vital signs of the patient and updating it in the sheet, order for the diagnostic exams and explain about the surgery procedure

Network administrator has a prominent role to play in the company where he works. He is responsible to look after the network related problems and troubleshoot them. The applicant desiring to work as network administrator needs to acquire bachelor’s degree in computer applications. And after acquiring the certificate, they need to undergo a networking course where they are taught with the basic networking concepts. The applicant must be well prepared to clear the interview and get placed in a well reputed company. Due to rise in the number of companies, the demand for network administrator has increased rapidly. The individual applying for the position of the network administrator need to have the basic knowledge of network related concepts. The questions that are asked by the recruiter for the role of network administrator are given below.

1. What are the seven layers of the OSI model?

The abbreviation for OSI is open system interconnection and it is the standard model used for developing networks and to implement protocols. The seven layers in the OSI model are given below.

• Application layer: it is used as an interface between the user and network. And in this layer messages are stored in the messages form.
• Presentation layer: the format in which the data is transferred is negotiated in this layer and the data is sent as segments.
• Session layer: the connection in this layer can be established by the name of the network and the data is transferred in form of segments.
• Transport layer: it is used for end to end transfer of data between two systems. And the data transfer is done in segments form.
• Network layer: this layer is mainly used for routing data through the large networks. And the data transfer or storage is done in packets.
• Data link layer: this layer is used for gaining access to network media. The data transfer is down in frames form.
• Physical layer: at this layer, the messages of the data link layer that are in frame form are converted into bits.

2. What are subnet mask, MAC address and IP address?

Subnet mask: it is generally used to find the number of hosts and networks. Every IP address of the system use different subnet masks and these subnet masks are used in dividing the IP networks into several sub networks for improving the performance of the system and to ensure high level security.

MAC address: Media access control is used as unique identifier to find the computer device. Usually the MAC address is given by the manufacturer.  It is a 12 digit hexadecimal number used for identifying the device.

IP address: this unique address is used for identifying the networking device that is available on the LAN (local are network), WAN (wide area network). Every computer need to have a unique internet protocol address and this IP address is given by the local internet service providers through which the user establishes internet connection.

3. What are the various types of networking devices?

There are several types of networking device that are used for establishing connection.

• Repeater: it is also called as regenerator. This device is used only in physical layer. The role of the repeater is to receive the signals before it gets weakened. This device regenerates original pattern of bits and places it back in the link.
• Bridges: these devices are used in both the physical layer and data link layer. They are mainly used for dividing a large network into small segments. They contain the logical that is useful to keep the traffic of each segment separately.
• Routers: they are used for relaying the packets among several interconnected networks. They usually operate in the physical layer, data link layer and network layers.  These routers contain software that enables them find out the best path for data transmission among several paths.
• Gateways: they are used for transferring packets among networks with different protocols. They accept the packet of one protocol type and convert it to packet of other protocol type before transmitting it. They are used in all the layers of the OSI model.

4. What are the various network topologies?

• BUS topology: in this topology type, each computer is connected directly to a network cable in single line. It is inexpensive, installation is simple, easy to understand and extend it.
• STAR topology: in this topology, all the computers are directly connected to central hub. The cost needed for establishing connection using this topology is very less. It is simple to install, reconfigure and easy to resolve the physical problems.
• RING topology: in this model, all the computers are connected in the loop form. All computers in topology can have equal access to the network media, they can be installed simply. The signal doesn’t get down when compared with other topology types.

5. What is ICMP?

The abbreviation for the ICMP is internet control message protocol. It is network layer protocol that belongs to TCP/IP suite and it is used by the gateway to send the notifications related to datagram problems to the sender. It is also used for the echo test, a test that is conducted to check whether the destination is reachable or not.

6. What is meant by middleware?

Middleware is software that is used for establishing good communication between the clients and servers. It is similar to a type of bridge that is used in establishing network connections. The application of the client side invokes the services and they are managed by the middleware. The middleware does not have any additional software to carryout its operations.

7. What is VOIP Technology?

VOIP stands for voice over internet protocol. This VOIP technology is used for the transmitting the voice over long networks to make calls. VOIP phone calls are of less cost and in present world many corporate offices are using this VOIP technology for making phone calls over long distances.

8. Define DHCP?

The abbreviation for DHCP is dynamic host configuration technology. The main purpose of the DHCP is to assign the IP address and other network related configurations that include DNS, Gateway, subnet mask and other settings that are required for establishing internet connection. DHCP is used widely as it reduces the manual work of the administrators to assign IP address to every client in case of large number of networks.

9. Define DNS and explain how it works?

DNS is used to translate the IP address into host name so that it becomes easy for the user to remember the host name and it converts host name into IP address. Every domain and device is assigned with unique IP addresses and these addresses are used for identifying the device and to establish connection with the internet.

10. What is firewall?

Firewall is present in every network and it acts as protective boundary for the network. It prevents the network from unauthorized users. Many operating systems have built-in firewalls. The third party software’s are plenty in number that provides firewall to protect the computer or network from the hackers.

11. What is the difference between TCP and UDP?

TCP (transmission control protocol) is the popular internet standard protocol that is used for establishing network connection to the computer. Every internet browser uses this protocol to get connected to the server. This protocol receives the request from the user and transfer’s it to the HTML. This TCP protocol is inbuilt in many operating systems. The TCP protocol is used for the long time connection. The communication layer and physical of the OSI standard model uses this protocol.

UDP (user datagram protocol) is a connectionless protocol that is mainly used for transferring messages without any errors. The user can send short service messages over the internet and the messages are termed datagrams.

12. What is Wi Max technology and GSM technology?

Wi Max is the advanced version of the Wi-Fi wireless technology. It supports data, audio and video communication at same time and the minimum speed is 70 mbps.

GSM technology is wireless technology that can be used with in short range and it is mostly used in the mobiles, MP3 devices, Laptops and computers.

13. What are VPN’s?

Virtual private networks (VPN) are the logical networks that are available on the same physical line. These networks are mainly used when the individual desires to increase the connection but doesn’t want to buy any new switches.

14. What are the uses of VLAN?

VLAN (virtual local area networks) are used for enhancing the network security. They also increase the broadcast domains by decreasing the domain size. A network can be added, moved, changed by configuring the appropriate port.

You are at the right place and need not go anywhere to look for the interview questions on HTML language. These are real interview questions asked in the interviews conducted by multinational companies. The HTML interview questions and answers presented in this article are the best collection which is kept at one place for your convenience. These HTML questions are given best and appropriate answers so that the students can give perfect answer to the employer. Employer hires the candidate who has given all perfect and correct answers to the questions asked by him. Mostly, the employers hire the candidate who is according to the vacant position and meets the requirements of the company. Interview is the great chance given to the student to present his skills and talent in getting the job. The candidate who is facing an interview must go through the below questions.

1. Define HTML?

The abbreviation of HTML is hyper text markup language and it is a universal language which permits an individual to use certain code to develop web pages that can be viewed on the web.

2. Define a HTML tag?

A syntactical construction in the HTML is a HTML tag that abbreviates executing specific instruction if HTML script is loaded into web browser. It is similar to a method in java language or a C++ function or a Pascal procedure or routine in FORTRAN language.

3. Define polymorphism?

Polymorphism term refers to an ability of objects to take form objects of different classes in an object oriented programming.

4. Differentiate between container and a component?

In general, component is an object like a scroll bar or a button which is represented visually in the screen window. But, a container is like a component of window which has other components. There is a unique container for each component that contains it directly.

5. Differentiate constructor and method?

The member function of a class which is used to create objects of that particular class is known as a constructor. The constructor has its class name without a return type. New operator is used to invoke constructor.

In a class, an ordinary member function is known as a method. It has own name with a return type which may be void. Dot operator is sued to invoke a method.

6. Give the advantages and disadvantages of using AVL tree?

The main advantage of AVL tree is always balanced, the O (lgn) speed of binary search algorithm is guaranteed. The disadvantage is complex rotations which are used by removal and insertion algorithms required to maintain tree balance.

7. Give the major difference between HTML and XML?

• XML is specially designed to describe data and concentrates on what data is. HTML is especially designed to display data and concentrates on the way data look is.
• In general, HTML is all about showing the information whereas XML is for describing information.
• HTML documents are marked up and structured using tags which are predefined.
• Author is allowed to define own tags and document structure using XML.

8. Define META tags?

Search engines and Web developers make use of META tags. The creator of the page, refresh parameter and keywords and description of page can be identified using META tags.

9. Why do you call “user agent” instead of “browser”?

Even though browsers are really important users of HTML and XHTML, there are many other systems and programs which read these particular documents. For instance, documents are read by search engines but they are not browsers. “User agent” is the term used to remind people of the difference.

10. How is added to scroll the text in a page?

Make sure to know that all the browsers will not support scrolling text. But, to scroll the text is added which is similar to the below example.

THIS WOULD SCROLL

11. Define semantic HTML?

The meaning of semantic HTML is HTML tags are used for the implied meaning than using span tags and div for everything. Tag is interpreted in specific way which depends on tag and its content.

12. Define Document Type Definition?

The syntax of web page is specified by Document Type Definition in SGML. It is used to define rules that apply for markup of document of specific type which contains entity decelerations and set of elements.

13. In HTML, what is DIV?

DIV is similar to span but it has an extra property of align in it is using which text can be aligned within it. Further, DIV tag and code are used to place the code anywhere within it.

14. Define HEAD in an HTML document?

The unordered collection of information regarding the document is known as head in the HTML document. The general or meta-information on the document is present in the head. In the document, head is appeared first above the body.

15. Differentiate cell spacing and cell padding?

Cell spacing:

In general cell spacing is used for formatting but you find a major difference between cell spacing and cell padding.

Extra space is set using cell padding which is used for separating walls of the cells from their contents. But space can be set between cells using cell spacing.

Cell padding:

In general, cell padding is used for formatting which is used to give the space between cell contents and the edges of cells.

16. Define the attributes used to make up a DHTML?

The abbreviation of DHTML is Dynamic hyper text mark up language. The interactive ability can be increased using DHTML and visual affect of web pages are loaded into browser.

17. Define a DOCTYPE?

The DOCTYPE points to Document Type Definition which is used to define the rules for mark up language so that the content is render correctly by the browser. Every HTML document starts with declaration of DOCTYPE that identifies which version of HTML document is used according to the standards of HTML. Initially, the declaration of DOCTYPE was used by the tools that are based on SGML such as HTML valuators which are required to determine the version of HTML used in the document.

18. Define Meta tags and their usage?

Meta data related to the HTML document is provided by a Meta tag. Metadata is not displayed on page but it is machine parsable and they are used to state page description keywords that are last modified and metadata.

This Meta tag is always presented inside the head element and is used by the browsers, other web services and search engines.

19. Give the advantages of HTML?

The following are the advantages of HTML:

• The main advantage of HTML is it is widely used.
• HTML is supported by all the browsers.
• It is very easy to learn and use HTML.
• By default, it is in windows so it is not necessary to purchase additional software.
• It has similar syntax of XML which is used widely for data storage.
• Even the new programmers feel easy to learn and code.

20. Give the disadvantages of HTML?

The following are the disadvantages of HTML:

• Only static and plain pages can be created using HTML. HTML is not suitable if dynamic pages are required.
• To make a simple page, you must write a lengthy code.
• In HTML, the security features are not very good.
• The code results in complexity, if lengthy code is written for creating a webpage.

21. Differentiate HTML and DHTML?

HTML:

• The abbreviation of HTML is hyper text markup language.
• Special processing is not required for the pages in the site from server side before they go to browser. Thus, the pages are always same for the visitor that is static.
• HTML does not permit any features.
• HTML is a language.
• Web pages are described by HTML documents which contain plain text and HTML tags.

DHTML:

• The abbreviation of DHTML is dynamic hyper text markup language.
• Some additional features are allowed by DHTML.
• The sites of DHTML are going fast on the technologies based on the client side.
• DHTML is considered as the art of combining JavaScript, HTML and Dom.

The questions presented in this article are asked to the candidate who is attending an interview on the HTML platform. These are the technical interviews questions that are asked by the employers in the technical round of an interview. Before facing any interview, it is necessary to prepare well and this article makes your preparation easy by keeping all the questions at one place.

In the present days, it is not an easy thing to get the desired job especially in the technical field because there is a tough competition. The candidate who is into the technical profession or education must be very good at academics and have a good knowledge on the subject. Additionally, the candidate must fulfill the eligibility criteria of the company which is conducting an interview. They check complete education background of the candidate and the candidate who scored good percentage of marks is given an opportunity to face the interview. In the interview process, the candidate is tested on various aspects aptitude, reasoning, English, technical skills, etc. It is necessary to have strong communicational skills for the candidate who is attending an interview because the candidate is even tested on his communication skills. This article has a very good collection of interview questions on SQL server reporting services.

1. Define report rendering?

According to report rendering, a report is called from a server to an application. There are many different ways for report rendering.

2. Give different methods used for report rendering?

There are two different methods using which we can render the report, they are:

• SOAP method
• URL method

3. Define a report server?

The server where the report is deployed is known as report server. It is the place for holding reports. To view the report, report server is gained access by the applications.

4. Give the folders on report server?

In general, there are two folders on the report server:

Report server:

The XML code of RDL is present in the report server.

Report:

The actual RDL file is stored in the report folder which is run by clicking the server.

5. Define URL methods of rendering?

• URL method is nothing but a report rendering method in which the report details are provided using URL.
• The report server details, login details and parameter details in URL itself to see the report in report viewer controller are present URL method.

6. How an embedded function is referenced in report expression?

To reference an embedded function, name of the function and code prefix is used in the report expression.

7. Shared data should not be overwritten in the production? Why?

Shared data source should not be overwritten because administrator may already change connection string properties.

8. Define SQL server reporting services?

It is a reporting tool that comes along with Microsoft SQL Server. It belongs to BI suite that is incorporated by the SQL server. SSRS is available freely with Microsoft SQL Server and it is mainly used to generate client reports. The reports of reporting service is created in various formats like matrix and tabular.

9. Describe different types of reports?

In general, the reports are of three different types, they are:

Tabular report:

The report will come in the tabular format in this type of report. Fields for the data required is in columns whereas the data are in the row form. It is a static report and you cannot make any changes at the runtime. Thus, the number of columns will be same.

Chart report:

In chart report, graphical representation of data is reported using a chart. With the help of gauge and charts, dashboards can be created.

Matrix Report:

These reports are dynamic reports and according to the data, you can change the columns at the runtime.

10. Give the extension for report file?

Report file has an extension of .rdl and the same file is present at report server.

11. In SSRS, describe the shared data sources?

The source which is shared across different reports is known as a shared data resource. The need to create separate data source is removed. Same data resource is used by the reports firing on databases.

12. Describe different types of report?

In general, reports can be created in two different ways using BIDS that is, there are two ways to get back the data from data source of SQL server.

MDX Reports:

Cubes are used to create MDX reports. Services cubes are analyzed for this data source i.e., OLAP reporting.

TSQL Reports:

A plain SQL query is used to create TSQL reports. Here, data source is SQL server database engine.

13. Describe the architecture of SSRS 2005 architecture?

The architecture of SSRS 2005 is given below:

• Report designer
• Report manager
• Report builder
• Report server
• Report sources
• Report server database

14. Define report subscription?

The resource is scheduled by the report subscription on specific time and a mailer is sent to specific users. This functionality is present on report server for every report.

15. Define RDL file?

The abbreviation of RDL is report definition language. It has report definition which is located on the report server. Data source, report layout and datasets are present in it.

16. Explain how the cascaded parameters are passed in the report?

The parameter that depends on other parameters is known as cascaded parameters. In the parameter section, these parameters are created in the upper windows while generating the report.

17. Define drilldown reports with an example?

The reports which are expanded or collapsed according to the requirement are known as a drill down report. Here, if it is necessary then the information is drilled down to minor level. Example: if you group data at specific group, you get the sum at group level or any information which you are interested to see. You get the row level data after expanding it. The row which is used to drill down has a + sign.

18. In SSRS 2008, what roles are available?

In SSRS 2008, two different types of roles are available they are: system-level roles and item-level roles. The collection of specific tasks associated to operations on report object hierarchy is an item-level role. The collection of tasks associated to operations on the server objects outside the hierarchy of report object of SSRS 2008 is a system-level role.

19. Is it possible to a user belong to more than one system-level or item-level role?

Yes it is possible, a user or a group has more than one association to item-level or system-level role in SSRS 2008.

20. Is it possible to create cache of a report?

No, it is not possible. Cache of a report is created only when specific requirements are met like having credentials stored in report server.

21. Is it possible to edit .rdl code related to linked report?

No, it is not possible as there is no .rdl code of its own by the linked report. It points to .rdl code of base report.

The interview questions presented in this article is on the topic SQL server reporting services along with perfect answers. These are the frequently asked technical interview questions on SQL server reporting services asked by the employer in the technical round of an interview process. This article is helpful for the candidate to recollect all the concepts quickly by studying these questions. The candidates who give best and correct answers for the questions raised by the employers are hired by the company and are offered a good salary package.