Software Testing Interview Question for MANHATTAN ASSOCIATES

The very first round here is a written test containing multiple choice questions from following topics:-
1. Manual Testing,
2. Aptitude and Logical Reasoning ,
3. SQL &
4. Java.

1. Two trains are running at 40 km/hr and 20 km/hr respectively in the same direction. Fast train completely passes a man sitting in the slower train in 5 seconds. What is the length of the fast train?
a. 23 m
b. 23.22 m
c. 27.78 m
d. 29 m

2. A certain amount earns simple interest of Rs. 1750 after 7 years. Had the interest been 2% more, how much more interest would it have earned?
a. Rs. 35
b. Rs. 245
c. Rs. 250
d. Cannot be determined
e. None of these

3. A person's present age is two-fifth of the age of his mother. After 8 years, he will be one-half of the age of his mother. How old is the mother at present?
a. 32 yrs
b. 36 yrs
c. 40 yrs
d. 48 yrs

4. Seven men can complete a work in 12 days. They started the work and after 5 days, two men left. In how many days will the work be completed by the remaining men?
a. 5
b. 6
c. 7
d. 8
e. None of these

5. Pipes A and B can fill a tank in 5 and 6 hours respectively. Pipe C can empty it in 12 hours. If all the three pipes are opened together, then the tank will be filled in: -
a. 1.76 hrs
b. 2.73 hrs
c. 3.53 hrs
d. 4.5 hrs

6. A bag contains 4 white, 5 red and 6 blue balls. Three balls are drawn at random from the bag. The probability that all of them are red, is : -
a. 1/22
b. 3/22
c. 2/91
d. 2/77

7. In an examination 38% of students fail in English and 61% pass in Hindi and 23% fail in both. Find the actual failure percentage?
a. 46%
b. 61%
c. 54%
d. 70%

8. The radius of a sphere is 2r, then its volume will be :-
a. (4*pi*r*r*r)/3
b. (4*pi*r*r*r)
c. (8*pi*r*r*r)/3
d. (32*pi*r*r*r)/3

9. In SQL, which command is used to select only one copy of each set of duplicable rows : -
a. SELCT DISTINCT
b. SELECT UNIQUE
c. SELECT DIFFERENT
d. All of above

10. Which SQL keyword is used to sort the result-set?
a. SORT BY
b. ORDER BY
c. ORDER
d. SORT

11. With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
a. SELECT * FROM Persons SORT 'FirstName' DESC
b. SELECT * FROM Persons ORDER BY FirstName DESC
c. SELECT * FROM Persons ORDER FirstName DESC
d. SELECT * FROM Persons SORT BY 'FirstName' DESC

12. What are the after triggers?
a. Triggers generated after a particular operation
b. These triggers run after an insert, update or delete on a table
c. These triggers run after an insert, views, update or delete on a table
d. All of the mentioned.

13. To specify the number of records to return, which keyword is used in Oracle
a. FIRST
b. TOP
c. LIMIT
d. START
e. ROWNUM

14. To combine the result-set of two or more SELECT statements, SQL clause used is
a. UNION
b. JOIN
c. GROUP BY
d. NONE

15. The command that all instructors with salary over $100,000 receive a 3 percent raise, would be written as
a. update instructor
set salary=salary * 1.03
where salary > 100000;
b. update instructor
set salary=salary * 1.03
where salary <>=100000;
c. update in instructor
set salary=salary * 1.03
where salary >=100000;
d. update into instructor
set salary=salary * 1.03
where salary >=100000;

Enjoy Reading.