Here you can find Software Tools Interview Questions and Answers.
In this Software Tools Interview Questions and Answers section you can learn and practice Software Tools Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any Software Tools interview.
AllIndiaExams provides you lots Software Tools Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Software Tools Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of Software Tools Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Software Tools technical interview.
What is the relationship between Microsoft SharePoint Portal Server and Microsoft Windows Services?
Microsoft SharePoint Products and Technologies (including SharePoint Portal Server and Windows SharePoint Services) deliver highly scalable collaboration solutions with flexible deployment and management tools. Windows SharePoint Services provides sites for team collaboration, while Share Point Portal Server connects these sites, people, and business processes-facilitating knowledge sharing and smart organizations. SharePoint Portal Server also extends the capabilities of Windows SharePoint Services by providing organizational and management tools for SharePoint sites, and by enabling teams to publish information to the entire organization.
What is a SharePoint Feature? What files are used to define a feature?
A SharePoint Feature is a functional component that can be activated and deactivate at various scopes throughout a SharePoint instances, scope of which are defined as 1.Farm level 2.Web Application level 3.Site level 4.Web level Features have their own receiver architecture, which allow you to trap events such as when a feature is Installing, Uninstalling, Activated, or Deactivated. The element types that can be defined by a feature include: menu commands, link commands, page templates, page instances, list definitions, list instances, event handlers, workflows. The two files that are used to define a feature are the feature.xml and manifest file(elements.xml). The feature XML file defines the actual feature and will make SharePoint aware of the installed feature. The manifest file contains details about the feature such as functionality.
Workflow can be applied to what all elements of SharePoint ?
Workflow associations are often created directly on lists and libraries, a workflow association can also be created on a content type that exists within the Content Type Gallery for the current site or content types defined within a list. In short, it can be applied ... At the level of a list/library At the level of a content type defined at site scope At the level of a content type defined at list scope
What are the types of input forms that can be created for a workflow ?
You can create four different types of input forms including 1. An association form 2. An initiation form 3. A modification form 4. A task edit form. Note that these forms are optional when you create a workflow template.
What are ways to create input forms for workflow ?
1. You can create your forms by using custom application pages, which are standard .aspx pages deployed to run out of the _layouts directory. ( disadv: lot of code required when compared to Infopath approach) 2. Using Microsoft Office InfoPath 2007 (disadv: picks up a dependenct on MOSS, i.e. it cannot run in a standalone WSS environment)
What is Data warehouse?
In 1980, Bill Inmon known as father of data warehousing. "A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management's decision making process". A Data ware house is a relational Database Management System which is specifically design for Business analysis and making decisions to achieve the business goal. A data ware house is design to support decision system(dss). It is also called historical database. Because it will keep all the historical information. It is also called as Read only database system.
What is the difference between database and data warehouse?
A database is a collection of related data. A data warehouse is also a collection of information as well as a supporting system.
What are the benefits of data warehousing?
Historical information for comparative and competitive analysis. Enhanced data quality and completeness. Supplementing disaster recovery plans with another data back up source.
What is EDW?
EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization. this apporach is the apporach on Imon which relies on the point of having a single warehouse/centralised where the kimball apporach says to have seperate data marts for each vertical/department. Advantages of having a EDW: 1. Golbal view of the Data 2. Same point of source of data for all the users acroos the organization. 3. able to perform consistent analysis on a single Data Warehouse. to over come is the time it takes to develop and also the management that is required to build a centralised database.
What is the Difference between static cache and dynamic cache?
Static cache: We can not insert or update the cache. Dynamic cache: We can insert rows into the cache as we pass to the target.
What is EAI ?
EAI or Enterprise Applications Integration can be defined as data that can be integrated from disparate applications regardless of the platform, allowing the sharing of business processes amongst multiple organizations.
What are the Major categories of EAI?
Integration can be at different application layers: Data Level Integration: Batch data transfer, OR On-line propagation of data updates API Level Integration: Data is accessed through published API services Service Method Level Integration: Common services shared by different applications User Interface Level Integration:The controller reacts to the user input. It creates and sets the model. Common user interface (e.g. web based) for unified access to multiple applications.
What are the Advantages of EAI?
Advantages of EAI solutions are: Streamlines business processes and helps raise organizational efficiency. Real time information access among systems. Maintains information integrity across multiple systems. Speedier transactions at reduced costs. If one of the applications misbehaves and requires to be shut down for maintenance, then with EAI, we can easily “decouple” it from rest of the systems. Which avoids having to bring down other systems.
What are the disadvantages of EAI?
The main disadvatages of using EAI systems: Constant change: The very nature of EAI is dynamic and requires dynamic project managers to manage their implementation. Lack of EAI experts : EAI requires knowledge of many issues and technical aspects. EAI is a tool paradigm: EAI is not a tool, but rather a system and should be implemented as such. Building interfaces is an art : Engineering the solution is not sufficient. Solutions need to be negotiated with user departments to reach a common consensus on the final outcome. A lack of consensus on interface designs leads to excessive effort to map between various systems data requirements. Loss of detail : Information that seemed unimportant at an earlier stage may become crucial later. Accountability : Since so many departments have many conflicting requirements, there should be clear accountability for the system's final structure.
What are the main companies which provide EAI tools / software?
TIBCO webMethods Vitria iPlanet MQSeries (IBM) iPlanet BizTalk (Microsoft) WebLogic (BEA)
What is Cognos Reporting tool?
Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
What is Cognos Impromptu?
Cognos Impromptu is a tool for generation of business intelligence reports.
What are the advantages of cognos?
Planning Analysis Forecasting Scorecarding
What are the types of report?
Blank report List report Cross report Chart report Repeater report
What is Cognos Connection?
It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization’s business intelligence data.
What is Hadoop framework?
Hadoop is a open source framework which is written in java by apche software foundation. This framework is used to wirite software application which requires to process vast amount of data (It could handle multi tera bytes of data). It works in-paralle on large clusters which could have 1000 of computers (Nodes) on the clusters. It also process data very reliably and fault-tolerant manner
On What concept the Hadoop framework works?
It works on MapReduce, and it is devised by the Google.
What is MapReduce ?
Map reduce is an algorithm or concept to process Huge amount of data in a faster way. As per its name you can divide it Map and Reduce. The main MapReduce job usually splits the input data-set into independent chunks. MapTask: will process these chunks in a completely parallel manner (One node can process one or more chunks). The framework sorts the outputs of the maps. Reduce Task : And the above output will be the input for the reducetasks, produces the final result. Your business logic would be written in the MappedTask and ReducedTask. Typically both the input and the output of the job are stored in a file-system (Not database). The framework takes care of scheduling tasks, monitoring them and re-executes the failed tasks.
What is compute and Storage nodes?
Compute Node: This is the computer or machine where your actual business logic will be executed. Storage Node: This is the computer or machine where your file system reside to store the processing data. In most of the cases compute node and storage node would be the same machine.
How does master slave architecture in the Hadoop?
The MapReduce framework consists of a single master JobTracker and multiple slaves, each cluster-node will have one TaskskTracker. The master is responsible for scheduling the jobs' component tasks on the slaves, monitoring them and re-executing the failed tasks. The slaves execute the tasks as directed by the master.
What are the modes of TIBCO BW Installations ?
GUI mode Console mode Silent mode
If you have installed a particular version of TIBCO software e.g. TIBCO BW X.Y.Z, What are X, Y and Z number stands for?
Integration can be at different application layers: X:Patch Y:Major Z:Minor
What is the role of TRA?
TRA stands for TIBCO Runtime Agent. The TRA has two main functions: Supplies an agent that is running in the background on each machine. The agent is responsible for starting and stopping processes that run on a machine according to the deployment information. The agent monitors the machine. That information is then visible via TIBCO Administrator. Supplies the run-time environment, that is, all shared libraries including third-party libraries.
What are the revision control system options available in TIBCO designer?
File sharing VSS Perforce XML Canon ClearCase iPlanet CVS PVCS
What are the different modes of service invocation?
Services can be invoked in several ways: A one-way operation is executed once and does not wait for a response. A request-response operation is executed once and waits for one response. In a request-response service, communication flows in both directions. The complete interaction consists of two point-to-point messages—a request and a response. The interaction is only considered complete after the response has arrived. Publication (notification) means an operation sends information on an as-needed basis, potentially multiple times. Subscription means incoming information is processed on an as-needed basis, potentially multiple times.
What is business objects?
Business objects provides a set of tools for building data warehouses very efficiently. Business objects is an integrated query, reporting and analysis solution for business professionals that allow them to access the data in their corporate databases directly from their desktop and present and analyze this information in a business objects document.
What is a repository?
Business objects repository is a set of database tables where the metadata of your application is stored.
When is the repository created?
In 5i/6i versions, the repository is created after installing the software. In Xi version a repository is created at the time of installation.
What is a domain?
A domain is nothing but a logical grouping of system tables.
How many domains are there in the basic setup and what are they?
There are three domains in the business objects. They are: Security domain: Contains the information about user/groups/access privileges etc. Universe domain: Contains the information about joins, loops, classes, objects and hierarchies. Document domain: Contains the output of reports.
What purpose does Visual Studio serve?
Development for BizTalk Server is done through Visual Studio (depends on BizTalk version). Visual Studio has templates for BizTalk artifacts like orchestration, pipelines, schemas and maps, so a BizTalk solution can be created (design time) and deployed to the BizTalk runtime. Besides artifacts .NET development can be done in creating pipeline components, custom functoids, custom adapters, and .NET helper classes to aid in orchestrations. As a BizTalk professional Visual Studio is your friend and required to build BizTalk solutions.
What is strong name key?
A strong name ensures that each assembly name is unique. Each assembly in your BizTalk project requires a strong name in order to deploy successfully.
How is strong name key generated?
At the command prompt, from the folder where you want to store the key file, type the following command, and then press ENTER: sn /k file_name .snk. In Visual Studio Solution Explorer, right-click the project and then click Properties. Click the Signing tab and choose Browse in the Choose a strong name key file drop down box.
Difference between Build and Rebuild?
Build means compile and link only the source files that have changed since the last build, while Rebuild means compile and link all source files regardless of whether they changed or not.
What are the actions in order to deploy from Visual Studio?
Sign the project with strong name key Give the name to the Application
How many access groups can be associated to an operator at once ?
Only one access group at a time , but one operator will have multiple access group in their operator id instance.
Can u explain abt ruleset types ?
We have Different types of rulesets are available in Pega Rule set types Are, Shared rulesets, Component Rulesets, Override rulesets, Standard rulesets
What is a production ruleset ? How will it be helpful ?
In the production rulesets area we can provide rulesets, rules in this rulesets will be unlocked in production, the end users directly will change these rules as per requirement, this is called rule deligation.
What is the default access role used by developers ?
Pega rules SysAdmin4
Different types of classes that PRPC support?
We have different types of Standard Classes will be available which are, @baseclass is Ultimate base class, And Its Child Classes are work-, Data-, Rule-, Assign-, History-, etc. Pega always Support 2 types of classe which are Abstract Classes And Concrete Classes Abstract Classes are ends with ‘-‘ and abstract Classes cannot create any work object instances Concrete Classes will Does not ends with -, And Abstract Classes will create Workobject instances
What is an ABAP?
ABAP (Advanced Business Application Programming) is a high level programming language created by the German software company SAP. It is currently positioned as the language for programming SAP's Web Application Server, part of its NetWeaver platform for building business applications. Its syntax is somewhat similar to COBOL.
What is an ABAP data dictionary?
ABAP for data dictionary describes the logical structures of the objects used in application development and shows how they are mapped to the underlying relational database in tables/views.
What are domains and data element?
Domains: Domain is the central object for describing the technical characteristics of an attribute of an business objects. It describes the value range of the field. Data Element: It is used to describe the semantic definition of the table fields like description the field. Data element describes how a field can be displayed to end-user.
What is foreign key relationship?
A relationship which can be defined between tables and must be explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data entered should be checked against existing data to ensure that there are now contradiction. While defining foreign key relationship cardinality has to be specified. Cardinality mentions how many dependent records or how referenced records are possible.
Describe data classes
Master data: It is the data which is seldom changed. Transaction data: It is the data which is often changed. Organization Data: It is a customizing data which is entered in the system when the system is configured and is then rarely changed. System data: It is the data which R/3 system needs for itself.
What is application server?
An application server is a software framework dedicated to the efficient execution of procedures (scripts, routines, programs ...) for supporting the construction of applications. The term was created in the context of web applications. In these, the application server acts as a set of components accessible to the software developer through an API defined by the platform itself. These components are usually performed in the same machine where the web server is running, and their main job is to support the construction of dynamic pages. Other uses of the term can refer to: The services that a server makes available The computer hardware on which the services run Java application servers Following the success of the Java platform, the term application server sometimes refers to a J2EE or Java EE 5 application server. Some of the better-known Java Enterprise Edition application servers include: Apache Tomcat (Apache Software Foundation) Tcat Server (MuleSoft) WebSphere Application Server and WebSphere Application Server Community Edition (IBM) Sybase Enterprise Application Server (Sybase Inc) WebLogic Server (Oracle) JBoss (Red Hat) Apache Geronimo (Apache Software Foundation) Oracle OC4J (Oracle) SAP Netweaver AS (ABAP/Java) (SAP) WebObjects (Apple Inc.) The web modules include servlets and JavaServer Pages. Business logic resides in Enterprise JavaBeans (EJB-3 and later). The Hibernate project offers an EJB-3 container implementation for the JBoss application server. Tomcat from Apache and JOnAS from ObjectWeb exemplify typical containers which can store these modules. A Java Server Page (JSP) (a servlet from Java) executes in a web container — the Java equivalent of CGI scripts. JSPs provide a way to create HTML pages by embedding references to the server logic within the page. HTML coders and Java programmers can work side by side by referencing each other's code from within their own. JavaBeans are the independent class components of the Java architecture from Sun Microsystems.
What is web server?
What is the Domain in Weblogic serve?
Domain is a logically related group of Oracle WebLogic Server resources that are managed as a single unit Domain Provides one point of administration Can logically separate: Development, test, and production applications Organizational divisions
What are the Domain Restrictions?
Each domain requires its own Administration Server. A cluster cannot span multiple domains. The Managed Servers in a domain must run the same version of Oracle WebLogic Server. The Administration Server in a domain must run the same or higher version as Managed Servers in the domain.
What is the server?
A server is an instance of weblogic.Server executing in a Java Virtual Machine (JVM). A server: Runs on a designated Oracle WebLogic Server machine Has a dedicated amount of RAM Is multithreaded Two types of servers: Administration Server Managed Server
What are Menu types available?
1. Standard 2. Pop-Up
Where do you need to install connectivity software?
We need to install Connectivity Software on Appserver and scheduler server if they are not on the Database server
What is the purpose of state records?
To store application data for life of the application Engine process
What is the most important Record in PS HRMS?
What is dynamic view?
Dynamic View is similar to SQL View but we cannot build the dynamic view. When we do not want store the database then us dynamic view.
What is ICA?
ICA – Independent Computing Architecture: Application publishing is supported by ICA. Low bandwidth is sufficient for ICA. Encryption is possible I ICA. Keyboard and Mouse inputs are present in ICA. ICA ensures session reliability.
What is RDP – Remote Desktop Protocol?
RDP – Remote Desktop Protocol: RDP works only under TCP/IP. RDP does not support applications to run in a browser. Session reliability is not ensured by RDP.
What is Citrix Access Gateway?
CAG is a universal Secured Socket Layer Virtual Private Network appliance. It is a blend of best features of IPSec and SSL VPN. It allows easy access to the users and secure access to company. Any information resource can be gained by using CAG with secure, single point access, always-on features. Any firewall is supported for Citrix Access Gateway. Supports various types of applications, including IP telephony. Any application that is hosted on Citrix Presentation Server can be accessed in a secured manner.
Explain the load evaluators are supported in Citrix?
CPU Utilization Memory Utilization IP Range Page Swap Page Faults Disk Data I/O Context Switches Scheduling User Application Load Server Application Load
Do you have any idea ICA file in Citrix?
ICA stands for Independent Computing Architecture. It contains published application information. ICA file has Windows ‘ini’ format. It is organized in such a way that MetaFrame Presentation Server Clients can interpret. ICA file will initialize a client’s session running on the server. The MetaFrame Presentation Server‘s clients uses the ICA protocol for input formats and addresses the input to the server for further processing.
How do you define Teradata?
Give some of the primary characteristics of the same. Teradata is basically an RDMS which is used to drive the Datamart, Datawarehouse, OLAP, OLTP, as well as DSS Appliances of the company. Some of the primary characteristics of Teradata are given below. Is capable of running on Single-nodes, as well as multi-nodes. Parallelism is built into the system. Very much compatible with the standards of ANSI. Tends to act in the same way as a server. It is an Open System that basically executes for UNIX MR-RAS, Suse Linux ETC, WIN2K, etc.
What are the newly developed features of Teradata?
Some of the newly developed features of Teradata are: Automated temporal analytics Extension in the compression capabilities which allows flexible compression of data about 20 times more data than the previous version. Customer associated innovation like tetradata viewpoint.
Highlight a few of the important components of Teradata?
Some of the important components of Teradata are: – Bynet Access Module Processor (AMP) Parsing Engine (PE) Virtual Disk (vDisk) Virtual Storage System (VSS)
Mention the procedure via which, we can run Teradata jobs in a UNIX environment?
All you have to do is perform execution in UNIX in the way as mentioned below. $Sh > BTEQ < [Script Path] > [Logfile Path] or $Sh > BTEQ < [Script Path] TEE [Logfile Path]
In Teradata, how do we Generate Sequence?
In Teradata, we Generate Sequence by making use of Identity Column
Define Data Stage?
A data stage is basically a tool that is used to design, develop and execute various applications to fill multiple tables in data warehouse or data marts. It is a program for Windows servers that extracts data from databases and change them into data warehouses. It has become an essential part of IBM WebSphere Data Integration suite.
Explain how a source file is populated?
We can populate a source file in many ways such as by creating a SQL query in Oracle, or by using row generator extract tool etc.
Name the command line functions to import and export the DS jobs?
To import the DS jobs, dsimport.exe is used and to export the DS jobs, dsexport.exe is used.
What is the difference between Datastage 7.5 and 7.0?
In Datastage 7.5 many new stages are added for more robustness and smooth performance, such as Procedure Stage, Command Stage, Generate Report etc.
In Datastage, how you can fix the truncated data error?
The truncated data error can be fixed by using ENVIRONMENT VARIABLE ‘ IMPORT_REJECT_STRING_FIELD_OVERRUN’.
What is Datawarehousing?
A Datawarehouse is the repository of a data and it is used for Management decision support system. Datawarehouse consists of wide variety of data that has high level of business conditions at a single point in time. In single sentence, it is repository of integrated information which can be available for queries and analysis.
What is Business Intelligence?
Business Intelligence is also known as DSS – Decision support system which refers to the technologies, application and practices for the collection, integration and analysis of the business related information or data. Even, it helps to see the data on the information itself.
What is Dimension Table?
Dimension table is a table which contain attributes of measurements stored in fact tables. This table consists of hierarchies, categories and logic that can be used to traverse in nodes.
What is Fact Table?
Fact table contains the measurement of business processes, and it contains foreign keys for the dimension tables. Example – If the business process is manufacturing of bricks Average number of bricks produced by one person/machine – measure of the business process
What are the stages of Datawarehousing?
There are four stages of Datawarehousing: Offline Operational Database Offline Data Warehouse Real Time Datawarehouse Integrated Datawarehouse
Sharepoint Interview Questions and Answers
Informatica Interview Questions and Answers
Webmethods Interview Questions
Cognos Interview Questions
Hadoop Interview Questions
TIBCO Interview Questions
Business Objects Interview Questions
Seeburger Interview Questions
BizTalk Interview Questions and Answers
PEGA Interview Questions and Answers
SAP Tools Interview Questions
IBM Tools Interview Questions
PeopleSoft Interview Questions
Citrix Interview Questions & Answers
Teradata Interview Questions & Answers
Datastage Interview Questions & Answers
Data Warehouse Interview Questions