1. What is the use of CAD in the Manufacturing Company?
CAD is mainly used for detailed engineering of 3Dimensional models or 2Dimensional drawings of physical components. It is also used all the way through the engineering process from theoretical design and layout of products with the help of strength and dynamic analysis of assemblies to definition of manufacturing methods of components. It can also be used to design objects. The use of CAD is quite helpful for speedily transmission in this industry as it allows viewing the designs from any angle and can be easily manipulated in terms of texture and colors. It helps in developing the modular kitchens, bathrooms etc.
2. What are the Software Technologies?
Software Technologies which are used in the AutoCAD Drafter are such as FORTRAN, Programming Languages like C. A CAD system can be seen as built up interaction of GUI with NURBS geometry.
3. What are the Hardware and Operating System Technologies?
It consists of major platforms like QCAD, NX, Windows, Linux, UNIX and Mac OSX. No special hardware is required for the most CAD software. CAD systems can do graphically and computationally expensive tasks. It uses human machine interface through computer mouse, Light pen, Joysticks etc.
4. Tell me something about Manufacturing.
A manufacturing company is a type of company used for harmonization of all safeguarding activities. The manufacturing department is for the manufacturing of various products and goods through several activities like development of raw materials into finished goods.
5. There are so many candidates for this post. Why you think you are applicable for this job?
Well Sir, I am knowledgeable enough in manufacturing and sales departments and have very well interpersonal skill as well as computer skills. I have always a positive attitude towards my work. I will try to give my 100% to this job. My experience will be helpful in the growth of your organization.
These samples will hopefully help you a lot. You can modify the answers on the basis of background and experiences and the way the questions are asked by the interviewer at the time of interview.
Autocad Interview Questions for designer
Autocad Interview Questions for designer
* What are the differences between Dtext and Mtext.
* What is a ctb file.
* Which AutoCAD Layer never plots whether it is turned off or on.
* What are the differences between associative hatching and non-associative hatching.
* If you wanted to select a line and there were other lines on top of it how would you select it.
* What is the difference between the divide command and the measure command.
* If you wanted to increase the length of a line by 20mm how would you do it.
* What does the system variable FILEDIA do.
* What is Orthomode.
* What is the difference between a crossing polygon and a window polygon.
* What is an mnu file.
* What is the difference between Attached and Overlayed Xrefs, and when would you use each?
* What should you be aware of when doing hatching in a drawing that contains an xref?
* What do you need to be aware of when using Perpendicular as a running Osnap?
* Explain what happens when you Wblock items and choose a base point rather than typing 0,0,0.
* What are the differences between Dtext and Mtext.
* What is a ctb file.
* Which AutoCAD Layer never plots whether it is turned off or on.
* What are the differences between associative hatching and non-associative hatching.
* If you wanted to select a line and there were other lines on top of it how would you select it.
* What is the difference between the divide command and the measure command.
* If you wanted to increase the length of a line by 20mm how would you do it.
* What does the system variable FILEDIA do.
* What is Orthomode.
* What is the difference between a crossing polygon and a window polygon.
* What is an mnu file.
* What is the difference between Attached and Overlayed Xrefs, and when would you use each?
* What should you be aware of when doing hatching in a drawing that contains an xref?
* What do you need to be aware of when using Perpendicular as a running Osnap?
* Explain what happens when you Wblock items and choose a base point rather than typing 0,0,0.
Compaq Interview Questions and Answers
Compaq Interview Questions and Answers
1)How do you do dynamic memory allocation in C applications? List advantages and disadvantages of dynamic memory allocation vs. static memory allocation.
Ans In C, malloc, calloc and realloc are used to allocate memory dynamically. In C++, new(), is usually used to allocate objects. Some advantages and disadvantages of dynamic memory allocation are:
Advantages:
• Memory is allocated on an as-needed basis. This helps remove the inefficiencies inherent to static memory allocation (when the amount of memory needed is not known at compile time and one has to make a guess).
Disadvantages:
• Dynamic memory allocation is slower than static memory allocation. This is because dynamic memory allocation happens in the heap area.
• Dynamic memory needs to be carefully deleted after use. They are created in non-contiguous area of memory segment.
• Dynamic memory allocation causes contention between threads, so it degrades performance when it happens in a thread.
• Memory fragmentation.
2.What are references in C++? Why do you need them when you have pointers?
3.Why paging is used ?
4.What leads to code-bloating in C++?
5.Which are the different network topologies ?
6.Write a program to create delay code in c?
7.Why is analysis and testing phases very important ?
8.Write an algorithm for finding the greatest common divisor of two integers.?
9.What is the advantage of Ring network ?
Alogorithm questions asked
10.Write a program to reverse a singly linked list
11.Write a program to delete a node in double linked list
12.Write a program to insert a node in a sorted linked list
1)How do you do dynamic memory allocation in C applications? List advantages and disadvantages of dynamic memory allocation vs. static memory allocation.
Ans In C, malloc, calloc and realloc are used to allocate memory dynamically. In C++, new(), is usually used to allocate objects. Some advantages and disadvantages of dynamic memory allocation are:
Advantages:
• Memory is allocated on an as-needed basis. This helps remove the inefficiencies inherent to static memory allocation (when the amount of memory needed is not known at compile time and one has to make a guess).
Disadvantages:
• Dynamic memory allocation is slower than static memory allocation. This is because dynamic memory allocation happens in the heap area.
• Dynamic memory needs to be carefully deleted after use. They are created in non-contiguous area of memory segment.
• Dynamic memory allocation causes contention between threads, so it degrades performance when it happens in a thread.
• Memory fragmentation.
2.What are references in C++? Why do you need them when you have pointers?
3.Why paging is used ?
4.What leads to code-bloating in C++?
5.Which are the different network topologies ?
6.Write a program to create delay code in c?
7.Why is analysis and testing phases very important ?
8.Write an algorithm for finding the greatest common divisor of two integers.?
9.What is the advantage of Ring network ?
Alogorithm questions asked
10.Write a program to reverse a singly linked list
11.Write a program to delete a node in double linked list
12.Write a program to insert a node in a sorted linked list
Infosys Written test Puzzles with answers
Infosys Written test Puzzles with answers
1. You are given two candles of equal size, which can burn 1 hour each. You have to measure 90 minutes with these candles. (There is no scale or clock). Also u r given a lighter.
Ans: 1. First light up the two ends of the 1st candle. When it will burn out light up one end of the second candle. (30+60=90)
2. Try the similar problem to measure 45 minutes.
Ans: First light-up the two ends of the 1st candle and one end of the 2nd candle.
When the 1st candle will burn out ,then light up the both ends of the 2nd candle (15+30=45)
3. You r given a thermometer. What can u do by this without measuring the temperature?
Ans: if u put thermometer into a tree it won't grow anymore, will just die off
4. How it is possible to place four points that are equidistance from each other?
OR
U r a landscape designer and your boss asked u to design a landscape such that you should place 4 trees equidistance from each other.
(Distance from each tree to the other must be same)
Ans: Only 3 points can be equidistant from each other. But if u place points in the shape of a pyramid then its possible
5. You are given a cake; one of its corner is broken. How will u cut the rest into Two equal parts?
Ans: Slice the cake
6. How will you recognize the magnet & magnetic material & non-magnetic material?
Ans: Drag one piece of material over another. There is no attractive force in the middle portion of the magnet. OR
Get a piece of thread and tie up with the one bar and check for poles. If it iron bar then it moves freely and if it is magnetic bar then it fix in one direction according to poles.
7. If one tyre of a car suddenly gets stolen.... and after sometime u find the tyre
without the screws how will u make ur journey complete?
Ans: Open 3 screws, 1 from each tyre and fix the tyre.
8. How can u measure a room height using a thermometer?
Ans: temp varies with height. but its dependent on various other factors like
humidity, wind etc.
9. What is the height of room if after entering the room with a watch ur head
strikes a hanging bulb?
Ans: Oscillate the hanging bulb. Calculate the time period for one complete
oscillation by Simple Harmonic Motion (SHM) of the handing bulb. Put it in the
formula T=2 * 3.14 * (L/G)^1/2
L will be the length of the hanging thread.
Add the L with ur height to get the height of the room.
OR
Ans: Drop it from the room and find the time at which it strikes the floor. Using physics formula s = (at^2)/2 (IM NOT SURE ABOUT THIS ONE)
10. Color of bear.... if it falls from 1m height in 1s.
Ans: We get 'g' perfect 10 which is only in poles...hence polar bear...color White
11. How will you measure height of building when you are at the top of the building? And if you have stone with you.
Ans: Drop the stone and find the time taken for the stone to reach the ground. find height using the formula
s = a + gt ( s = height, a= initial velocity=0, g=9.8m/s, t = time taken)
12. How wud u catch and receive a ball in same direction? (Dropping is from north And receiving from bottom not accepted, as it is 2 directions)
Ans: ?
13. 25 statements given. Some tell truth, some false and some alternators. Find out the true statements.
Ans: ?
14. Can u make 120 with 5 zeros?
Ans: Factorial (factorial (0)+factorial (0)+factorial (0)+factorial (0)+factorial (0)) = 120
15.There are three people A, B, C. Liars are of same type and Truth speaking people are of same type. Find out who is speaking truth and who is speaking false from the following statements:
a) A says: B is a liar.
b) B says: A and C are of same type.
Ans: lets assume A is speaking truth. It means B is a liar then it means A and C are not of same type.
16.5 swimmers A, B, C, E, F and many conditions of their positions like there are Two b/w A & F, B doesn't win etc the question was to find who was b/w like E & D?
Ans: ?
17. in a race u drove 1st lap with 40kmph and in the second lap at what speed u must drive so that ur average speed must be 80kmph.
Ans: its impossible! if u drove the first lap in 40 kmph, its impossible that the
average speed of both the laps is 80kmph.
for eg. consider one lap distance = 80km.
time req. to cover 1 lap = 80km/40kmph = 2 hrs.
if the avg. speed is 80kmph, then the total time would have taken = 160kms/80kmph = 2 hrs.
same is the case with any other distance u consider. so the avg to be 80kmph is impossible
18. You have to draw 3 concentric circles with a line passing thru their center without lifting hand.
Ans: Start the line complete one circle move inside circles along the line and then draw second circle. Like wise rest.
19. A rectangular paper is there. At a corner a rectangular size paper is taken from it. Now you have to cut the remaining paper into two equal halves.
Ans: try it on the paper. You must fold the part that has complete paper and select Half of it and then fold the part that cut and selects half of it and then cut along the folding. (I DONT UNDERSTAND THIS ONE!!)
20. Value of (x-a)(x-b). . . . (x-z)
Ans: 0 as there's X-X term
21. There are 9 coins. 8 are of 1 gm and 1 is of 2 grams. How will you find out the heavier coin in minimum number of weighing and how many weighing it will need?
Ans: 2 weighing ( Divide the number of coins into 3 parts at each weighing)
1. You are given two candles of equal size, which can burn 1 hour each. You have to measure 90 minutes with these candles. (There is no scale or clock). Also u r given a lighter.
Ans: 1. First light up the two ends of the 1st candle. When it will burn out light up one end of the second candle. (30+60=90)
2. Try the similar problem to measure 45 minutes.
Ans: First light-up the two ends of the 1st candle and one end of the 2nd candle.
When the 1st candle will burn out ,then light up the both ends of the 2nd candle (15+30=45)
3. You r given a thermometer. What can u do by this without measuring the temperature?
Ans: if u put thermometer into a tree it won't grow anymore, will just die off
4. How it is possible to place four points that are equidistance from each other?
OR
U r a landscape designer and your boss asked u to design a landscape such that you should place 4 trees equidistance from each other.
(Distance from each tree to the other must be same)
Ans: Only 3 points can be equidistant from each other. But if u place points in the shape of a pyramid then its possible
5. You are given a cake; one of its corner is broken. How will u cut the rest into Two equal parts?
Ans: Slice the cake
6. How will you recognize the magnet & magnetic material & non-magnetic material?
Ans: Drag one piece of material over another. There is no attractive force in the middle portion of the magnet. OR
Get a piece of thread and tie up with the one bar and check for poles. If it iron bar then it moves freely and if it is magnetic bar then it fix in one direction according to poles.
7. If one tyre of a car suddenly gets stolen.... and after sometime u find the tyre
without the screws how will u make ur journey complete?
Ans: Open 3 screws, 1 from each tyre and fix the tyre.
8. How can u measure a room height using a thermometer?
Ans: temp varies with height. but its dependent on various other factors like
humidity, wind etc.
9. What is the height of room if after entering the room with a watch ur head
strikes a hanging bulb?
Ans: Oscillate the hanging bulb. Calculate the time period for one complete
oscillation by Simple Harmonic Motion (SHM) of the handing bulb. Put it in the
formula T=2 * 3.14 * (L/G)^1/2
L will be the length of the hanging thread.
Add the L with ur height to get the height of the room.
OR
Ans: Drop it from the room and find the time at which it strikes the floor. Using physics formula s = (at^2)/2 (IM NOT SURE ABOUT THIS ONE)
10. Color of bear.... if it falls from 1m height in 1s.
Ans: We get 'g' perfect 10 which is only in poles...hence polar bear...color White
11. How will you measure height of building when you are at the top of the building? And if you have stone with you.
Ans: Drop the stone and find the time taken for the stone to reach the ground. find height using the formula
s = a + gt ( s = height, a= initial velocity=0, g=9.8m/s, t = time taken)
12. How wud u catch and receive a ball in same direction? (Dropping is from north And receiving from bottom not accepted, as it is 2 directions)
Ans: ?
13. 25 statements given. Some tell truth, some false and some alternators. Find out the true statements.
Ans: ?
14. Can u make 120 with 5 zeros?
Ans: Factorial (factorial (0)+factorial (0)+factorial (0)+factorial (0)+factorial (0)) = 120
15.There are three people A, B, C. Liars are of same type and Truth speaking people are of same type. Find out who is speaking truth and who is speaking false from the following statements:
a) A says: B is a liar.
b) B says: A and C are of same type.
Ans: lets assume A is speaking truth. It means B is a liar then it means A and C are not of same type.
16.5 swimmers A, B, C, E, F and many conditions of their positions like there are Two b/w A & F, B doesn't win etc the question was to find who was b/w like E & D?
Ans: ?
17. in a race u drove 1st lap with 40kmph and in the second lap at what speed u must drive so that ur average speed must be 80kmph.
Ans: its impossible! if u drove the first lap in 40 kmph, its impossible that the
average speed of both the laps is 80kmph.
for eg. consider one lap distance = 80km.
time req. to cover 1 lap = 80km/40kmph = 2 hrs.
if the avg. speed is 80kmph, then the total time would have taken = 160kms/80kmph = 2 hrs.
same is the case with any other distance u consider. so the avg to be 80kmph is impossible
18. You have to draw 3 concentric circles with a line passing thru their center without lifting hand.
Ans: Start the line complete one circle move inside circles along the line and then draw second circle. Like wise rest.
19. A rectangular paper is there. At a corner a rectangular size paper is taken from it. Now you have to cut the remaining paper into two equal halves.
Ans: try it on the paper. You must fold the part that has complete paper and select Half of it and then fold the part that cut and selects half of it and then cut along the folding. (I DONT UNDERSTAND THIS ONE!!)
20. Value of (x-a)(x-b). . . . (x-z)
Ans: 0 as there's X-X term
21. There are 9 coins. 8 are of 1 gm and 1 is of 2 grams. How will you find out the heavier coin in minimum number of weighing and how many weighing it will need?
Ans: 2 weighing ( Divide the number of coins into 3 parts at each weighing)
Medical sales Interview Questions
Medical sales Interview Questions
• What type of medical devices/products have you sold? Surgical tools, physical contact with the patient devices or any other instruments etc.
• What is your technical knowledge on these devices?
• How do you research a product or a device?
• Have you taken any classes for Life Sciences, Biology or Chemistry?
• To what target institutes have you sold these products?
• What is your proven record of accomplishment in medical device sales?
• Have you ever entered into conflict with a physician or institution regarding sale or device? How did you handle this? Did you still make the sale?
• What creative ways have you used to meet quotas and deadlines?
• How do you feel when not making a sale or meeting a quota?
• How do you see your future with the medial industry?
• What future do you see for this medical device product?
• Do you have a career goals and objectives for 5 years or 10 years from now?
• What type of medical devices/products have you sold? Surgical tools, physical contact with the patient devices or any other instruments etc.
• What is your technical knowledge on these devices?
• How do you research a product or a device?
• Have you taken any classes for Life Sciences, Biology or Chemistry?
• To what target institutes have you sold these products?
• What is your proven record of accomplishment in medical device sales?
• Have you ever entered into conflict with a physician or institution regarding sale or device? How did you handle this? Did you still make the sale?
• What creative ways have you used to meet quotas and deadlines?
• How do you feel when not making a sale or meeting a quota?
• How do you see your future with the medial industry?
• What future do you see for this medical device product?
• Do you have a career goals and objectives for 5 years or 10 years from now?
Sales Interview Questions
Sales Interview Questions
• What type of products have you sold?
• Do you have a proven record of accomplishment in sales?
• How do you find prospective clients?
• Have you ever used a consulting firm to find clients or buyers?
• Do you often meet your quotas?
• What is your average percentage of quotas met?
• How do you meet your quotas?
• What creative ways have you used to meet quotas and deadlines?
• How do you feel when not making a sale or meeting a quota?
• Do you have a sales plan template? How have you planned? Does your template include a forecast for 30/60/90 days?
• Do you have prospective buyers? To whom do you plan to sell our product?
• How do you plan to follow up on your sales?
• If you meet your quotas for your forecast plan, what is next?
• What if you do not meet your quotas?
• What attracts you to a career in sales?
• What motivates you about sales and marketing?
• Why do you want this job?
• What makes a good sales person?
• Please state your likes and dislikes?
• What type of products have you sold?
• Do you have a proven record of accomplishment in sales?
• How do you find prospective clients?
• Have you ever used a consulting firm to find clients or buyers?
• Do you often meet your quotas?
• What is your average percentage of quotas met?
• How do you meet your quotas?
• What creative ways have you used to meet quotas and deadlines?
• How do you feel when not making a sale or meeting a quota?
• Do you have a sales plan template? How have you planned? Does your template include a forecast for 30/60/90 days?
• Do you have prospective buyers? To whom do you plan to sell our product?
• How do you plan to follow up on your sales?
• If you meet your quotas for your forecast plan, what is next?
• What if you do not meet your quotas?
• What attracts you to a career in sales?
• What motivates you about sales and marketing?
• Why do you want this job?
• What makes a good sales person?
• Please state your likes and dislikes?
Technical Support Interview Questions
Technical Support Interview Questions
Sample or General faqs
What is your basic technical experience and qualifications?
• What technical skills do you possess that would benefit our company?
• What do you know about our products and company?
• Have you used any of our products or similar products/competitors?
• Would you say that you are hands-on type of person?
• What is your expected period for an average call?
• Would you be willing to take training or classes to improve your technical skills?
• What steps do you take for solving a technical problem?
• What tools are most helpful to you when trouble shooting and solving a problem?
Sample or General faqs
What is your basic technical experience and qualifications?
• What technical skills do you possess that would benefit our company?
• What do you know about our products and company?
• Have you used any of our products or similar products/competitors?
• Would you say that you are hands-on type of person?
• What is your expected period for an average call?
• Would you be willing to take training or classes to improve your technical skills?
• What steps do you take for solving a technical problem?
• What tools are most helpful to you when trouble shooting and solving a problem?
Marketing Manager Interview Questions,Faqs
Marketing Manager Interview Questions
1. Have you been a manager of a marketing team in your previous jobs?
2. Have you ever led a team conducting survey analysis and launching new products?
3. How did you correlate your team’s efforts and information? How did this information relate directly to your forecasted objectives?
4. Do you consider yourself a leader? Do you have the drive to lead a marketing team? Can you give examples?
5. What were your marketing goals and objectives?
6. What type of product marketing experiments have you been part of or performed? How did you implement the results?
1. Have you been a manager of a marketing team in your previous jobs?
2. Have you ever led a team conducting survey analysis and launching new products?
3. How did you correlate your team’s efforts and information? How did this information relate directly to your forecasted objectives?
4. Do you consider yourself a leader? Do you have the drive to lead a marketing team? Can you give examples?
5. What were your marketing goals and objectives?
6. What type of product marketing experiments have you been part of or performed? How did you implement the results?
Internet Marketing interview Questions,SEO
Internet Marketing interview Questions
1. What online marketing tools are you familiar with and how do you implement these tools?
2. What internet services have you worked with in the past? How did you offer your product using these tools?
3. What internet service…Google, Yahoo, etc….. Whom do you believe offers the best marketing tools? Can you explain?
4. Do you understand keywords usage and keywords research?
5. What do you know about keyword stemming, density, and proximity?
6. Are you familiar with link building campaign?
7. Are you familiar with SEO?
8. What SEO or SEM services have you used?
9. What are these terms – CPM, PPC and CTR?
10. What types of online advertising tools have you used?
11. How do you implement survey tools to target your market?
12. Can you supply an example of a successful advertising campaign? What was the strategy and tools implemented that made the campaign successful?
1. What online marketing tools are you familiar with and how do you implement these tools?
2. What internet services have you worked with in the past? How did you offer your product using these tools?
3. What internet service…Google, Yahoo, etc….. Whom do you believe offers the best marketing tools? Can you explain?
4. Do you understand keywords usage and keywords research?
5. What do you know about keyword stemming, density, and proximity?
6. Are you familiar with link building campaign?
7. Are you familiar with SEO?
8. What SEO or SEM services have you used?
9. What are these terms – CPM, PPC and CTR?
10. What types of online advertising tools have you used?
11. How do you implement survey tools to target your market?
12. Can you supply an example of a successful advertising campaign? What was the strategy and tools implemented that made the campaign successful?
Product Marketing Interview Questions
Product Marketing Interview Questions
1.What types of products do you market?
2. Are you familiar with our product?
3. What do you know about our firm and our current/past campaigns?
4. Have you ever been a part of a marketing team and do you consider yourself a team player?
5. Have you defined of a new product for the R&D?
6. What steps do you take when launching a new product?
7. What procedure do you take for producing new marketing ideas?
8. How do you research for a target market?
9. Can you supply a successful presentation you made for a product? Can you give reasons as to why it succeeded?
10. What marketing project tools do you use for achieving product goals?
11. Can you give an example of a campaign which hasn’t worked as you had planned? Can you point out the reasons for that failure?
1.What types of products do you market?
2. Are you familiar with our product?
3. What do you know about our firm and our current/past campaigns?
4. Have you ever been a part of a marketing team and do you consider yourself a team player?
5. Have you defined of a new product for the R&D?
6. What steps do you take when launching a new product?
7. What procedure do you take for producing new marketing ideas?
8. How do you research for a target market?
9. Can you supply a successful presentation you made for a product? Can you give reasons as to why it succeeded?
10. What marketing project tools do you use for achieving product goals?
11. Can you give an example of a campaign which hasn’t worked as you had planned? Can you point out the reasons for that failure?
SAP APO Interview Questions and Answers,Faqs
SAP APO Interview Questions and Answers
How can a planning version be frozen and unfrozen?
A Planning Version can be frozen and unfrozen using Function Module /SAPAPO/TS_PAREA_VERSIO_FREEZE so that no further changes to the planning version can be done.
What is Release Profile?
Release Profile is used to release timeseries data from DP to SNP/PPDS. You need to define the DP Planning Area and timeseries keyfigure the data in which is released and the SNP Category Type (typically FA) to which data is released. You may maintain a Daily Buckets Profile it will define the number of working days (working days determined based on Shipping Calendar maintained for the location master) starting on and from the From Date if released online/ interactively or that many workdays of the planning horizon when release is carried out in background. The Period Split (blank, 1 and 2) field in the SNP2 tab of location-product master determines how demand plan is released to SNP from DP (how bucketed data is disaggregated to the workdays).
What is the usage of Period Factor?
Period Factor maintained in the SNP PPM or Transportation Lane determines the Availability Date of a Receipt element within a time bucket (period). The system determines the exact availability date/time of the receipt elements within a period, by adding a time interval (that it gets by multiplying the period factor with the period length) to the start time of the period. You can enter a factor between 0 and 1, where 0 is the start of the period, 0.5 the middle, and 1 the end of the period. When calculating the availability date/time, the system takes into consideration all weekdays, meaning that it does not take into consideration any days that have been defined as non-workdays in the calendars.
Period Factor used is .71 = 7x0.71 = 4.97 or 5 days from ptimizer of weekly bucket resulting in a Friday.
If Period Factor is not maintained in PPM or Transportation Lane then the User Period Factor indicator and the Period Factor value maintained in the Lot Size tab of the location-product combination is used. If this is not maintained a default value of 0.5 is used.
What determines stock categories displayed in Stock on Hand keyfigure?
The categories defined in Category Group ST1 (can be maintained in table /SAPAPO/APOCGC) determine the stock categories that are displayed in the Initial bucket in the Stock on Hand keyfigure. Subsequent buckets are dynamically computed.
Does dynamic alerts show up in Alert Monitor?
Dynamic Alerts do not show up in the stand-alone alert monitor. Network alerts are to show pegging relationships.
What is the report to execute MASSD?
The report for executing MassD in background job is MASSBACK.
What is the shortcut to change location type in APO?
Report /SAPAPO/CHECK_LOCATION_TYPE can be used to change location type (say from 1001 to 1002 or vice-versa) of existing locations in APO. The table to refer is /SAPAPO/LOCMAP. SAP does not recommend this process.
How can a transaction be executed even when no authorization?
SE93 - Transaction code for Transaction Code E.g. CRC1 Create Resource has txn code CRAH. So if you do not have authorization to create resource you can use SE93 and enter txn CRAH and then Test F8 button to go to the txn.
How to copy a Process Chain?
To copy a process chain to another process chain, goto the Process Chain you want to copy and then type copy in the tool tar and hit enter. It will allow you to copy the Process Chain to another Process Chain that can be modified as per user's requirement, saved, activated and used.
What is the process to copy planning versions in R/3?
Use OLIX to first delete previous MRP planning versions. Then use MCB& to create the new MRP planning versions by choosing the appropriate version you want to create as ICO Version. The info structure in this case is S094.
How to use create planning book with two tables?
To use two tables on one screen of Planning Book/Data View - select indicator next to second page title and give name. Additional tab page is displayed in Planning Book Maintenance wizard to define the keyfigures for the second table.
What is Master Data in DP?
Master Data in Demand Planning primarily is Charcateristic Value Combinations commonly termed CVCs. CVCs are the planning combinations against which data is stored in keyfigures.
What is the behaviour of Procurement Type X?
Procurement Type X - source selection is based on matching due date then priority then cost. If both In-house Production and External Procuremnet is possible then In-house Production (PPM) is chosen as source of supply.
What is PPDS Fixing Horizon?
PP/DS fixing Horizon defines the PP/DS time Fence - within that period if heuristic is run no orders get changed.
What is the reuse mode in Product Heuristic?
Reuse mode in Product Heuristic - makes the system to reuse orders already present in the heuristic run i.e. orders are not deleted and recreated.
What is Planning Procedure?
Planning Procedure in Product Master (PP/DS) defines that when you convert a planned order to process order it is in Deallocated state and not Scheduled state and more.
Which are the components of the new mySAP SCM Solution?
SAP SCM 4.1 is the new available Supply Chain Management Solution offered by SAP. The SAP SCM 4.1 System includes SAP APO 4.1 (Advanced Planning and Optimization), SAP ICH 4.1 (Inventory Collaboration Hub) and SAP EM 4.1 (Event Management).
How about the architecture of SAP SCM 4.1?
SAP SCM 4.1 is based on the SAP Web Application Server 6.40. All SAP SCM 4.1 Architecture Components can be installed on one hardware server, as long as this server is sized for all used application components.
What does APO mean?
SAP APO stands for SAP Advanced Planning and Optimization and is the planning component within the mySAP SCM solution.
Can SAP APO be used as a stand-alone solution?
No, SAP APO always requires a backend ERP system for execution functions. In most cases, the backend system is an SAP R/3 system.
Can SAP APO and SAP R/3 be installed on the same server and use the same database?
No, SAP APO requires a separate server. The actual size of the SAP APO system may vary and depends on the data volume to be processed. You can find more details on this subject under the alias /sizing on the SAP Service Marketplace (//http:/service.sap.com).
How does SAP R/3 communicate with SAP APO?
Through the APO Core Interface (CIF) which supplies SAP APO with master and transaction data in real time. CIF is delivered through the R/3 Plug-In, which is something you have to install in your SAP R/3 system. This is the same Plug-In that you need for connecting a BW or a CRM system.
What about the exchange of data between the two systems?
With SAP APO you have a real-time integration to SAP R/3. The minute you change something in one system, it is immediately being transferred to the other and vice versa. And that goes for all data, be it a sales order, a production order or a purchase order. You do not have to perform any batch jobs for transferring data between the systems.
OK, SAP APO is a separate system. Do I have to maintain the master data twice?
No. You create and change master data exclusively in SAP R/3. If you want to work with SAP APO, you need to transfer the master data from the SAP R/3 system.
Depending on the scenario you want to use in SAP APO, you may have to enhance the transferred data with SAP APO specific settings, which are not relevant to SAP R/3.
What is an easy, cost efficient way of installing some standard SAP APO scenarios?
The answer is: SAP Best Practices for Supply Chain Management. Choose one or more of the mySAP SCM business scenarios that SAP Best Practices for SCM provide.
How can a planning version be frozen and unfrozen?
A Planning Version can be frozen and unfrozen using Function Module /SAPAPO/TS_PAREA_VERSIO_FREEZE so that no further changes to the planning version can be done.
What is Release Profile?
Release Profile is used to release timeseries data from DP to SNP/PPDS. You need to define the DP Planning Area and timeseries keyfigure the data in which is released and the SNP Category Type (typically FA) to which data is released. You may maintain a Daily Buckets Profile it will define the number of working days (working days determined based on Shipping Calendar maintained for the location master) starting on and from the From Date if released online/ interactively or that many workdays of the planning horizon when release is carried out in background. The Period Split (blank, 1 and 2) field in the SNP2 tab of location-product master determines how demand plan is released to SNP from DP (how bucketed data is disaggregated to the workdays).
What is the usage of Period Factor?
Period Factor maintained in the SNP PPM or Transportation Lane determines the Availability Date of a Receipt element within a time bucket (period). The system determines the exact availability date/time of the receipt elements within a period, by adding a time interval (that it gets by multiplying the period factor with the period length) to the start time of the period. You can enter a factor between 0 and 1, where 0 is the start of the period, 0.5 the middle, and 1 the end of the period. When calculating the availability date/time, the system takes into consideration all weekdays, meaning that it does not take into consideration any days that have been defined as non-workdays in the calendars.
Period Factor used is .71 = 7x0.71 = 4.97 or 5 days from ptimizer of weekly bucket resulting in a Friday.
If Period Factor is not maintained in PPM or Transportation Lane then the User Period Factor indicator and the Period Factor value maintained in the Lot Size tab of the location-product combination is used. If this is not maintained a default value of 0.5 is used.
What determines stock categories displayed in Stock on Hand keyfigure?
The categories defined in Category Group ST1 (can be maintained in table /SAPAPO/APOCGC) determine the stock categories that are displayed in the Initial bucket in the Stock on Hand keyfigure. Subsequent buckets are dynamically computed.
Does dynamic alerts show up in Alert Monitor?
Dynamic Alerts do not show up in the stand-alone alert monitor. Network alerts are to show pegging relationships.
What is the report to execute MASSD?
The report for executing MassD in background job is MASSBACK.
What is the shortcut to change location type in APO?
Report /SAPAPO/CHECK_LOCATION_TYPE can be used to change location type (say from 1001 to 1002 or vice-versa) of existing locations in APO. The table to refer is /SAPAPO/LOCMAP. SAP does not recommend this process.
How can a transaction be executed even when no authorization?
SE93 - Transaction code for Transaction Code E.g. CRC1 Create Resource has txn code CRAH. So if you do not have authorization to create resource you can use SE93 and enter txn CRAH and then Test F8 button to go to the txn.
How to copy a Process Chain?
To copy a process chain to another process chain, goto the Process Chain you want to copy and then type copy in the tool tar and hit enter. It will allow you to copy the Process Chain to another Process Chain that can be modified as per user's requirement, saved, activated and used.
What is the process to copy planning versions in R/3?
Use OLIX to first delete previous MRP planning versions. Then use MCB& to create the new MRP planning versions by choosing the appropriate version you want to create as ICO Version. The info structure in this case is S094.
How to use create planning book with two tables?
To use two tables on one screen of Planning Book/Data View - select indicator next to second page title and give name. Additional tab page is displayed in Planning Book Maintenance wizard to define the keyfigures for the second table.
What is Master Data in DP?
Master Data in Demand Planning primarily is Charcateristic Value Combinations commonly termed CVCs. CVCs are the planning combinations against which data is stored in keyfigures.
What is the behaviour of Procurement Type X?
Procurement Type X - source selection is based on matching due date then priority then cost. If both In-house Production and External Procuremnet is possible then In-house Production (PPM) is chosen as source of supply.
What is PPDS Fixing Horizon?
PP/DS fixing Horizon defines the PP/DS time Fence - within that period if heuristic is run no orders get changed.
What is the reuse mode in Product Heuristic?
Reuse mode in Product Heuristic - makes the system to reuse orders already present in the heuristic run i.e. orders are not deleted and recreated.
What is Planning Procedure?
Planning Procedure in Product Master (PP/DS) defines that when you convert a planned order to process order it is in Deallocated state and not Scheduled state and more.
Which are the components of the new mySAP SCM Solution?
SAP SCM 4.1 is the new available Supply Chain Management Solution offered by SAP. The SAP SCM 4.1 System includes SAP APO 4.1 (Advanced Planning and Optimization), SAP ICH 4.1 (Inventory Collaboration Hub) and SAP EM 4.1 (Event Management).
How about the architecture of SAP SCM 4.1?
SAP SCM 4.1 is based on the SAP Web Application Server 6.40. All SAP SCM 4.1 Architecture Components can be installed on one hardware server, as long as this server is sized for all used application components.
What does APO mean?
SAP APO stands for SAP Advanced Planning and Optimization and is the planning component within the mySAP SCM solution.
Can SAP APO be used as a stand-alone solution?
No, SAP APO always requires a backend ERP system for execution functions. In most cases, the backend system is an SAP R/3 system.
Can SAP APO and SAP R/3 be installed on the same server and use the same database?
No, SAP APO requires a separate server. The actual size of the SAP APO system may vary and depends on the data volume to be processed. You can find more details on this subject under the alias /sizing on the SAP Service Marketplace (//http:/service.sap.com).
How does SAP R/3 communicate with SAP APO?
Through the APO Core Interface (CIF) which supplies SAP APO with master and transaction data in real time. CIF is delivered through the R/3 Plug-In, which is something you have to install in your SAP R/3 system. This is the same Plug-In that you need for connecting a BW or a CRM system.
What about the exchange of data between the two systems?
With SAP APO you have a real-time integration to SAP R/3. The minute you change something in one system, it is immediately being transferred to the other and vice versa. And that goes for all data, be it a sales order, a production order or a purchase order. You do not have to perform any batch jobs for transferring data between the systems.
OK, SAP APO is a separate system. Do I have to maintain the master data twice?
No. You create and change master data exclusively in SAP R/3. If you want to work with SAP APO, you need to transfer the master data from the SAP R/3 system.
Depending on the scenario you want to use in SAP APO, you may have to enhance the transferred data with SAP APO specific settings, which are not relevant to SAP R/3.
What is an easy, cost efficient way of installing some standard SAP APO scenarios?
The answer is: SAP Best Practices for Supply Chain Management. Choose one or more of the mySAP SCM business scenarios that SAP Best Practices for SCM provide.
CA TestLead Interview Questions
CA TestLead Interview Questions
1. Why S/W need testing?
2. How will you choose your Test team?
3. Testplan shouldn’t contain?
4. Extension for Object Repository in QTP? Ans: .TSR
5. How will you communicate with client in deadline situations?
6. QTP uses which script?
7. QTP and QC Integration?
8. What are list of Functional testing tools?
1. Why S/W need testing?
2. How will you choose your Test team?
3. Testplan shouldn’t contain?
4. Extension for Object Repository in QTP? Ans: .TSR
5. How will you communicate with client in deadline situations?
6. QTP uses which script?
7. QTP and QC Integration?
8. What are list of Functional testing tools?
Encora Interview Questions for Software Test Engineer
Encora Interview Questions for Software Test Engineer
1. What kind of Approach you’re following in your project
2. What is Test plan
3. What is Test Strategy
4. Who is responsible for rejected defect
5. What type of framework you’re using in your project
6. Who is the responsible for project estimation
7. What is Traceability matrix
8. Who is responsible for preparing traceability matrix
9. What is virtual object in QTP
10. What type of Add-ins are available in the QTP
11. How many type of Add-ins you used already
12. What types of error handling method are available in the QTP
13. What is the difference between Function and Subroutine
14. What is Database testing
15. How many types of language are available in the QTP
1. What kind of Approach you’re following in your project
2. What is Test plan
3. What is Test Strategy
4. Who is responsible for rejected defect
5. What type of framework you’re using in your project
6. Who is the responsible for project estimation
7. What is Traceability matrix
8. Who is responsible for preparing traceability matrix
9. What is virtual object in QTP
10. What type of Add-ins are available in the QTP
11. How many type of Add-ins you used already
12. What types of error handling method are available in the QTP
13. What is the difference between Function and Subroutine
14. What is Database testing
15. How many types of language are available in the QTP
Patni Interview Questions for Software Test Engineer
Patni Interview Questions for Software Test Engineer
1. Tell me about yourself?
2. What testing procedure you follow?
3. What is STLC?
4. Any idea about CMM?
5. How do you write defect Report?
6. One scenario: yahoo inbox doesn’t show emails but instead of all inbox emails are shown in draft folder. how do you write defect report for this scenario
7. Write the three important scenario or test cases for Air conditioner (AC)
8. What procedure you follow between gathering requirements and carried out testing?
1. Tell me about yourself?
2. What testing procedure you follow?
3. What is STLC?
4. Any idea about CMM?
5. How do you write defect Report?
6. One scenario: yahoo inbox doesn’t show emails but instead of all inbox emails are shown in draft folder. how do you write defect report for this scenario
7. Write the three important scenario or test cases for Air conditioner (AC)
8. What procedure you follow between gathering requirements and carried out testing?
NCR Interview Questions for Software Test engineer
NCR Interview Questions for Software Test engineer
1. How do you Test Web based applications?
2. What is security testing?
3. What is VSS?
4. How do you capture defects?
5. What is the defect tracking tool you use in your organization
6. Difference between smoke and sanity testing?
7. Scrum method
8. V- Model
1. How do you Test Web based applications?
2. What is security testing?
3. What is VSS?
4. How do you capture defects?
5. What is the defect tracking tool you use in your organization
6. Difference between smoke and sanity testing?
7. Scrum method
8. V- Model
Sapient Interview Questions for Software TestEngineer
Sapient Interview Questions for Software TestEngineer
1. What will happen if i select all the add-ins in QTP at a time?
Answer: Select only the add-ins that you need for the current Test. Selecting all available add-ins can cause QuickTest Professional internal inconsistencies which may lead to test failures.
2. What are the default and optional add-ins available in QTP?
Default:ActiveX,Visual Basic and Web
Optional: The optional add-ins include Java, .NET, oracle, PeopleSoft, SAP, Siebel, Terminal Emulator, Visual Age Smalltalk and Web Services.
3. Differences between Global and Action sheets in Data table?
Answer: Simple difference here b/w these two is:
Global Sheet:Can be accessible for all the Actions in the entire Test.
Action Sheet: Will be accessible only for that action.Other actions can’t use data in this action sheet.
4. What is Active Screen?
5. Why we need Automation testing?
6. Diff b/w QTP & Win Runner?
7. In how many ways you can insert check points.
Answer: We can insert check points in 4 ways: Through Insert menu,Right click in Keyword View,Right click in Expert view,Right click in Active screen.
8. General Elements/Options in a bug Report?
9. What test plan should contain?
10. Diff b/w Test Plan and Test Strategy?
1. What will happen if i select all the add-ins in QTP at a time?
Answer: Select only the add-ins that you need for the current Test. Selecting all available add-ins can cause QuickTest Professional internal inconsistencies which may lead to test failures.
2. What are the default and optional add-ins available in QTP?
Default:ActiveX,Visual Basic and Web
Optional: The optional add-ins include Java, .NET, oracle, PeopleSoft, SAP, Siebel, Terminal Emulator, Visual Age Smalltalk and Web Services.
3. Differences between Global and Action sheets in Data table?
Answer: Simple difference here b/w these two is:
Global Sheet:Can be accessible for all the Actions in the entire Test.
Action Sheet: Will be accessible only for that action.Other actions can’t use data in this action sheet.
4. What is Active Screen?
5. Why we need Automation testing?
6. Diff b/w QTP & Win Runner?
7. In how many ways you can insert check points.
Answer: We can insert check points in 4 ways: Through Insert menu,Right click in Keyword View,Right click in Expert view,Right click in Active screen.
8. General Elements/Options in a bug Report?
9. What test plan should contain?
10. Diff b/w Test Plan and Test Strategy?
United Health Group(UHG) Interview questions for Test Engineer
United Health Group(UHG) Interview questions for Test Engineer
1. What is sdlc
2. Which model do you follow?
3. Tell me something about you that is not mentioned in your resume?
4. Priority, severity with examples
5. If a build is given and in a module which is supposed to perform addition, but it fails. dev team fixes and gives it back, the next time the corresponding multiplication fails, how will you make sure that this is a Regression issue?
(He expects us to execute all the Test cases written for a Application once on the old application and record all the Results as proof)
6. What are your roles in your organization
7. Project and architecture
8. Test plan
9. Basic SQL
10. How do you inform about known issues
1. What is sdlc
2. Which model do you follow?
3. Tell me something about you that is not mentioned in your resume?
4. Priority, severity with examples
5. If a build is given and in a module which is supposed to perform addition, but it fails. dev team fixes and gives it back, the next time the corresponding multiplication fails, how will you make sure that this is a Regression issue?
(He expects us to execute all the Test cases written for a Application once on the old application and record all the Results as proof)
6. What are your roles in your organization
7. Project and architecture
8. Test plan
9. Basic SQL
10. How do you inform about known issues
IVY COMPTECH Software Test engineer interview questions
IVY COMTECH Software Test engineer interview questions
1. Tell me about yourself?
2. Your current project architecture.
3. What is white box & black box?Diff b/w them?
4. How QTP recognizes the Objects?
5. What if the object properties change compared to Recording?Run fails?
6. Given a simple election Application form and asked to write min number of functional Test cases to cover the whole form functionality?
7. Why automation?What do you get from it?
8. How to reduce the project budget?
9. When we need to go for descriptive programming in QTP?
1. Tell me about yourself?
2. Your current project architecture.
3. What is white box & black box?Diff b/w them?
4. How QTP recognizes the Objects?
5. What if the object properties change compared to Recording?Run fails?
6. Given a simple election Application form and asked to write min number of functional Test cases to cover the whole form functionality?
7. Why automation?What do you get from it?
8. How to reduce the project budget?
9. When we need to go for descriptive programming in QTP?
Prokarma QTP Interview Questions
Prokarma QTP Interview Questions
1. Tell me about your self?
2. What framework you use in your project?
3. How do you connect QTP with Database?
4. How do you connect QC & QTP?
5. Rate yourself in VB Scripting from 1 to 5 ?
6. How often you do descriptive programming in your project?
7. Most difficult bug you found in your project?
8. If i give you a project and ask to start from today.And you will be only the person in project.How would you start the day?
9. In how many ways you can play with Synchronization point in your script?
10. Can you write a script to fill the user name and password fields in an Application?
11. What is the Object Repository maximum size?
12. Why do we need descriptive programming?though we have record and playback.
13. Why you are looking for a change?
1. Tell me about your self?
2. What framework you use in your project?
3. How do you connect QTP with Database?
4. How do you connect QC & QTP?
5. Rate yourself in VB Scripting from 1 to 5 ?
6. How often you do descriptive programming in your project?
7. Most difficult bug you found in your project?
8. If i give you a project and ask to start from today.And you will be only the person in project.How would you start the day?
9. In how many ways you can play with Synchronization point in your script?
10. Can you write a script to fill the user name and password fields in an Application?
11. What is the Object Repository maximum size?
12. Why do we need descriptive programming?though we have record and playback.
13. Why you are looking for a change?
ADP Testing Interview Questions Hyderabad
ADP Testing Interview Questions Hyderabad
1. What Frameworks at QTP?
2. What is Object Repository?
3. Extension for Object Repository file?
4. Diff b/w call to Existing Action and call to Copy of Action?
5. What is Split Action?
6. Explain a critical bug you found in automation?
7. How will you integrate QC & QTP?
8. What is Test Plan?
9. Diff b/w Test Plan & Test Strategy?
10. Diff b/w QTP & Win runner?
11. Check points and explain each of them?
12. Why Step Generator?
1. What Frameworks at QTP?
2. What is Object Repository?
3. Extension for Object Repository file?
4. Diff b/w call to Existing Action and call to Copy of Action?
5. What is Split Action?
6. Explain a critical bug you found in automation?
7. How will you integrate QC & QTP?
8. What is Test Plan?
9. Diff b/w Test Plan & Test Strategy?
10. Diff b/w QTP & Win runner?
11. Check points and explain each of them?
12. Why Step Generator?
WellsFargo Testing Interview Questions
WellsFargo Testing Interview Questions
1. What is the testing process you follow in your organization?
2. What is the bug Life Cycle you follow?
3. Say your Product passed through testing and UAT. Now it went to production at client location and they found one defect in it. How they need to procced now? Will they contact you? Will they contact dev team?
4. What is Object Repository? How many types in it?
5. How many types of Actions are there in QTP?
6. When you open QTP, how many sheets you can see? (Ans: Local & Global sheets)
7. What is a Join and types?
8. What are stored procedures?
9. Write a query to retrieve the second highest paid employee from the salary table?
10. What is compatability testing?
11. Explain a scenario and few Test cases for compatability testing?
12. Say i have a Gmail page opened in IE8, now what would be your compatability test cases for that?
13. Write a QTP script to enter a keyword in to Google search engine?
14. Can we add new Objects & properties into shared object repository?
15. What exactly a test plan contains?
16. What are all the documents needs to be submitted as a part of test closure?
17. What are enter & exit criterias of a test paln?
18. What is Traceability matrix?
19. What is recovery scenario?
20. How to pass values into a datatable?
21. What is the difference between a Function and Action in QTP?
22. What is the difference between a Function and Procedure in QTP?
23. Difference between action & Reusable action?
1. What is the testing process you follow in your organization?
2. What is the bug Life Cycle you follow?
3. Say your Product passed through testing and UAT. Now it went to production at client location and they found one defect in it. How they need to procced now? Will they contact you? Will they contact dev team?
4. What is Object Repository? How many types in it?
5. How many types of Actions are there in QTP?
6. When you open QTP, how many sheets you can see? (Ans: Local & Global sheets)
7. What is a Join and types?
8. What are stored procedures?
9. Write a query to retrieve the second highest paid employee from the salary table?
10. What is compatability testing?
11. Explain a scenario and few Test cases for compatability testing?
12. Say i have a Gmail page opened in IE8, now what would be your compatability test cases for that?
13. Write a QTP script to enter a keyword in to Google search engine?
14. Can we add new Objects & properties into shared object repository?
15. What exactly a test plan contains?
16. What are all the documents needs to be submitted as a part of test closure?
17. What are enter & exit criterias of a test paln?
18. What is Traceability matrix?
19. What is recovery scenario?
20. How to pass values into a datatable?
21. What is the difference between a Function and Action in QTP?
22. What is the difference between a Function and Procedure in QTP?
23. Difference between action & Reusable action?
Mahindra Satyam QTP Interview Questions
Mahindra Satyam QTP Interview Questions
1. How many types of Object repositories are there in QTP (Ans: Share & Local)
2. What are the Repository features (Ans: Object locator, Add, Merging, Comparing)
3. How to create a recovery scenario? What does recovery scenario manager do?
4. How to calculate number of Web links in a web Application using descriptive programming?
5. Open a word file and modified with some value using QTP?
6. How to create a excel file using QTP?
7. How to retrieve a value from web table? (Ans: Get Celldata(row, col))
8. What is QC requirement tab do? and how to map the requirements?
9. What is defect Life Cycle?
10. What is difference between smoke testing and sanity testing?
11. What are the main content in the Testplan?
12. How to create environmental variable?
13. How to create Action?
14. How many types of action are there in the QTP? (Ans: Non-reusable, Reusable, External)
15. How to pass a value from excel file to script?
16. What is the use of Split function?
17. What is defect leakage?
18. What are the properties of a defect template?
19. What are the types of testing?
1. How many types of Object repositories are there in QTP (Ans: Share & Local)
2. What are the Repository features (Ans: Object locator, Add, Merging, Comparing)
3. How to create a recovery scenario? What does recovery scenario manager do?
4. How to calculate number of Web links in a web Application using descriptive programming?
5. Open a word file and modified with some value using QTP?
6. How to create a excel file using QTP?
7. How to retrieve a value from web table? (Ans: Get Celldata(row, col))
8. What is QC requirement tab do? and how to map the requirements?
9. What is defect Life Cycle?
10. What is difference between smoke testing and sanity testing?
11. What are the main content in the Testplan?
12. How to create environmental variable?
13. How to create Action?
14. How many types of action are there in the QTP? (Ans: Non-reusable, Reusable, External)
15. How to pass a value from excel file to script?
16. What is the use of Split function?
17. What is defect leakage?
18. What are the properties of a defect template?
19. What are the types of testing?
Qtp Interview Questions Oracle india
Qtp Interview Questions Oracle india
1. How to retrieve number from alphanumeric value.
2. How to capture a dynamic value in Web Application
3. How to get the output value from one transaction and use this output value as input of another transaction.
4. What are the business process following in your project
5. How to count a web table row
6. What is the QC Life Cycle
7. How many types of Frame work and which one you are implementing in your project
1. How to retrieve number from alphanumeric value.
2. How to capture a dynamic value in Web Application
3. How to get the output value from one transaction and use this output value as input of another transaction.
4. What are the business process following in your project
5. How to count a web table row
6. What is the QC Life Cycle
7. How many types of Frame work and which one you are implementing in your project
Oracle India QTP Interview Questions and Answers
Oracle India(Company) QTP Interview Questions and Answers
Some knowledge of C,C++ is also required @Oracle
Questions:
1. Types of Recording modes available in QTP? (Ans: Normal,Analog,Low-level)
2. Types of Run modes available in QTP? (Ans: Normal & Fast)
3. RO & TO in GetROproperty & GetTOproperty stands for? (Ans: Run-time Object & Test Object)
4. What is Object Repository and types available? (Ans: Stores object properties. Types are Local & Shared)
5. Disadvantages of Shared Object repository?
6. What are Call to Copy of Action & call to Existing Action? And difference between them?
7. Given scenario is like this: One Web table is there and you have to search and retrieve a cell data which is equal to the given number say:123. Assume you have given with the column name/id of the table where the number may exist. So now you have to go to the given column and search for the number 123 and retrieve it along with the row number of it.
8. Extending to question no:7, Say the cell has the value 123 with a space suffixing it (Say:123″space”). Now how will you compare the retrieved value with the given value 123 (Comparison will fail, as you have a space at the end of retrieved value). How will you overcome this?
9. Take sdlc & STLC, what are main differences between those 2? Which can be done in SDLC and can’t be done in STLC or vice-versa?
10. Write a C program to know whether given string is a palindrome or not? (Write without using string functions)
11. Write a C program to know whether given number is a perfect number or not?
12. Given with a alphanumeric string (Say:Oracle123), How will you find how many alphabets are there in the given string? And how many numeric’s are there?
Some knowledge of C,C++ is also required @Oracle
Questions:
1. Types of Recording modes available in QTP? (Ans: Normal,Analog,Low-level)
2. Types of Run modes available in QTP? (Ans: Normal & Fast)
3. RO & TO in GetROproperty & GetTOproperty stands for? (Ans: Run-time Object & Test Object)
4. What is Object Repository and types available? (Ans: Stores object properties. Types are Local & Shared)
5. Disadvantages of Shared Object repository?
6. What are Call to Copy of Action & call to Existing Action? And difference between them?
7. Given scenario is like this: One Web table is there and you have to search and retrieve a cell data which is equal to the given number say:123. Assume you have given with the column name/id of the table where the number may exist. So now you have to go to the given column and search for the number 123 and retrieve it along with the row number of it.
8. Extending to question no:7, Say the cell has the value 123 with a space suffixing it (Say:123″space”). Now how will you compare the retrieved value with the given value 123 (Comparison will fail, as you have a space at the end of retrieved value). How will you overcome this?
9. Take sdlc & STLC, what are main differences between those 2? Which can be done in SDLC and can’t be done in STLC or vice-versa?
10. Write a C program to know whether given string is a palindrome or not? (Write without using string functions)
11. Write a C program to know whether given number is a perfect number or not?
12. Given with a alphanumeric string (Say:Oracle123), How will you find how many alphabets are there in the given string? And how many numeric’s are there?
CSC Interview Questions for cpp developer
CSC Interview Questions for cpp developer
1)Difference between C &C++
2.)Tell about Virtual functions with example
3)Tell Concept of Oops.
4)Polymorphism with real time example
5)Difference between function declaration and abstract class
6)Why the scope resoln operator can't be overloaded?
7)Tell about what happens of Construction and destruction of the derived class objects,
8)When are copy constructors called?
9)What are Templates
10)What is size of null class
11)Differentiaite between vector and array
12) Differentiate between C&C++ Structure
13)Difference between class and structure
14) Why we use C++ why not C ?
15)Can we have Virtual Constructure
1)Difference between C &C++
2.)Tell about Virtual functions with example
3)Tell Concept of Oops.
4)Polymorphism with real time example
5)Difference between function declaration and abstract class
6)Why the scope resoln operator can't be overloaded?
7)Tell about what happens of Construction and destruction of the derived class objects,
8)When are copy constructors called?
9)What are Templates
10)What is size of null class
11)Differentiaite between vector and array
12) Differentiate between C&C++ Structure
13)Difference between class and structure
14) Why we use C++ why not C ?
15)Can we have Virtual Constructure
Android Tutorials : Different Layout available
An Android layout is a class that handles arranging the way its children appear on the screen. Anything that is a View (or inherits from View) can be a child of a layout. All of the layouts inherit from ViewGroup (which inherits from View) so you can nest layouts. You could also create your own custom layout by making a class that inherits from ViewGroup.
The standard Layouts are:
AbsoluteLayout
FrameLayout
LinearLayout
RelativeLayout
TableLayout
Part 2 Explains the Layouts in detail
The standard Layouts are:
AbsoluteLayout
FrameLayout
LinearLayout
RelativeLayout
TableLayout
Part 2 Explains the Layouts in detail
nVidia Interview questions Faqs
nVedia Interview questions Faqs
1. Reverse link list
2. print any tree without using recursion (difficult)
3. is num odd parity ?
4. I have a number in float like 2.5.Store this number in int in such a way that store 2 in bits 31-16 and 5 in 15-0.write a function to do that to convert it and vice versa.
5. reverse binary representation of number.
6. write a macro to give offset of particular field in structure.Like struct abc { int a,int b,char c}. Write a macro like offset(abc , c) to find offset of c from top.
7. basic questions like what is volatile , static and where to use them and why?
8. find number of 1's in paritcular number fastest way possible. (use hash table).
9. function to give mask for first 2 non zero (anything except 00) values in int.
10.find max number of repeatations in an array.like {2,3,4,5,2,3,2} max repeat is 2. optimize it for space then in time.
11)What is DMA?
12)Can user level buffer / pointer used by kernel or drivers?
13)Draw 2-level paging diagram.
14)Implement in-place swap. Now implement one won't cause overflow (i.e: can't use addition)
15)Reverse bit within a 32 bit integer
16)Reverse linked-list Implement atoi(char *p)
17)Detect loop in a singlely linked-list
18)Implement align_malloc() and align_free(),
1. Reverse link list
2. print any tree without using recursion (difficult)
3. is num odd parity ?
4. I have a number in float like 2.5.Store this number in int in such a way that store 2 in bits 31-16 and 5 in 15-0.write a function to do that to convert it and vice versa.
5. reverse binary representation of number.
6. write a macro to give offset of particular field in structure.Like struct abc { int a,int b,char c}. Write a macro like offset(abc , c) to find offset of c from top.
7. basic questions like what is volatile , static and where to use them and why?
8. find number of 1's in paritcular number fastest way possible. (use hash table).
9. function to give mask for first 2 non zero (anything except 00) values in int.
10.find max number of repeatations in an array.like {2,3,4,5,2,3,2} max repeat is 2. optimize it for space then in time.
11)What is DMA?
12)Can user level buffer / pointer used by kernel or drivers?
13)Draw 2-level paging diagram.
14)Implement in-place swap. Now implement one won't cause overflow (i.e: can't use addition)
15)Reverse bit within a 32 bit integer
16)Reverse linked-list Implement atoi(char *p)
17)Detect loop in a singlely linked-list
18)Implement align_malloc() and align_free(),
CaptialIQ Interview Questions for Software Developer
CaptialIQ Interview Questions for Software Developer
1)Please can you explain Entity-Relationship diagram,Draw taking a company as example and explain
2)Write an object(class), called StockCache, that caches a single stock every couple of minutes. What are the function prototypes? Where would you need to put in thread protection? How would you organize the set of StockCache objects?
3)Write a program to determine a palindrome?
4)Write a program to reverse linked list ,without using extra node?
5)Write a program to count number of bits in a Byte(Char data )
6)Write a program to count number of nodes in a linked list?
Other Questions asked @CapitalIQ
1)Tell me the genuine reason for leaving your current job?
2)What you feel you have learnt from your current which you cant learn any where
1)Please can you explain Entity-Relationship diagram,Draw taking a company as example and explain
2)Write an object(class), called StockCache, that caches a single stock every couple of minutes. What are the function prototypes? Where would you need to put in thread protection? How would you organize the set of StockCache objects?
3)Write a program to determine a palindrome?
4)Write a program to reverse linked list ,without using extra node?
5)Write a program to count number of bits in a Byte(Char data )
6)Write a program to count number of nodes in a linked list?
Other Questions asked @CapitalIQ
1)Tell me the genuine reason for leaving your current job?
2)What you feel you have learnt from your current which you cant learn any where
Apple Interview Questions
Apple Interview Questions
Some interview questions I was asked at Apple: from zevens blog
* Choose something you know a lot about, and teach it to us.
* Tell us about two situation in which you worked in a group, one time it worked well and another time it didn't.
* Look at C code fragments and find the error (a buffer overflow due to a lack of bounds checking on function parameters, and using a short data type when a long would have been safer.)
* Describe the strengths and weaknesses of two or three programming languages.
* Describe three drawbacks to using C++ for a project.
* Describe test cases where automation doesn't work well.
* I see you took course x, tell me about it and why you liked it.
* How are you different from your peers?
* What was your favorite course?
* If you found a certain bug in the software you were testing, describe the steps you would take to verify it and write it up. They gave me a couple hypothetical bugs to consider.
* Describe x, y, and z about this particular job on your resume.
Overall, nothing too suprising. There must have been more questions than this but that's all I can remember for now :)
Some interview questions I was asked at Apple: from zevens blog
* Choose something you know a lot about, and teach it to us.
* Tell us about two situation in which you worked in a group, one time it worked well and another time it didn't.
* Look at C code fragments and find the error (a buffer overflow due to a lack of bounds checking on function parameters, and using a short data type when a long would have been safer.)
* Describe the strengths and weaknesses of two or three programming languages.
* Describe three drawbacks to using C++ for a project.
* Describe test cases where automation doesn't work well.
* I see you took course x, tell me about it and why you liked it.
* How are you different from your peers?
* What was your favorite course?
* If you found a certain bug in the software you were testing, describe the steps you would take to verify it and write it up. They gave me a couple hypothetical bugs to consider.
* Describe x, y, and z about this particular job on your resume.
Overall, nothing too suprising. There must have been more questions than this but that's all I can remember for now :)
Unix, Operating system interview questions faqs
Unix, Operating system interview questions faqs
1)What is the difference between a shell variable that is exported and the one that is not e...
2)What are the possible return status of kill() command?
3)What are the benefits of creating links to a file?
4)What is wildcard?
5)Write a script to convert all dos style backslashes to unix style slashes in a list of fil...
6)How do you read arguments in a shell program - $1, $2 ?
7)What are the steps to take files from unix server to windows?
8)What is the method of setting an environment variable from a program?
9)How do you debug a core dump?
10)How to delete a word from a file using shell scripting???
11)What is the concept of named pipe?
12)How does fork() and vfork() differ?
13)What type of scheduling is used in Unix?
14)Explain the unix file system?
15)What is make used for? How is it different from a shell script?
16)How would you replace the n character in a file with some xyz?
17)What are the steps for locking a file?
18)What is a zombie?
19)What are the differences between Shared and Dynamic libraries?
20)Give examples of how memory leaks can occur with c programs?
21)How to compare floating point number in shell scripting ?
22)How do u open a read only file in Unix?
23)How would you create shared and dynamic libraries?
24)Write a shell script to identify the given string is palindrome or not?
25)What is the use of `du, utility?
26)You want to migrate a 32 bit application to a 64 bit os, what all would you check?
27)What is inter-process communication facility?
28)What is a file server?
29)Explain difference between IPC mechanisms?
30)How would you remove a semaphore / shared memory whose owner processes have died?
1)What is the difference between a shell variable that is exported and the one that is not e...
2)What are the possible return status of kill() command?
3)What are the benefits of creating links to a file?
4)What is wildcard?
5)Write a script to convert all dos style backslashes to unix style slashes in a list of fil...
6)How do you read arguments in a shell program - $1, $2 ?
7)What are the steps to take files from unix server to windows?
8)What is the method of setting an environment variable from a program?
9)How do you debug a core dump?
10)How to delete a word from a file using shell scripting???
11)What is the concept of named pipe?
12)How does fork() and vfork() differ?
13)What type of scheduling is used in Unix?
14)Explain the unix file system?
15)What is make used for? How is it different from a shell script?
16)How would you replace the n character in a file with some xyz?
17)What are the steps for locking a file?
18)What is a zombie?
19)What are the differences between Shared and Dynamic libraries?
20)Give examples of how memory leaks can occur with c programs?
21)How to compare floating point number in shell scripting ?
22)How do u open a read only file in Unix?
23)How would you create shared and dynamic libraries?
24)Write a shell script to identify the given string is palindrome or not?
25)What is the use of `du, utility?
26)You want to migrate a 32 bit application to a 64 bit os, what all would you check?
27)What is inter-process communication facility?
28)What is a file server?
29)Explain difference between IPC mechanisms?
30)How would you remove a semaphore / shared memory whose owner processes have died?
Oracle apps Interview Questions Faqs
Oracle apps Interview Questions Faqs
1)What is the value of retcode mandatory parameter in oracle apps procedures?
2)What are cycles of GL, AP, and AR?
3)Explain P2P cycle and the accounts that are effected in their respective modules?
4)What you mean by procure to pay cycles? Can u tell me the Journal entry for procure to pay...
5)Oracle workflow interview questions.?
6)What is the difference between sql and sql plus?
7)What are key flexfields and descriptive flexfields in order management?
8)How to retrieve data using view?
9)Which form of the calendar is used primarily as a personal productivity tool?
10)What is aging payments in (OF) AP Module?
11)How many maximum segments we can create in set of books
12)What limitations are there in UTL_FILE?How to create the file using the UTL_FILE option?
13)What is auto invoice?
14)What are the error comes when customize a report and how can we eliminate that error?
15)How to retrieve data using view?
16)What is the difference between Rapid install and manual cloning?
17)How many KFF,s are there in GL module in Oracle Apps.?
18)What is Conference Room Pilot?
19)What is the size of the oracle database?
20)Functionality Questions on Manufacturing Module ?
21)What are the major differences functionality wise between isupport and support modules.?
22)Give me the details of updating positive pay checks report?
23)What are the error comes when customize a report and how can we eliminate that error?
24)How do I register a Concurrent program in Oracle Apps?
25)Which command is used to execute a store procedure?
26)What is the value of retcode mandatory parameter in oracle apps procedures?
27)What are the modules in service contracts?
28)How many maximum segments we can create in set of books
29)What is difference between Oracle (11i manufacturing & SCM ) 11.5.9 & 11.5.10?
30)What are JTF Objects, Why are they required?
1)What is the value of retcode mandatory parameter in oracle apps procedures?
2)What are cycles of GL, AP, and AR?
3)Explain P2P cycle and the accounts that are effected in their respective modules?
4)What you mean by procure to pay cycles? Can u tell me the Journal entry for procure to pay...
5)Oracle workflow interview questions.?
6)What is the difference between sql and sql plus?
7)What are key flexfields and descriptive flexfields in order management?
8)How to retrieve data using view?
9)Which form of the calendar is used primarily as a personal productivity tool?
10)What is aging payments in (OF) AP Module?
11)How many maximum segments we can create in set of books
12)What limitations are there in UTL_FILE?How to create the file using the UTL_FILE option?
13)What is auto invoice?
14)What are the error comes when customize a report and how can we eliminate that error?
15)How to retrieve data using view?
16)What is the difference between Rapid install and manual cloning?
17)How many KFF,s are there in GL module in Oracle Apps.?
18)What is Conference Room Pilot?
19)What is the size of the oracle database?
20)Functionality Questions on Manufacturing Module ?
21)What are the major differences functionality wise between isupport and support modules.?
22)Give me the details of updating positive pay checks report?
23)What are the error comes when customize a report and how can we eliminate that error?
24)How do I register a Concurrent program in Oracle Apps?
25)Which command is used to execute a store procedure?
26)What is the value of retcode mandatory parameter in oracle apps procedures?
27)What are the modules in service contracts?
28)How many maximum segments we can create in set of books
29)What is difference between Oracle (11i manufacturing & SCM ) 11.5.9 & 11.5.10?
30)What are JTF Objects, Why are they required?
Peoplesoft Interview Questions Faqs
Peoplesoft Interview Questions Faqs
1)How do you retrieve a value from scroll..scroll select?
2)When a user logs in to PS, how will the system know in which region the user comes ?
3)The DB User mentioned in Connect ID should have permission to which Three PeopleSoft Table...
4)Difference between sql statements and metasql statements?
5)What effect would making a change to the EMPLID field in the above project have?
6)What is the use of process profile?
7)What are the think-time functions?
8)What is the logic used by Component Buffer?
9)Difference between chartfield and chart of accounts?
10)Menu path provides path to?
11)What is a state record?
12)What are the Outputs of SQR?
13)What is the difference between a Grid and a scroll?
14)What category of commands can be executed in data mover?
15)What are the limitations of PS query?
16)What are the various ways to run SQR?
17)What is the difference between people soft TECHNICAL,FUNCTIONAL and TECHNO-FUNCTIONAL? Wha...
18)What happens if you don,t specify a Search Record for a Component?
19)What is the minimum number of objects an object group can consist of?
20)In the URL identify Portal and Component name?
21)What is record, row peoplecode?
22)Why cant the SQL and call Section Actions be present simultaneously in a single step?
23)Which of the following technology is used in app messaging?
24)Which Table contains Login User Id & Password in Peoplesoft Database?
25)What is the difference in using SQL directly and calling SQL from Peoplecode in Applicatio...
26)What is ERP and how it is related to SAP?
27)Ps application logic reside where?
28)How many Grids can we insert in a single component or page?
29)Where do peopletools data is cached?
30)What are the important tables in PS-HRMS?
1)How do you retrieve a value from scroll..scroll select?
2)When a user logs in to PS, how will the system know in which region the user comes ?
3)The DB User mentioned in Connect ID should have permission to which Three PeopleSoft Table...
4)Difference between sql statements and metasql statements?
5)What effect would making a change to the EMPLID field in the above project have?
6)What is the use of process profile?
7)What are the think-time functions?
8)What is the logic used by Component Buffer?
9)Difference between chartfield and chart of accounts?
10)Menu path provides path to?
11)What is a state record?
12)What are the Outputs of SQR?
13)What is the difference between a Grid and a scroll?
14)What category of commands can be executed in data mover?
15)What are the limitations of PS query?
16)What are the various ways to run SQR?
17)What is the difference between people soft TECHNICAL,FUNCTIONAL and TECHNO-FUNCTIONAL? Wha...
18)What happens if you don,t specify a Search Record for a Component?
19)What is the minimum number of objects an object group can consist of?
20)In the URL identify Portal and Component name?
21)What is record, row peoplecode?
22)Why cant the SQL and call Section Actions be present simultaneously in a single step?
23)Which of the following technology is used in app messaging?
24)Which Table contains Login User Id & Password in Peoplesoft Database?
25)What is the difference in using SQL directly and calling SQL from Peoplecode in Applicatio...
26)What is ERP and how it is related to SAP?
27)Ps application logic reside where?
28)How many Grids can we insert in a single component or page?
29)Where do peopletools data is cached?
30)What are the important tables in PS-HRMS?
CA Fresher Interview questions for Banks,Faqs accounting
CA Fresher Interview questions for Banks,Faqs
1)What is "back Flash Accounting"?
2)What is difference between traveling and conveyance?
3)How can i prepare MIS report for Finance?
4)What is the GDP growth
5)Why do you want to be an auditor ?
6)What is accounts payable
7)What is star hotel accounts mainteances,
8)Do you kno about compensation theorem
9)What is general ledger
10)What is a variable?
11)What is double entry book keeping?
12)What is insurance?
13)What are the Objectives of Accounting?
1)What is "back Flash Accounting"?
2)What is difference between traveling and conveyance?
3)How can i prepare MIS report for Finance?
4)What is the GDP growth
5)Why do you want to be an auditor ?
6)What is accounts payable
7)What is star hotel accounts mainteances,
8)Do you kno about compensation theorem
9)What is general ledger
10)What is a variable?
11)What is double entry book keeping?
12)What is insurance?
13)What are the Objectives of Accounting?
Accounting interview Questions,faqs
Accounting interview Questions,faqs
1)What is gdp growth ?
2)How to account for letter of credit in the books of accounts of the Company?
3)What is insurance?
4)Who is the father of microbiology
5)What is "back Flash Accounting"?
6)What is double entry book keeping?
7)What is the fundamendala of accoutants
8)What is men by General ledger?
9)What are different types of ledger
10)What is different between account and accounting
11)How to calucated persentage of tdswhat is difference of direct tax & indirect tax explaine...
12)What we mention in the account payable
1)What is gdp growth ?
2)How to account for letter of credit in the books of accounts of the Company?
3)What is insurance?
4)Who is the father of microbiology
5)What is "back Flash Accounting"?
6)What is double entry book keeping?
7)What is the fundamendala of accoutants
8)What is men by General ledger?
9)What are different types of ledger
10)What is different between account and accounting
11)How to calucated persentage of tdswhat is difference of direct tax & indirect tax explaine...
12)What we mention in the account payable
Interview Questions,Faqs for Bank Interview
Interview Questions,Faqs for Bank Interview
There cannot be clear cut strategy for the interviews as it all depends on how the interview board is and what they have in their mind on the day. But having said that, it is always wise to prepare well for your interviews, as smart preparation can always help to get through this final hurdle. Although board can throw any question on you but with a little brainstorming and application we can always find out some of the questions which are very commonly asked in the interviews. Candidates should always prepare structured answers of such questions so that they would not find any difficulty at the time of interview. Also keep in mind that interview is a test of your communication skills so remain confident and speak well during interviews, mock interview can help a lot, so practice a lot among your friends and family members.
Just bear in mind that those 10-15 minutes can change your life so don’t have any kind of apprehensions and just be normal. Always talk positive and don’t ever give impression of negativity (even if you are not a positive person). Communicate as much as you can on relevant topics, a few days before your interview, it will not only boost your confidence but also help you to have command over the language. In banking interviews apart from the common questions and answers which I am providing you as under, question may also be from your background, qualifications, current affairs, banking and financial terms etc. So try to cover all such areas.
Tell me about yourself:
This is one of the most common but very important asked questions in interviews. Therefore you need to have a short statement prepared in your mind. Try to cover a brief about you which may include your background, qualifications, experience (if any), your family and your career objective which may include that why you are looking for entering into this sector. Practice this question among your friends to master over it. Talk about things you have done and jobs you have held that relate to the position you are interviewing for. Start with the item farthest back and work up to the present.
Why do you want to enter banking?
You need to talk about Banking. Your answer can have following bulleted points.
Banking is a fast changing environment and with the advent of new technologies and products scope for learning is much more now.
Retail banking is now very competitive – from telephone banking, retailers and etc Banking is thus now largely sales driven.
You can talk that banking offers a wide range of career opportunities for graduates – not just in branch banking but also in financial services, consultancy and corporate banking.
What significant trends do you see in the future in Banking Industry?
This is your chance to shine. You will be fully familiar with the economic situation and development in the banking industry to tackle such questions. Development which have recently taken in the banking industry, monetary policy, how the industry has evolved in last few years and what is the future alike etc. are the areas which you should prepare.
What do you know about this organization?
This question is one reason to do some research on the organization before the interview. Find out about the performance of the bank in which you are appearing for the interview. What are the strong and weak issues of the bank and how they are performing on financial parameters in the industry? Who are the major competitors and what action bank should take to tackle competition.
Explain how you would be an asset to this organization or why should we select you for this position?
This is another very good question which will give you an opportunity to impress the board. It gives you a chance to highlight your best points as they relate to the position being discussed. Talk about your strong points, qualifications, analytical skills etc. to highlight that how can you be an asset to the bank. Please bear in mind that you have already cleared the hurdle of the written part so don’t ever think that you cannot be an asset. The bank has already tested your analytical abilities and they are now just looking for how you respond to such question.
What is your greatest strength?
Numerous answers are good, just stay positive. A few good examples: Your ability to prioritize, Your problem-solving skills, Your ability to work under pressure, Your ability to focus on projects, Your professional expertise, Your leadership skills, Your positive attitude etc.
Do you think you are overqualified for this position?
Regardless of your qualifications, state that you are very well qualified for the position.
There cannot be clear cut strategy for the interviews as it all depends on how the interview board is and what they have in their mind on the day. But having said that, it is always wise to prepare well for your interviews, as smart preparation can always help to get through this final hurdle. Although board can throw any question on you but with a little brainstorming and application we can always find out some of the questions which are very commonly asked in the interviews. Candidates should always prepare structured answers of such questions so that they would not find any difficulty at the time of interview. Also keep in mind that interview is a test of your communication skills so remain confident and speak well during interviews, mock interview can help a lot, so practice a lot among your friends and family members.
Just bear in mind that those 10-15 minutes can change your life so don’t have any kind of apprehensions and just be normal. Always talk positive and don’t ever give impression of negativity (even if you are not a positive person). Communicate as much as you can on relevant topics, a few days before your interview, it will not only boost your confidence but also help you to have command over the language. In banking interviews apart from the common questions and answers which I am providing you as under, question may also be from your background, qualifications, current affairs, banking and financial terms etc. So try to cover all such areas.
Tell me about yourself:
This is one of the most common but very important asked questions in interviews. Therefore you need to have a short statement prepared in your mind. Try to cover a brief about you which may include your background, qualifications, experience (if any), your family and your career objective which may include that why you are looking for entering into this sector. Practice this question among your friends to master over it. Talk about things you have done and jobs you have held that relate to the position you are interviewing for. Start with the item farthest back and work up to the present.
Why do you want to enter banking?
You need to talk about Banking. Your answer can have following bulleted points.
Banking is a fast changing environment and with the advent of new technologies and products scope for learning is much more now.
Retail banking is now very competitive – from telephone banking, retailers and etc Banking is thus now largely sales driven.
You can talk that banking offers a wide range of career opportunities for graduates – not just in branch banking but also in financial services, consultancy and corporate banking.
What significant trends do you see in the future in Banking Industry?
This is your chance to shine. You will be fully familiar with the economic situation and development in the banking industry to tackle such questions. Development which have recently taken in the banking industry, monetary policy, how the industry has evolved in last few years and what is the future alike etc. are the areas which you should prepare.
What do you know about this organization?
This question is one reason to do some research on the organization before the interview. Find out about the performance of the bank in which you are appearing for the interview. What are the strong and weak issues of the bank and how they are performing on financial parameters in the industry? Who are the major competitors and what action bank should take to tackle competition.
Explain how you would be an asset to this organization or why should we select you for this position?
This is another very good question which will give you an opportunity to impress the board. It gives you a chance to highlight your best points as they relate to the position being discussed. Talk about your strong points, qualifications, analytical skills etc. to highlight that how can you be an asset to the bank. Please bear in mind that you have already cleared the hurdle of the written part so don’t ever think that you cannot be an asset. The bank has already tested your analytical abilities and they are now just looking for how you respond to such question.
What is your greatest strength?
Numerous answers are good, just stay positive. A few good examples: Your ability to prioritize, Your problem-solving skills, Your ability to work under pressure, Your ability to focus on projects, Your professional expertise, Your leadership skills, Your positive attitude etc.
Do you think you are overqualified for this position?
Regardless of your qualifications, state that you are very well qualified for the position.
Bank Probationary officer exam pattern
Bank Probationary officer exam pattern
The selection is being made on the basis of performance in written test and interview, sometimes there is also provision for Group Discussions as a part of selection process.
The pattern of written test is more or less similar in all public sector banks. The written test is taken in two forms which are objective & descriptive:
Objective Tests (Duration 135 minutes)
The candidates shall be required to qualify in each objective test as per the cut-off marks determined by individual banks. For wrong answers there is provision for the negative marking which is normally 1/4th i.e. one marks will be deducted for four wrong answers.
Descriptive Tests (Duration 45 minutes)
It will consist of 4 questions out of which the candidates are required to attempt 3 questions only. The test will be of 60 marks (i.e. 20 marks for each question). The test will be only qualifying and the marks obtained therein shall not be reckoned for preparing the merit list. The candidates shall have the option to answer the descriptive test either in English or Hindi.
Interview
Selected candidates will be called for Personal Interview by the respective Bank.
State Bank Group:
However for State Bank Group the pattern of Probationary Examination is little bit different which is as under:
Selection Process:
Tier I (Preliminary Examination)
Objective Tests (Duration 120 minutes)
Candidates have to appear in objective type examination conducted by the bank which will consist of:
1. Reasoning Ability Test
2. Quantitative Aptitude
3. General Awareness/Computer Knowledge
4. English Language
Tier II (Main Test : Duration 180 minutes)
This will be an Objective and Descriptive type examination
The objective type examination of 2 hours duration will consist of :
Test of Reasoning
1. Data Analysis and Interpretation
2. Marketing Knowledge
3. Test of English Language
4. The Descriptive type examination will be a test of English knowledge that has to be done in 1 hour.
Tier III - Group Discussion & Interview :
Selected candidates from Tier I and II are called for Personal Interview and Group Discussion conducted by the respective Bank.
Remark: This is the broad pattern of Bank PO Exams, however now-a-days each bank is coming up with slight difference in the pattern of exam, so keep an eye on that. We will inform you the exact pattern for coming exams on an ongoing basis.
The selection is being made on the basis of performance in written test and interview, sometimes there is also provision for Group Discussions as a part of selection process.
The pattern of written test is more or less similar in all public sector banks. The written test is taken in two forms which are objective & descriptive:
Objective Tests (Duration 135 minutes)
Descriptive Tests (Duration 45 minutes)
It will consist of 4 questions out of which the candidates are required to attempt 3 questions only. The test will be of 60 marks (i.e. 20 marks for each question). The test will be only qualifying and the marks obtained therein shall not be reckoned for preparing the merit list. The candidates shall have the option to answer the descriptive test either in English or Hindi.
Interview
Selected candidates will be called for Personal Interview by the respective Bank.
State Bank Group:
However for State Bank Group the pattern of Probationary Examination is little bit different which is as under:
Selection Process:
Tier I (Preliminary Examination)
Objective Tests (Duration 120 minutes)
Candidates have to appear in objective type examination conducted by the bank which will consist of:
1. Reasoning Ability Test
2. Quantitative Aptitude
3. General Awareness/Computer Knowledge
4. English Language
Tier II (Main Test : Duration 180 minutes)
This will be an Objective and Descriptive type examination
The objective type examination of 2 hours duration will consist of :
Test of Reasoning
1. Data Analysis and Interpretation
2. Marketing Knowledge
3. Test of English Language
4. The Descriptive type examination will be a test of English knowledge that has to be done in 1 hour.
Tier III - Group Discussion & Interview :
Selected candidates from Tier I and II are called for Personal Interview and Group Discussion conducted by the respective Bank.
Remark: This is the broad pattern of Bank PO Exams, however now-a-days each bank is coming up with slight difference in the pattern of exam, so keep an eye on that. We will inform you the exact pattern for coming exams on an ongoing basis.
Bank Clercial Exam Pattern
Bank Clercial Exam Pattern
The selection will be on the basis of written test and interview. All eligible candidates will be called for a written examination, which will be both Objective and Descriptive in nature.
Written Test
Objective Tests (Duration – 95 minutes)
Descriptive Tests (Duration 45 minutes)
It will consist of 4 questions out of which the candidates are required to attempt 3 questions only. The test will be of 60 marks (i.e. 20 marks for each question). Time duration for the test will be 45 minutes. However, the test will be only qualifying and the marks obtained therein shall not be reckoned for preparing the merit list. The candidates shall have the option to answer the descriptive test either in English or Hindi or the Official Language of the State.
The candidates have to pass in each of the objective and descriptive test separately and there will be negative marks for wrong answers in the Objective Tests. Depending on the numbers of vacancies, only those candidates who rank sufficiently high in the Objective Test will be called for interview. Final selection will be on the basis of ranking accorded after adding the marks obtained in the Objective Tests and Interview.
State Bank Group:
However for State Bank Group the pattern of Clerical Examination is little bit different which is as under:
In general, Bank Clerk Examination consists of four subjects, namely, Test of Reasoning, Numerical Ability, Test of English Language and Clerical Aptitude. But in the scheme of examination prescribed by the State Bank of India there will be six Tests – General Awareness, Reasoning Ability , Quantitative Aptitude, General English and Computer /Marketing , General English is a compulsory subject
It is to be it noted that Clerical Aptitude a Compulsory subject of Bank Clerk Exams has been omitted by the State Bank of India.
The selection will be on the basis of written test and interview. All eligible candidates will be called for a written examination, which will be both Objective and Descriptive in nature.
Written Test
Objective Tests (Duration – 95 minutes)
Descriptive Tests (Duration 45 minutes)
It will consist of 4 questions out of which the candidates are required to attempt 3 questions only. The test will be of 60 marks (i.e. 20 marks for each question). Time duration for the test will be 45 minutes. However, the test will be only qualifying and the marks obtained therein shall not be reckoned for preparing the merit list. The candidates shall have the option to answer the descriptive test either in English or Hindi or the Official Language of the State.
The candidates have to pass in each of the objective and descriptive test separately and there will be negative marks for wrong answers in the Objective Tests. Depending on the numbers of vacancies, only those candidates who rank sufficiently high in the Objective Test will be called for interview. Final selection will be on the basis of ranking accorded after adding the marks obtained in the Objective Tests and Interview.
State Bank Group:
However for State Bank Group the pattern of Clerical Examination is little bit different which is as under:
In general, Bank Clerk Examination consists of four subjects, namely, Test of Reasoning, Numerical Ability, Test of English Language and Clerical Aptitude. But in the scheme of examination prescribed by the State Bank of India there will be six Tests – General Awareness, Reasoning Ability , Quantitative Aptitude, General English and Computer /Marketing , General English is a compulsory subject
It is to be it noted that Clerical Aptitude a Compulsory subject of Bank Clerk Exams has been omitted by the State Bank of India.
Android Tutorials : Simple Lists Activity
Android Tutorials : Lists Activity
In most mobile applications, you’re going to be presenting your users a list of something. Most of the time, it’s not as simple as an array of strings; your data may be stored away in a local Sqlite database, or perhaps behind a RESTful API. In any case, we’ll be taking a look at what it takes to begin with a simple ListActivity that can be easily updated later on.
Create a new Android Project (1.1+) and name the activity MyListActivity (or whatever you prefer.) Run the app to ensure you’re working off a valid clean slate.
Next, modify your activity (MyListActivity) to extend the Android class ListActivity and adjust your code to look like the following:
package com.learnandroid.listviewtutorial.simple;
import android.app.ListActivity;
import android.os.Bundle;
import android.widget.ListAdapter;
public class MainListView extends ListActivity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
ListAdapter adapter = createAdapter();
setListAdapter(adapter);
}
/**
* Creates and returns a list adapter for the current list activity
* @return
*/
protected ListAdapter createAdapter()
{
return null;
}
}
So far, so good. We have a method to create our list adapter, so essentially, our onCreate() method is done. Let’s move on to adapters.
Adapters basically glue a collection of objects to an activity, usually by providing a mapping or instructions on how to render each object in the list for the activity. In our case, we have a simple list of strings, so our adapter is pretty straightforward (and in fact, is already provided by Android: ArrayAdapter)
Modify your createAdapter() method to look like the following:
/**
* Creates and returns a list adapter for the current list activity
* @return
*/
protected ListAdapter createAdapter()
{
// Create some mock data
String[] testValues = new String[] {
"Test1",
"Test2",
"Test3"
};
// Create a simple array adapter (of type string) with the test values
ListAdapter adapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, testValues);
return adapter;
}
This encapsulates everything we need to get an adapter up and running. Typically here we may make a call-out to data, which may be a Sqlite query or a RESTful GET request, but for now we’re using simple strings. We create an ArrayAdapter and specify three things: Context, Layout, and Data.
The Context is simply where the list came from. In our app it’s simple, but sometimes it can get a little complex when you’re passing intents back and forth across activities, so this is used to keep a reference to the owner activity at all times.
The Layout is where the data will be rendered (and how it will look.) We’re using a built-in Android layout for our needs (simple_list_item_1).
The Data is what will be rendered, and is a simple list of strings.
Final result should look like the following:
package com.learnandroid.listviewtutorial.simple;
import android.app.ListActivity;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.ListAdapter;
public class MainListView extends ListActivity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
ListAdapter adapter = createAdapter();
setListAdapter(adapter);
}
/**
* Creates and returns a list adapter for the current list activity
* @return
*/
protected ListAdapter createAdapter()
{
// Create some mock data
String[] testValues = new String[] {
"Test1",
"Test2",
"Test3"
};
// Create a simple array adapter (of type string) with the test value.
ListAdapter adapter = new ArrayAdapter(this, android.R.layout.simple_list_item_1, testValues);
return adapter;
}
}
Run the app, and you should see something like this:
And there you have a nice introduction to a ListActivity that can be expanded upon by focusing on the createAdapter() method. In Part 2, we’ll explore using more complex Object lists and custom Adapters, as well as a brief introduction to the layout files. Thanks for reading!
In most mobile applications, you’re going to be presenting your users a list of something. Most of the time, it’s not as simple as an array of strings; your data may be stored away in a local Sqlite database, or perhaps behind a RESTful API. In any case, we’ll be taking a look at what it takes to begin with a simple ListActivity that can be easily updated later on.
Create a new Android Project (1.1+) and name the activity MyListActivity (or whatever you prefer.) Run the app to ensure you’re working off a valid clean slate.
Next, modify your activity (MyListActivity) to extend the Android class ListActivity and adjust your code to look like the following:
package com.learnandroid.listviewtutorial.simple;
import android.app.ListActivity;
import android.os.Bundle;
import android.widget.ListAdapter;
public class MainListView extends ListActivity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
ListAdapter adapter = createAdapter();
setListAdapter(adapter);
}
/**
* Creates and returns a list adapter for the current list activity
* @return
*/
protected ListAdapter createAdapter()
{
return null;
}
}
So far, so good. We have a method to create our list adapter, so essentially, our onCreate() method is done. Let’s move on to adapters.
Adapters basically glue a collection of objects to an activity, usually by providing a mapping or instructions on how to render each object in the list for the activity. In our case, we have a simple list of strings, so our adapter is pretty straightforward (and in fact, is already provided by Android: ArrayAdapter)
Modify your createAdapter() method to look like the following:
/**
* Creates and returns a list adapter for the current list activity
* @return
*/
protected ListAdapter createAdapter()
{
// Create some mock data
String[] testValues = new String[] {
"Test1",
"Test2",
"Test3"
};
// Create a simple array adapter (of type string) with the test values
ListAdapter adapter = new ArrayAdapter
return adapter;
}
This encapsulates everything we need to get an adapter up and running. Typically here we may make a call-out to data, which may be a Sqlite query or a RESTful GET request, but for now we’re using simple strings. We create an ArrayAdapter and specify three things: Context, Layout, and Data.
The Context is simply where the list came from. In our app it’s simple, but sometimes it can get a little complex when you’re passing intents back and forth across activities, so this is used to keep a reference to the owner activity at all times.
The Layout is where the data will be rendered (and how it will look.) We’re using a built-in Android layout for our needs (simple_list_item_1).
The Data is what will be rendered, and is a simple list of strings.
Final result should look like the following:
package com.learnandroid.listviewtutorial.simple;
import android.app.ListActivity;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.ListAdapter;
public class MainListView extends ListActivity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
ListAdapter adapter = createAdapter();
setListAdapter(adapter);
}
/**
* Creates and returns a list adapter for the current list activity
* @return
*/
protected ListAdapter createAdapter()
{
// Create some mock data
String[] testValues = new String[] {
"Test1",
"Test2",
"Test3"
};
// Create a simple array adapter (of type string) with the test value.
ListAdapter adapter = new ArrayAdapter
return adapter;
}
}
Run the app, and you should see something like this:
A screen shot of an example list of strings
And there you have a nice introduction to a ListActivity that can be expanded upon by focusing on the createAdapter() method. In Part 2, we’ll explore using more complex Object lists and custom Adapters, as well as a brief introduction to the layout files. Thanks for reading!
Visual studio 2010 Testing Projects available
Visual studio 2010 Testing Projects available
Microsoft Visual Studio 2010 Ultimate Beta 2 is ready for testers also. There is Few basic Test projects are available for testers and developers.
1. Basic Unit Test: Unit test supports C++, C#, VB. By using unit test you can create a unit test project which can call methods, pass parameters and verify return values.
2. Coded UI Test: CodedUITest is very good feature of VS2010. Coded UI Test allows you to record screen actions to perform UI Testing.
3. Database Unit Test: This test is used to test database object, You can test database functions, procedures, triggers etc.
4. Generic Test: A generic test is existing program that has been wrapped to function as a test in VS.
5. Load Test: Load test will help you to test application with virtual multiuser platforms.
6. Ordered Test: Use to test particular cases in certain order.
7. Unit Test: I is advance version of Basic unit test and perform same kind of functions.
8. Unit Test Wizard: Its same as Unit test while you can generate the unit test from your source code and customize them as per requirement.
9. Web Performance Test: You can test website performance by using performance test inside the load test.
1. Basic Unit Test: Unit test supports C++, C#, VB. By using unit test you can create a unit test project which can call methods, pass parameters and verify return values.
2. Coded UI Test: CodedUITest is very good feature of VS2010. Coded UI Test allows you to record screen actions to perform UI Testing.
3. Database Unit Test: This test is used to test database object, You can test database functions, procedures, triggers etc.
4. Generic Test: A generic test is existing program that has been wrapped to function as a test in VS.
5. Load Test: Load test will help you to test application with virtual multiuser platforms.
6. Ordered Test: Use to test particular cases in certain order.
7. Unit Test: I is advance version of Basic unit test and perform same kind of functions.
8. Unit Test Wizard: Its same as Unit test while you can generate the unit test from your source code and customize them as per requirement.
9. Web Performance Test: You can test website performance by using performance test inside the load test.
QTP Interview questions and answers
QTP Interview questions and answers
Q. Tell me the features and importance of Quick test professional(QTP)?
1. Key word driven testing
2. Suitable to web applications
3. Vb script as the script language
4. Better error handling mechanism
5. Excellent data driven testing features
6. Record and playback
7. to store a values we can use runtime data table
8. Auto documentation
Q. Can a QTP user can increase or decrease active screen information with the test?
Yes, user can store.
Q. What are the limitations of QTP?
The limitations listed below are specifically for QTP 8.2:
Maximum length of name—255
Maximum length of format string—255
Maximum number of tables (workbooks)—Limited by system resources (windows and memory)
Column width—0 to 255 characters
Text length—16,383 characters
Formula length—1024 characters
Number precision—15 digits
Largest positive number—9.99999999999999E307
Largest negative number— -9.99999999999999E307
Smallest positive number—1E-307
Smallest negative number— -1E-307
Maximum number of names per workbook—Limited by available memory
Maximum worksheet size—65,536 rows by 256 columns
Q.What are the QTP Script Coding Standards?
At the start In Header section of QTP you have to declare these items
***Header Section of the QTP you have to Mention*****
1.Name of the Script
2.Name of the Test case
3.Name of the Reusable scripts
4.Path of the Excel sheet
5.Version
6.Name of the Tester
7.Change History
*******************************
Then you have to follow Naming convention for each of the script that you will create in QTP.Like Y_TRA_AGIALANT_FINANCE_01
*******************************
You have to follow coding standards for the variable that you will declare in the QTP script
Like For all the
Integer type variable the name should start with int
Character type variable the name should start with Char
Boolean type variable the name should start with Boo
String Type variable the name should start with Str
*****************************************************
Then throughout the QTP script you have to mention that what you are doing actually. Like
**Here you have to mention in the script what you are doing ** Like
**Clicking the yahoo signin button to Login **********
Browser(Yahoo page).Page(Yahoo_1).Button(Sign_in).Click
*************************************************
Coding standard are used for readability and better understanding.
Q. Tell me the features and importance of Quick test professional(QTP)?
1. Key word driven testing
2. Suitable to web applications
3. Vb script as the script language
4. Better error handling mechanism
5. Excellent data driven testing features
6. Record and playback
7. to store a values we can use runtime data table
8. Auto documentation
Q. Can a QTP user can increase or decrease active screen information with the test?
Yes, user can store.
Q. What are the limitations of QTP?
The limitations listed below are specifically for QTP 8.2:
Maximum length of name—255
Maximum length of format string—255
Maximum number of tables (workbooks)—Limited by system resources (windows and memory)
Column width—0 to 255 characters
Text length—16,383 characters
Formula length—1024 characters
Number precision—15 digits
Largest positive number—9.99999999999999E307
Largest negative number— -9.99999999999999E307
Smallest positive number—1E-307
Smallest negative number— -1E-307
Maximum number of names per workbook—Limited by available memory
Maximum worksheet size—65,536 rows by 256 columns
Q.What are the QTP Script Coding Standards?
At the start In Header section of QTP you have to declare these items
***Header Section of the QTP you have to Mention*****
1.Name of the Script
2.Name of the Test case
3.Name of the Reusable scripts
4.Path of the Excel sheet
5.Version
6.Name of the Tester
7.Change History
*******************************
Then you have to follow Naming convention for each of the script that you will create in QTP.Like Y_TRA_AGIALANT_FINANCE_01
*******************************
You have to follow coding standards for the variable that you will declare in the QTP script
Like For all the
Integer type variable the name should start with int
Character type variable the name should start with Char
Boolean type variable the name should start with Boo
String Type variable the name should start with Str
*****************************************************
Then throughout the QTP script you have to mention that what you are doing actually. Like
**Here you have to mention in the script what you are doing ** Like
**Clicking the yahoo signin button to Login **********
Browser(Yahoo page).Page(Yahoo_1).Button(Sign_in).Click
*************************************************
Coding standard are used for readability and better understanding.
Database testing Interview Question and answers
Database testing Interview Question and answers
1. What do you mean by Normalization and What is the use of normalized database?
Answer: Read definition of first normal form, second normal form, third normal form, fourth normal form, fifth normal form,
2. Give me the complete syntax of Select command?
Answer:
SELECT [ DISTINCT ALL ]
column_expression1, column_expression2, ....
[ FROM from_clause ]
[ WHERE where_expression ]
[ GROUP BY expression1, expression2, .... ]
[ HAVING having_expression ]
[ ORDER BY order_column_expr1, order_column_expr2, .... ]
column_expression ::= expression [ AS ] [ column_alias ]
from_clause ::= select_table1, select_table2, ...
from_clause ::= select_table1 LEFT [OUTER] JOIN select_table2 ON expr ...
from_clause ::= select_table1 RIGHT [OUTER] JOIN select_table2 ON expr ...
from_clause ::= select_table1 [INNER] JOIN select_table2 ...
select_table ::= table_name [ AS ] [ table_alias ]
select_table ::= ( sub_select_statement ) [ AS ] [ table_alias ]
order_column_expr ::= expression [ ASC
DESC ]
3. What is the basic difference between where and having clause?
Answer: having is used with aggregate functions.
4. What are the outputs of the following operations: NULL*5 and NULL+5?
5. Can you give me the command to create a new table on the basis of an existing table?
Answer: CREATE TABLE table [ ( column [, ...] ) ] AS select
6. You have employee table with a ‘joining date’ field. Can you give me a query which shows all the records which are sorted according to day wise; means all ‘Sunday’ records comes first then ‘Monday’ records and so on?
7. What is the difference between ‘Left outer join’, ‘Right outer join’, ‘Full outer join’ and ‘Self Join’? Explain them with example using emp & dept tables.
Answer: Read Definitions
8. Give a query through which top 5 records can fetched on the basis of ‘Sal’ field of EMP table.
Answer: select top 5 * from emp order by emp.sal desc?
9. Fetch the 5th highest sal record from the emp table?
10. Suppose you have a table with 3 columns:
Write a query through which you show the sum of amount of quarters of each year in the separate quarter columns?
11. What do you mean by D/W house?
12. What is difference between OLAP and OLTP?
Answer: OLAP – Online analytical processing
OLTP – Online transaction Processing
13. Explain ETL process?
Answer: ETL - extraction, transformation and loading
14. What do you mean by Star Schema?
15. Can you explain me DTS process in SQL server?
Answer: DTS - Data Transformation Services
16. Can SQL Servers linked to other servers like Oracle?
Answer: SQL Server can be lined to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has a OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.
1. What do you mean by Normalization and What is the use of normalized database?
Answer: Read definition of first normal form, second normal form, third normal form, fourth normal form, fifth normal form,
2. Give me the complete syntax of Select command?
Answer:
SELECT [ DISTINCT ALL ]
column_expression1, column_expression2, ....
[ FROM from_clause ]
[ WHERE where_expression ]
[ GROUP BY expression1, expression2, .... ]
[ HAVING having_expression ]
[ ORDER BY order_column_expr1, order_column_expr2, .... ]
column_expression ::= expression [ AS ] [ column_alias ]
from_clause ::= select_table1, select_table2, ...
from_clause ::= select_table1 LEFT [OUTER] JOIN select_table2 ON expr ...
from_clause ::= select_table1 RIGHT [OUTER] JOIN select_table2 ON expr ...
from_clause ::= select_table1 [INNER] JOIN select_table2 ...
select_table ::= table_name [ AS ] [ table_alias ]
select_table ::= ( sub_select_statement ) [ AS ] [ table_alias ]
order_column_expr ::= expression [ ASC
DESC ]
3. What is the basic difference between where and having clause?
Answer: having is used with aggregate functions.
4. What are the outputs of the following operations: NULL*5 and NULL+5?
5. Can you give me the command to create a new table on the basis of an existing table?
Answer: CREATE TABLE table [ ( column [, ...] ) ] AS select
6. You have employee table with a ‘joining date’ field. Can you give me a query which shows all the records which are sorted according to day wise; means all ‘Sunday’ records comes first then ‘Monday’ records and so on?
7. What is the difference between ‘Left outer join’, ‘Right outer join’, ‘Full outer join’ and ‘Self Join’? Explain them with example using emp & dept tables.
Answer: Read Definitions
8. Give a query through which top 5 records can fetched on the basis of ‘Sal’ field of EMP table.
Answer: select top 5 * from emp order by emp.sal desc?
9. Fetch the 5th highest sal record from the emp table?
10. Suppose you have a table with 3 columns:
Write a query through which you show the sum of amount of quarters of each year in the separate quarter columns?
11. What do you mean by D/W house?
12. What is difference between OLAP and OLTP?
Answer: OLAP – Online analytical processing
OLTP – Online transaction Processing
13. Explain ETL process?
Answer: ETL - extraction, transformation and loading
14. What do you mean by Star Schema?
15. Can you explain me DTS process in SQL server?
Answer: DTS - Data Transformation Services
16. Can SQL Servers linked to other servers like Oracle?
Answer: SQL Server can be lined to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has a OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.
Blackbox testing static and dynamic testing
Blackbox testing static and dynamic testing
Two other terms used to explain how software is tested are static testing and dynamic testing. Static testing refers to testing something that is not running, examining and reviewing it. Dynamic testing is that which you would normally think of as testing moving and using the software.
The best analogy for these terms is the process through which you go when checking out a used car. Kicking the tires, checking the paint, and looking under the bonnet are static testing techniques. Starting it up, listening to the engine and driving down the road are dynamic testing techniques.
Static Black-Box Testing: Testing the Specification
Testing the specification is static black-box testing. The specification is a document, not a running program, so it's considered static. It's also something that was made using data from many sources usability studies, focus groups, marketing input, and so on. You don't necessarily need to know how or why that information was obtained or the details of the process used to obtain it, just that it's been boiled down into a product specification. You can then take that document, perform static black-box testing, and carefully examine it for bugs.
What do you do if your project does not have a specification? May be your team is using the big-bang model or a loose code-and-fix model. As a software tester, this is a challenging position. Your aim is to find errors or bugs early ideally getting them before the software is coded but if your product does not have a spec, this may look impossible to do. Although the spec may not be written down, someone, or many people, knows what they are trying to build. It may be a project manager, the developer, or a marketer. Use them as the walking, talking, and product spec and apply the same techniques for evaluating this "mental" specification as though it was written on paper. You can even take this step further by recording the info you collect and circulating it for review.
Dynamic Black-Box Testing: Testing the Software When Blindfolded
Testing software without having an insight into the details of underlying code is dynamic black-box testing. It's dynamic because the program is executing you are using it as a customer would. And, it's black-box because you are testing it without understanding exactly how it works with blinders on. You are entering inputs, receiving outputs, and checking the results. Another name commonly used for dynamic black-box testing is behavioral testing because you're testing how the software actually behaves when it's used.
Two other terms used to explain how software is tested are static testing and dynamic testing. Static testing refers to testing something that is not running, examining and reviewing it. Dynamic testing is that which you would normally think of as testing moving and using the software.
The best analogy for these terms is the process through which you go when checking out a used car. Kicking the tires, checking the paint, and looking under the bonnet are static testing techniques. Starting it up, listening to the engine and driving down the road are dynamic testing techniques.
Static Black-Box Testing: Testing the Specification
Testing the specification is static black-box testing. The specification is a document, not a running program, so it's considered static. It's also something that was made using data from many sources usability studies, focus groups, marketing input, and so on. You don't necessarily need to know how or why that information was obtained or the details of the process used to obtain it, just that it's been boiled down into a product specification. You can then take that document, perform static black-box testing, and carefully examine it for bugs.
What do you do if your project does not have a specification? May be your team is using the big-bang model or a loose code-and-fix model. As a software tester, this is a challenging position. Your aim is to find errors or bugs early ideally getting them before the software is coded but if your product does not have a spec, this may look impossible to do. Although the spec may not be written down, someone, or many people, knows what they are trying to build. It may be a project manager, the developer, or a marketer. Use them as the walking, talking, and product spec and apply the same techniques for evaluating this "mental" specification as though it was written on paper. You can even take this step further by recording the info you collect and circulating it for review.
Dynamic Black-Box Testing: Testing the Software When Blindfolded
Testing software without having an insight into the details of underlying code is dynamic black-box testing. It's dynamic because the program is executing you are using it as a customer would. And, it's black-box because you are testing it without understanding exactly how it works with blinders on. You are entering inputs, receiving outputs, and checking the results. Another name commonly used for dynamic black-box testing is behavioral testing because you're testing how the software actually behaves when it's used.
What is Mutation testing
What is Mutation testing
A method for determining if a set of test data or test cases is useful, by deliberately introducing various code changes (’bugs’) and retesting with the original test data/cases to determine if the ‘bugs’ are detected. Proper implementation requires large computational resources.
A method for determining if a set of test data or test cases is useful, by deliberately introducing various code changes (’bugs’) and retesting with the original test data/cases to determine if the ‘bugs’ are detected. Proper implementation requires large computational resources.
What is Beta testing
What is Beta testing
Testing when development and testing are essentially completed and final bugs and problems need to be found before final release. Typically done by end-users or others, not by programmers or testers.
Testing when development and testing are essentially completed and final bugs and problems need to be found before final release. Typically done by end-users or others, not by programmers or testers.
What is Alpha testing
What is Alpha testing
Testing of an application when development is nearing completion; minor design changes may still be made as a result of such testing. Typically done by end-users or others, not by programmers or testers.
Testing of an application when development is nearing completion; minor design changes may still be made as a result of such testing. Typically done by end-users or others, not by programmers or testers.
What is Comparison testing
What is Comparison testing
Comparing software weaknesses and strengths to competing products.
Comparing software weaknesses and strengths to competing products.
What is User acceptance testing
What is User acceptance testing
Determining if software is satisfactory to an end-user or customer.
Determining if software is satisfactory to an end-user or customer.
What is Ad-hoc testing
What is Ad-hoc testing
Similar to exploratory testing, but often taken to mean that the testers have significant understanding of the software before testing it.
Similar to exploratory testing, but often taken to mean that the testers have significant understanding of the software before testing it.
What is Exploratory testing
What is Exploratory testing
Often taken to mean a creative, informal software test that is not based on formal test plans or test cases; testers may be learning the software as they test it.
Often taken to mean a creative, informal software test that is not based on formal test plans or test cases; testers may be learning the software as they test it.
What is Compatibility testing
What is Compatibility testing
Testing how well software performs in a particular hardware/software/operating system/network/etc. environment.
Testing how well software performs in a particular hardware/software/operating system/network/etc. environment.
What is Security testing
What is Security testing
Testing how well the system protects against unauthorized internal or external access, willful damage, etc; may require sophisticated testing techniques.
Testing how well the system protects against unauthorized internal or external access, willful damage, etc; may require sophisticated testing techniques.
What is Recovery testing
What is Recovery testing
Testing how well a system recovers from crashes, hardware failures, or other catastrophic problems.
Testing how well a system recovers from crashes, hardware failures, or other catastrophic problems.
What is Install/uninstall testing
What is Install/uninstall testing
Testing of full, partial, or upgrade install/uninstall processes.
Testing of full, partial, or upgrade install/uninstall processes.
What is Usability testing
What is Usability testing
Testing for ‘user-friendliness’. Clearly this is subjective, and will depend on the targeted end-user or customer. User interviews, surveys, video recording of user sessions, and other techniques can be used. Programmers and testers are usually not appropriate as usability testers.
Testing for ‘user-friendliness’. Clearly this is subjective, and will depend on the targeted end-user or customer. User interviews, surveys, video recording of user sessions, and other techniques can be used. Programmers and testers are usually not appropriate as usability testers.
What is Performance testing
What is Performance testing
Term often used interchangeably with ’stress’ and ‘load’ testing. Ideally ‘performance’ testing (and any other ‘type’ of testing) is defined in requirements documentation or QA or Test Plans.
Term often used interchangeably with ’stress’ and ‘load’ testing. Ideally ‘performance’ testing (and any other ‘type’ of testing) is defined in requirements documentation or QA or Test Plans.
What is Stress testing
What is Stress testing
Term often used interchangeably with ‘load’ and ‘performance’ testing. Also used to describe such tests as system functional testing while under unusually heavy loads, heavy repetition of certain actions or inputs, input of large numerical values, large complex queries to a database system, etc.
Term often used interchangeably with ‘load’ and ‘performance’ testing. Also used to describe such tests as system functional testing while under unusually heavy loads, heavy repetition of certain actions or inputs, input of large numerical values, large complex queries to a database system, etc.
What is Load testing
What is Load testing
Testing an application under heavy loads, such as testing of a web site under a range of loads to determine at what point the systems response time degrades or fails.
Testing an application under heavy loads, such as testing of a web site under a range of loads to determine at what point the systems response time degrades or fails.
What is Acceptance testing
What is Acceptance testing
Final testing based on specifications of the end-user or customer, or based on use by end-users/customers over some limited period of time.
Final testing based on specifications of the end-user or customer, or based on use by end-users/customers over some limited period of time.
What is Regression testing
What is Regression testing
Re-testing after fixes or modifications of the software or its environment. It can be difficult to determine how much re-testing is needed, especially near the end of the development cycle. Automated testing tools can be especially useful for this type of testing.
Re-testing after fixes or modifications of the software or its environment. It can be difficult to determine how much re-testing is needed, especially near the end of the development cycle. Automated testing tools can be especially useful for this type of testing.
What is Sanity testing
What is Sanity testing
Typically an initial testing effort to determine if a new software version is performing well enough to accept it for a major testing effort. For example, if the new software is crashing systems every 5 minutes, bogging down systems to a crawl, or destroying databases, the software may not be in a ’sane’ enough condition to warrant further testing in its current state.
Typically an initial testing effort to determine if a new software version is performing well enough to accept it for a major testing effort. For example, if the new software is crashing systems every 5 minutes, bogging down systems to a crawl, or destroying databases, the software may not be in a ’sane’ enough condition to warrant further testing in its current state.
What is End-to-end testing
What is End-to-end testing
Similar to system testing; the ‘macro’ end of the test scale; involves testing of a complete application environment in a situation that mimics real-world use, such as interacting with a database, using network communications, or interacting with other hardware, applications, or systems if appropriate.
Similar to system testing; the ‘macro’ end of the test scale; involves testing of a complete application environment in a situation that mimics real-world use, such as interacting with a database, using network communications, or interacting with other hardware, applications, or systems if appropriate.
Finance Interview Questions
Finance Interview Questions
General Questions
Define free cash flow.
Define EVA.
How do you measure Return on Invested Capital?
What is the difference (and advantages/disadvantages) between purchase and pooling accounting methods?
What do you think about the market?/Talk to me about the stock market.
Tell me about some investment books you’ve read lately.
Fixed Income
Graph the price yield relationship of bonds.
What is duration/Macaulry duration/Modified duration? Show me.
What is convexity?
The following are prices of four different bonds: 25, 23, 22, 24. Assuming that you can sell or buy these bonds at no cost, if you know that tomorrow, three of them will go to 0 and one of them, 100, how would you arbitrage? (buy them all)
How would you explain credit spread?
Currency - Foreign Exchange
If the yen/dollar exchange rate is 100yen/$ today and the one year forward rate is 105yen/$, what does this simply?
One plus one half plus one fourth plus one eighth . . . gets closer to a certain number. What is the number and why?
What is the yen/dollar exchange rate today? Where do you think it will be in one year and why?
(After knowing that the interviewee knows the basics of options) If an exporting company wants to pay no more than 110 yen to a dollar and no less than 90 yen to a dollar in 3 months, how would you use option instruments to hedge their position?
Would a price of a call option go up or down when the maturity of the option is longer?
(After knowing that the interviewee took econometrics) What is econometrics? Could you go through the calculation to do regression analysis?
Investment Management
(for fixed income) What does the yield curve look like today and what would be your investment strategy? Valuation questions (look under investment banking)
Tell me about your own portfolio. What is your investment strategy? (answer in technical terms)
If you are given a market or an industry, what would be the steps to evaluate them?
Sales and Trading
What are the qualifications needed to be a good salesman?
How would you make a customer like you even if you don’t like them?
General
What is the Dow Jones today?
What is the Federal Fund rate today?
What is the 30-year T-bond rate today?
Give me a business idea.
General Questions
Define free cash flow.
Define EVA.
How do you measure Return on Invested Capital?
What is the difference (and advantages/disadvantages) between purchase and pooling accounting methods?
What do you think about the market?/Talk to me about the stock market.
Tell me about some investment books you’ve read lately.
Fixed Income
Graph the price yield relationship of bonds.
What is duration/Macaulry duration/Modified duration? Show me.
What is convexity?
The following are prices of four different bonds: 25, 23, 22, 24. Assuming that you can sell or buy these bonds at no cost, if you know that tomorrow, three of them will go to 0 and one of them, 100, how would you arbitrage? (buy them all)
How would you explain credit spread?
Currency - Foreign Exchange
If the yen/dollar exchange rate is 100yen/$ today and the one year forward rate is 105yen/$, what does this simply?
One plus one half plus one fourth plus one eighth . . . gets closer to a certain number. What is the number and why?
What is the yen/dollar exchange rate today? Where do you think it will be in one year and why?
(After knowing that the interviewee knows the basics of options) If an exporting company wants to pay no more than 110 yen to a dollar and no less than 90 yen to a dollar in 3 months, how would you use option instruments to hedge their position?
Would a price of a call option go up or down when the maturity of the option is longer?
(After knowing that the interviewee took econometrics) What is econometrics? Could you go through the calculation to do regression analysis?
Investment Management
(for fixed income) What does the yield curve look like today and what would be your investment strategy? Valuation questions (look under investment banking)
Tell me about your own portfolio. What is your investment strategy? (answer in technical terms)
If you are given a market or an industry, what would be the steps to evaluate them?
Sales and Trading
What are the qualifications needed to be a good salesman?
How would you make a customer like you even if you don’t like them?
General
What is the Dow Jones today?
What is the Federal Fund rate today?
What is the 30-year T-bond rate today?
Give me a business idea.
Tips when going for job Interview
Tips when going for job Interview
* Do not smoke, chew gum, or eat garlic beforehand.
* Wear suitable interview clothes.
* Take copies of your CV with you.
* Arrive on time for your job interview.
* Any applications handed before the interview begins, are to be filled in as accurately as possible, make ure they match the information in your Cv and Cover Letter.
* Always greet the interviewer by his/her last name and try to pronounce it correctly.
* Have a good firm handshake.
* Look alert and interested. Scan the room once and then keep your eyes on the interviewer.
* Wait until you are offered a chair before you sit down.
* Stress your achievements.
* Always conduct yourself professionally and if something beyond your control occurs, show a sense of humor.
* Be enthusiastic and show it in your replies and body language.
* Answer the interview question by more than a simple yes or no but try not to go over the 60 second limit.
* Avoid at all cost complaining about your current or former employer in your job interview.
* Do not answer questions about politics or religion if the job is completely unrelated.
* Do not raise salary discussions on your first interview - this is usually done on the second interview. Make sure you do your wage research before hand.
Your answer to the initial opening statements in the job interview are important, these are called "ice breakers".
Some times the interviewer will ask whether you had difficulty finding the company premises. Your answer should be brief and polite. The interviewer is merely being polite - if you had problems in finding the premises he/she doesn't need to know that.
Use replies such as:
* I'm fine thank you, and you?
* I'm very well, thank you.
* Do not smoke, chew gum, or eat garlic beforehand.
* Wear suitable interview clothes.
* Take copies of your CV with you.
* Arrive on time for your job interview.
* Any applications handed before the interview begins, are to be filled in as accurately as possible, make ure they match the information in your Cv and Cover Letter.
* Always greet the interviewer by his/her last name and try to pronounce it correctly.
* Have a good firm handshake.
* Look alert and interested. Scan the room once and then keep your eyes on the interviewer.
* Wait until you are offered a chair before you sit down.
* Stress your achievements.
* Always conduct yourself professionally and if something beyond your control occurs, show a sense of humor.
* Be enthusiastic and show it in your replies and body language.
* Answer the interview question by more than a simple yes or no but try not to go over the 60 second limit.
* Avoid at all cost complaining about your current or former employer in your job interview.
* Do not answer questions about politics or religion if the job is completely unrelated.
* Do not raise salary discussions on your first interview - this is usually done on the second interview. Make sure you do your wage research before hand.
Your answer to the initial opening statements in the job interview are important, these are called "ice breakers".
Some times the interviewer will ask whether you had difficulty finding the company premises. Your answer should be brief and polite. The interviewer is merely being polite - if you had problems in finding the premises he/she doesn't need to know that.
Use replies such as:
* I'm fine thank you, and you?
* I'm very well, thank you.
Computers General knowledge Questions and answers
Computers General knowledge Questions and answers
Where are files and websites on the internet stored?
Ans:The internet is a collection of a large number of client-server based systems. So all files and other resources on it are stored on secondary storage devices of the respective servers. Servers of websites are termed as web servers. So when you type in a URL of a website in the address bar of your browser, it makes a connection to that web server which in turn fetches the data from the secondary storage device (such as the hard disk) that they must be using and returns it to the respective browser. The same holds true for any other resource (image, MP3 file, zipped file, etc.) that you access on the internet.
2 Who invented the QWERTY keyboard?
Ans: QWERTY keyboard (also known as universal keyboard) is used in modern computers. The name QWERTY comes from the first six letters in the top row. It was invented by C L Sholes in 1872.
3 What is the full form of TFT in computer and mobile screens?
Ans: Thin Film Transistor (TFT) is a type of LCD flat-panel display screen. It’s called so because each pixel is controlled by transistors. TFT technology provides the best resolution of all the flat-panel technologies, but it is also the most expensive. TFT displays are usually designed to run at a specific resolution.
4 What does the term ‘screen slave’ mean?
Ans: Screen slaves refers to people who are abnormally addicted to the computer. For example, screen slaves would communicate via e-mail with people sitting right next to them. The screen slave culture, which is particularly rampant in offices the world over, is adding to the sedentary lifestyle of white collar workers, thereby increasing related disorders such as obesity, heart disease and Repetitive Stress Injury.
5 What is a TFT monitor?
Ans: Thin Film Transistor (TFT) Liquid Crystal Display technology does away with the traditional bulky Cathode Ray Tube (CRT). LCDs use a strong backlight as the light source and control how much of this light is allowed to reach the dots (pixels) by selectively allowing the light to reach each pixel. LCDs achieve this by taking advantage of a key property of ‘twisted’ liquid crystal molecules; their ability to naturally block polarised light but then let it through by degrees when a small electric field is applied. LCD cells are accurately controlled and arranged in a flat matrix of rows and columns.
6 What is a ‘firewall’ in computer terminology?
Ans: In computer security, a firewall is a device that blocks unauthorised access to an organisation’s local area network. A firewall can reside on the administrative computer, the server that acts as the LAN’s gateway to the Internet. The firewall keeps track of every file entering or leaving the local area network in order to detect the source of viruses and other problems that might enter the network.
7 What is a handshake in computers?
Ans: Handshake is the process by which two computers initiate communication. A handshake begins when one sends a message to another indicating that it nature of quantum mechanics and space and time. In String Theory, all forces and particles emerge in an elegant geometrical way, realising Einstein’s dream of building everything from the geometry of space-time.
8 What is utility computing?
Ans: Utility computing is a service provisioning model in which a service provider makes computing resources and infrastructure management available to the customer as needed, and charges them for specific usage rather than a flat rate. Like other types of on-demand computing (such as grid computing), the utility model seeks to maximise the efficient use of resources and/ or minimise associated costs.
9 What is the difference between an inverter and a UPS?
Ans: Practically, both are same. An inverter converts DC power supply into AC supply. A UPS (Uninterupted Power Supply) is an electronic device which uses inverter technology in it. UPS uses AC supply when power is there, converts into DC power and stores it. This DC power is converted back to AC supply and provides stand by power when electricity goes off.
10 What is e-waste?
Ans: All obsolete electronic devices such as computers, servers, printers, monitors, TVs, cellphones, calculators, CDs, floppies, chips, processors, motherboard, PCB etc. end up as e-waste. E-waste contains many hazardous substances like PVC, plastics, heavy metals, Brominated Flame Retardants etc.
Where are files and websites on the internet stored?
Ans:The internet is a collection of a large number of client-server based systems. So all files and other resources on it are stored on secondary storage devices of the respective servers. Servers of websites are termed as web servers. So when you type in a URL of a website in the address bar of your browser, it makes a connection to that web server which in turn fetches the data from the secondary storage device (such as the hard disk) that they must be using and returns it to the respective browser. The same holds true for any other resource (image, MP3 file, zipped file, etc.) that you access on the internet.
2 Who invented the QWERTY keyboard?
Ans: QWERTY keyboard (also known as universal keyboard) is used in modern computers. The name QWERTY comes from the first six letters in the top row. It was invented by C L Sholes in 1872.
3 What is the full form of TFT in computer and mobile screens?
Ans: Thin Film Transistor (TFT) is a type of LCD flat-panel display screen. It’s called so because each pixel is controlled by transistors. TFT technology provides the best resolution of all the flat-panel technologies, but it is also the most expensive. TFT displays are usually designed to run at a specific resolution.
4 What does the term ‘screen slave’ mean?
Ans: Screen slaves refers to people who are abnormally addicted to the computer. For example, screen slaves would communicate via e-mail with people sitting right next to them. The screen slave culture, which is particularly rampant in offices the world over, is adding to the sedentary lifestyle of white collar workers, thereby increasing related disorders such as obesity, heart disease and Repetitive Stress Injury.
5 What is a TFT monitor?
Ans: Thin Film Transistor (TFT) Liquid Crystal Display technology does away with the traditional bulky Cathode Ray Tube (CRT). LCDs use a strong backlight as the light source and control how much of this light is allowed to reach the dots (pixels) by selectively allowing the light to reach each pixel. LCDs achieve this by taking advantage of a key property of ‘twisted’ liquid crystal molecules; their ability to naturally block polarised light but then let it through by degrees when a small electric field is applied. LCD cells are accurately controlled and arranged in a flat matrix of rows and columns.
6 What is a ‘firewall’ in computer terminology?
Ans: In computer security, a firewall is a device that blocks unauthorised access to an organisation’s local area network. A firewall can reside on the administrative computer, the server that acts as the LAN’s gateway to the Internet. The firewall keeps track of every file entering or leaving the local area network in order to detect the source of viruses and other problems that might enter the network.
7 What is a handshake in computers?
Ans: Handshake is the process by which two computers initiate communication. A handshake begins when one sends a message to another indicating that it nature of quantum mechanics and space and time. In String Theory, all forces and particles emerge in an elegant geometrical way, realising Einstein’s dream of building everything from the geometry of space-time.
8 What is utility computing?
Ans: Utility computing is a service provisioning model in which a service provider makes computing resources and infrastructure management available to the customer as needed, and charges them for specific usage rather than a flat rate. Like other types of on-demand computing (such as grid computing), the utility model seeks to maximise the efficient use of resources and/ or minimise associated costs.
9 What is the difference between an inverter and a UPS?
Ans: Practically, both are same. An inverter converts DC power supply into AC supply. A UPS (Uninterupted Power Supply) is an electronic device which uses inverter technology in it. UPS uses AC supply when power is there, converts into DC power and stores it. This DC power is converted back to AC supply and provides stand by power when electricity goes off.
10 What is e-waste?
Ans: All obsolete electronic devices such as computers, servers, printers, monitors, TVs, cellphones, calculators, CDs, floppies, chips, processors, motherboard, PCB etc. end up as e-waste. E-waste contains many hazardous substances like PVC, plastics, heavy metals, Brominated Flame Retardants etc.
What is System testing
What is System testing
Black box type testing that is based on overall requirement specifications; covers all combined parts of a system.
Black box type testing that is based on overall requirement specifications; covers all combined parts of a system.
What is Functional testing
What is Functional testing
Black-box type testing geared to functional requirements of an application; this type of testing should be done by testers. This doesn’t mean that the programmers shouldn’t check that their code works before releasing it (which of course applies to any stage of testing.)
Black-box type testing geared to functional requirements of an application; this type of testing should be done by testers. This doesn’t mean that the programmers shouldn’t check that their code works before releasing it (which of course applies to any stage of testing.)
What is Integration testing
What is Integration testing
Testing of combined parts of an application to determine if they function together correctly. The ‘parts’ can be code modules, individual applications, client and server applications on a network, etc. This type of testing is especially relevant to client/server and distributed systems.
Testing of combined parts of an application to determine if they function together correctly. The ‘parts’ can be code modules, individual applications, client and server applications on a network, etc. This type of testing is especially relevant to client/server and distributed systems.
What is Incremental integration testing
What is Incremental integration testing
Continuous testing of an application as new functionality is added; requires that various aspects of an application’s functionality be independent enough to work separately before all parts of the program are completed, or that test drivers be developed as needed; done by programmers or by testers.
Continuous testing of an application as new functionality is added; requires that various aspects of an application’s functionality be independent enough to work separately before all parts of the program are completed, or that test drivers be developed as needed; done by programmers or by testers.
What is Unit testing
What is Unit testing
The most ‘micro’ scale of testing; to test particular functions or code modules. Typically done by the programmer and not by testers, as it requires detailed knowledge of the internal program design and code. Not always easily done unless the application has a well-designed architecture with tight code; may require developing test driver modules or test harnesses.
The most ‘micro’ scale of testing; to test particular functions or code modules. Typically done by the programmer and not by testers, as it requires detailed knowledge of the internal program design and code. Not always easily done unless the application has a well-designed architecture with tight code; may require developing test driver modules or test harnesses.
What is whitebox testing
What is whitebox testing
Testsbased on knowledge of the internal logic of an application’s code. Tests are based on coverage of code statements, branches, paths, conditions.
Testsbased on knowledge of the internal logic of an application’s code. Tests are based on coverage of code statements, branches, paths, conditions.
What is blackbox testing
What is blackbox testing
Tests not based on any knowledge of internal design or code. Tests are based on requirements and functionality.
Tests not based on any knowledge of internal design or code. Tests are based on requirements and functionality.
Airport Authority Of IndiaSample Paper
Airport Authority Of IndiaSample Paper
Airport Authority of India conducts a written test for recruitment of many posts. The syllabus usually has a technical as wells as a non-technical section. Reasoning is one of the major component of the non-technical exam. Here are some questions that will help you prepare for the AAI Written Test.
1. In a row of children, Manoj is fifteenth from the left end of the row. If he is shifted towards the right end of the row by four places, he becomes eighth from the right end. How many children are there in the row?
(a) 27
(b) 26
(c) 28
(d) 24
2. How many such numerals are there in the number 2576489, which will remain at the same position when arranged in ascending order from left to right?
(a) One
(b) Two
(c) Three
(d) More than three
3. In a class of 40 children, Manmeet’s rank is eighth from the top. Vishal is five ranks below Manmeet. What is Vishal’s rank from the bottom?
(a) 27
(b) 29
(c) 28
(d) 26
4. Three of the following four are alike in a certain way. Find the one that does not belong to this group?
(a) Coriander
(b) Mustard
(c) Cumin
(d) Clove
5. ‘Seed’ is related to ‘Fruit’ in the same way as ‘Fruit’ is related to:
(a) Tree
(b) Branch
(c) Flower
(d) Petal
6. Three of the following four are alike in a certain way. Find the one that does not belong to this group?
(a) Van
(b) Truck
(c) Cargo
(d) Trolley
7. If it is possible to make a three digit number, which is perfect square of a two digit number from the second, the fourth and the eighth digits of 31792056 using each digit only once, what is the two digit number? If the perfect square cannot be formed, your answer is ‘N’ and if more than one such numbers can be formed , your answer is ‘X’
(a) 14
(b) 16
(c) N
(d) X
8. Pointing to a woman, Suresh said, she is the daughter of my grandfather’s only daughter. How is Suresh related to the woman?
(a) Brother
(b) Cousin
(c) Uncle
(d) Cannot be determined
9. ‘Visual’ is related to ‘Light’ in the same way as ‘Audio’ is related to:
(a) Voice
(b) Sound
(c) Drama
(d) Noise
10. ‘Jackal’ is related to ‘Carnivorous’ in the same way as ‘Goat’ is related to
(a) Omnivorous
(b) Carnivorous
(c) Herbivorous
(d) Multivorous
11. In a certain code ‘DESCRIBE’ is written as ‘FCJSDTFE’. How will ‘CONSIDER’ be written in that code?
(a) SPEJTOPD
(b) SEFJTOPD
(c) QFETJOPD
(d) QEFJTOPD
12. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) Shampoo
(b) Talcum Powder
(c) Hair Oil
(d) Cosmetics
13. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) 71
(b) 73
(c) 67
(d) 77
14. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) Leaf
(b) Flower
(c) Branch
(d) Pollen
15. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) Jasmine
(b) Rose
(c) Dahlia
(d) Lotus
16. ‘Radish’ is related to ‘Root’ in the same way as ‘Brinjal’ s related to
(a) Fruit
(b) Stem
(c) Flower
(d) Root
17. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) Physiology
(b) cardiology
(c) Pathology
(d) Radiology
18. ‘Iron’ is related to ‘Metal’ in the same way as ‘Brass’ is related to
(a) Iron
(b) Alloy
(c) Copper
(d) Zinc
19. In a certain code RAID is written as %#ê$, RIPE is written as %ê@©. How is DEAR written in that code?
(a) @©#%
(b) $@#%
(c) @$#%
(d) $©#%
20. If blue is called red, red is called green, green is called black and black is called white, what is the colour of grass?
(a) red
(b) black
(c) white
(d) green
Directions (21-25): In each of the question below are given three statements followed by two conclusions numbered I and II. You have to take the three given statements to be true even if they seem to be at variance with commonly known facts, and then decide whichof the given conclusions logically follows from the given statements disregarding commonly known facts. Give the answer:
(a) if only conclusion I follows.
(b) if only conclusion II follows.
(c) if either conclusion I or II follows.
(d) if neither conclusion I nor II follows.
(e) if both conclusions I and II follow.
21. Statements:
a. Some pins are forks.
b. All forks are keys.
c. No key is lock.
Conclusions:
I. Some forks are pins.
II. No lock is a pin.
22. Statements:
a. Some shirts are trousers.
b. Some trousers are jackets.
c. All jackets are shawls.
Conclusions:
I. Some shawls are shirts.
II. Some jackets are shirts.
23. Statements:
a. Some leaves are plants.
b. Some plants are trees.
c. Some trees are fruits.
Conclusions:
I. Some fruits are trees.
II. Some trees are plants.
24. Statements:
a. Some rats are dogs.
b. Some dogs are horses.
c. Some horses are camels.
Conclusions:
I. Some horses are rats.
II. Some camels are horses.
25. Statements:
a. Some books are dictionaries.
b. Some dictionaries are files.
c. Some files are papers.
Conclusions:
I. Some papers are files.
II. Some files are books.
Answer Key:
1. b, 2. d, 3. c, 4. b, 5. c
6. c, 7. d, 8. b, 9. b, 10. c
11. a, 12. d, 13. d, 14. d, 15. e
16. a, 17. d, 18. b, 19. d, 20. b
21. c, 22. d, 23. e, 24. b, 25. a
Airport Authority of India conducts a written test for recruitment of many posts. The syllabus usually has a technical as wells as a non-technical section. Reasoning is one of the major component of the non-technical exam. Here are some questions that will help you prepare for the AAI Written Test.
1. In a row of children, Manoj is fifteenth from the left end of the row. If he is shifted towards the right end of the row by four places, he becomes eighth from the right end. How many children are there in the row?
(a) 27
(b) 26
(c) 28
(d) 24
2. How many such numerals are there in the number 2576489, which will remain at the same position when arranged in ascending order from left to right?
(a) One
(b) Two
(c) Three
(d) More than three
3. In a class of 40 children, Manmeet’s rank is eighth from the top. Vishal is five ranks below Manmeet. What is Vishal’s rank from the bottom?
(a) 27
(b) 29
(c) 28
(d) 26
4. Three of the following four are alike in a certain way. Find the one that does not belong to this group?
(a) Coriander
(b) Mustard
(c) Cumin
(d) Clove
5. ‘Seed’ is related to ‘Fruit’ in the same way as ‘Fruit’ is related to:
(a) Tree
(b) Branch
(c) Flower
(d) Petal
6. Three of the following four are alike in a certain way. Find the one that does not belong to this group?
(a) Van
(b) Truck
(c) Cargo
(d) Trolley
7. If it is possible to make a three digit number, which is perfect square of a two digit number from the second, the fourth and the eighth digits of 31792056 using each digit only once, what is the two digit number? If the perfect square cannot be formed, your answer is ‘N’ and if more than one such numbers can be formed , your answer is ‘X’
(a) 14
(b) 16
(c) N
(d) X
8. Pointing to a woman, Suresh said, she is the daughter of my grandfather’s only daughter. How is Suresh related to the woman?
(a) Brother
(b) Cousin
(c) Uncle
(d) Cannot be determined
9. ‘Visual’ is related to ‘Light’ in the same way as ‘Audio’ is related to:
(a) Voice
(b) Sound
(c) Drama
(d) Noise
10. ‘Jackal’ is related to ‘Carnivorous’ in the same way as ‘Goat’ is related to
(a) Omnivorous
(b) Carnivorous
(c) Herbivorous
(d) Multivorous
11. In a certain code ‘DESCRIBE’ is written as ‘FCJSDTFE’. How will ‘CONSIDER’ be written in that code?
(a) SPEJTOPD
(b) SEFJTOPD
(c) QFETJOPD
(d) QEFJTOPD
12. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) Shampoo
(b) Talcum Powder
(c) Hair Oil
(d) Cosmetics
13. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) 71
(b) 73
(c) 67
(d) 77
14. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) Leaf
(b) Flower
(c) Branch
(d) Pollen
15. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) Jasmine
(b) Rose
(c) Dahlia
(d) Lotus
16. ‘Radish’ is related to ‘Root’ in the same way as ‘Brinjal’ s related to
(a) Fruit
(b) Stem
(c) Flower
(d) Root
17. Four of the following five are alike in a certain way and so form a group. Which is the one that does not belong to that group?
(a) Physiology
(b) cardiology
(c) Pathology
(d) Radiology
18. ‘Iron’ is related to ‘Metal’ in the same way as ‘Brass’ is related to
(a) Iron
(b) Alloy
(c) Copper
(d) Zinc
19. In a certain code RAID is written as %#ê$, RIPE is written as %ê@©. How is DEAR written in that code?
(a) @©#%
(b) $@#%
(c) @$#%
(d) $©#%
20. If blue is called red, red is called green, green is called black and black is called white, what is the colour of grass?
(a) red
(b) black
(c) white
(d) green
Directions (21-25): In each of the question below are given three statements followed by two conclusions numbered I and II. You have to take the three given statements to be true even if they seem to be at variance with commonly known facts, and then decide whichof the given conclusions logically follows from the given statements disregarding commonly known facts. Give the answer:
(a) if only conclusion I follows.
(b) if only conclusion II follows.
(c) if either conclusion I or II follows.
(d) if neither conclusion I nor II follows.
(e) if both conclusions I and II follow.
21. Statements:
a. Some pins are forks.
b. All forks are keys.
c. No key is lock.
Conclusions:
I. Some forks are pins.
II. No lock is a pin.
22. Statements:
a. Some shirts are trousers.
b. Some trousers are jackets.
c. All jackets are shawls.
Conclusions:
I. Some shawls are shirts.
II. Some jackets are shirts.
23. Statements:
a. Some leaves are plants.
b. Some plants are trees.
c. Some trees are fruits.
Conclusions:
I. Some fruits are trees.
II. Some trees are plants.
24. Statements:
a. Some rats are dogs.
b. Some dogs are horses.
c. Some horses are camels.
Conclusions:
I. Some horses are rats.
II. Some camels are horses.
25. Statements:
a. Some books are dictionaries.
b. Some dictionaries are files.
c. Some files are papers.
Conclusions:
I. Some papers are files.
II. Some files are books.
Answer Key:
1. b, 2. d, 3. c, 4. b, 5. c
6. c, 7. d, 8. b, 9. b, 10. c
11. a, 12. d, 13. d, 14. d, 15. e
16. a, 17. d, 18. b, 19. d, 20. b
21. c, 22. d, 23. e, 24. b, 25. a
Subscribe to:
Posts (Atom)
