Job application exam Q & A

[Torpz909]

Post niyo dito mga ka SB yung mga naging exam niyo nung nag apply kayo , kahit ano basta related sa job examination

Post mo lang yung tanong, tapos kung alam mo naman yung sagot sa question quote mo nalang para may reference, at kung meron kang mga payo O Suhestiyon post mo lang dito, malaking tulong yan para sa mga Job Hunters at students

Category:
Programming
FlowChart
Aptitude Test
Vocabulary
Math calculations
Advice
Eto yung kulay ng mga tanong para madaling ma identify ng mga magbabasa, basta lagay mo lang yung kulay sa title basta ma recognize na dun sya kabilang.
Pa comment nalang po yung maaari pang pwedeng mai dagdag.



Eto yung naging exam ko sa isang inapplyan ko,an​

g problema eh paano ko ma rereverse ung value ng column A sa dulo mapupunta sa unahan at ganun din yung sa B, at yung value nung column A ay mapupunta sa Column B.
See attachment nalang mga ka sb.
View attachment 159132

 

[Torpz909]

up ko lang mga ka sb

 

[GameZero]

anu language gagamitin dyan kahit anu lang ?

 

[Torpz909]

Kahit ano Boss.

 

[Torpz909]

Re: Job application exam Q & A

up ko lang mga ka sb

- - - Updated - - -

up ko lang mga ka sB

 

[Torpz909]

Re: Job application exam Q & A

up ko lang ulit mga ka sb

 

[g0ld3nb0y]

Re: Job application exam Q & A

up up lang

 

[knives645]

Re: Job application exam Q & A

Spatial Aptitude
Question:
1.
Jo’s age plus Mo’s age is 27;
and Jo’s age plus Flo’s age is 38;
and Mo’s age plus Flo’s age is 33.
Therefore, how old are Jo, Mo and Flo?

2.
983 : 75
294 : 22
763 : 45
579 : ?
Answer:

 

[Torpz909]

Re: Job application exam Q & A

up natin to mga ka sb ^

- - - Updated - - -

up ko lang mga boss.

 

[Torpz909]

Re: Job application exam Q & A

up ko lang mga ka sb.

 

[silverdust]

Hello mga ka-sb, eto po programming task s inaaplayang q:

You have the following two tables in the database:
Consultants (
ConsultID number,
FullName string,
... - other fields
)
Sales (
SaleID number,
ConsultID number,
SaleDate datetime,
SaleAmount number,
... - other fields
)

Write a single SQL select statement that will list every consultant’s name, their total sales for previous month, total sales for current month, number of sales for current month:

FullName, LastMonthAmount, ThisMonthAmount, ThisMonthCount

any idea? thank you!

 

[GameZero]

Re: Job application exam Q & A

Spatial Aptitude
Question:
1.
Jo’s age plus Mo’s age is 27;
and Jo’s age plus Flo’s age is 38;
and Mo’s age plus Flo’s age is 33.
Therefore, how old are Jo, Mo and Flo?

2.
983 : 75
294 : 22
763 : 45
579 : ?
Answer:

answer for
1. Jo is 16, Mo is 11, Flo is 22
2. 579 = 44

 

[Torpz909]

Re: Job application exam Q & A

answer for
1. Jo is 16, Mo is 11, Flo is 22
2. 579 = 44

Yun oh!

 

[akkitta11]

Re: Job application exam Q & A

answer for
1. Jo is 16, mo is 11, flo is 22
2. 579 = 44

ts kindly explain on how you get it? Up up

 

[sizzlingralph]

Re: Job application exam Q & A

Maraming exam pa mas mahirap jan like gumawa ka ng sarili mong system. whew...

 

[Torpz909]

Maraming exam pa mas mahirap jan like gumawa ka ng sarili mong system. whew...

@sizzlingralph wala naman po tayo dito para alamin kung mahirap at madali ang exam, ginawa po ang Thread na ito para ma-practice at madagdagan ng kaalaman yung mga interesado, sa kung sakali mang sila'y mag apply, may pahapyaw na ideya na sila sa gagawin nila. Baka may mai-ambag ka feel free to post sir

 

[knives645]

Re: Job application exam Q & A

Spatial Aptitude
Question:
1.
Jo’s age plus Mo’s age is 27;
and Jo’s age plus Flo’s age is 38;
and Mo’s age plus Flo’s age is 33.
Therefore, how old are Jo, Mo and Flo?

2.
983 : 75
294 : 22
763 : 45
579 : ?
Answer:

answer for
1. Jo is 16, Mo is 11, Flo is 22
2. 579 = 44

ts kindly explain on how you get it? Up up

1.
16 + 11 = 27,
11 + 22 = 33,
22 + 16 = 38

2.
(9x8) + 3 = 75
.......
(5x7) + 9 = 44


These kind of questions are confusing, meron talagang mabilis ang IQ, ako, I admit, medyo hirap din ako.


Next Question..

Mental Arithmetic:
1. What is 9 multiplied by 8?
Answer:
2. What is 267 divided by 3?
Answer:
3. What is 19 multiplied by 11?
Answer:
4. What is 80% of 160?
Answer:
5. Multiply 12 by 6 and divide by 3
Answer:
6. Divide 42 by 7 and add 13
Answer:
7. What is 60% of 250?
Answer:
8. What is 5/6 of 360?
Answer:
9. Multiply 18 by 12 and subtract 17
Answer:
10. What is 9/8 of 200?
Answer:
11. What is 20% of 135 plus 35?
Answer:
12. Multiply 5 by 8 by 3
Answer:
13. Divide 28 by 7 and add it to 15
multiplied by 5
Answer:
14. What is 595 divided by 7?
Answer:
15. Add 28 + 27 + 39 + 18 + 36
Answer:
16. What is 35% of 150?
Answer:
17. What is 45 multiplied by 19?
Answer:
18. What is 3/8 of 128?
Answer:
19. What is 1257 less 749?
Answer:
20. Divide 126 by 14
Answer:
21. What is 45% of 120?
Answer:
22. Subtract 869 from 2482
Answer:
23. Multiply 72 by 19
Answer:
24. What is 1000 divided by 16?
Answer:
25. Add 3/4 of 216 to 3/5 of 75
Answer:
26. Add 963 to 471
Answer:
27. Multiply 49 by 11
Answer:
28. What is 12/16 expressed as a decimal?
Answer:
29. Deduct 4/7 of 49 from 100
Answer:
30. Divide 2682 by 894
Answer:

 

[GameZero]

Re: Job application exam Q & A

1.
16 + 11 = 27,
11 + 22 = 33,
22 + 16 = 38

2.
(9x8) + 3 = 75
.......
(5x7) + 9 = 44


These kind of questions are confusing, meron talagang mabilis ang IQ, ako, I admit, medyo hirap din ako.


Next Question..

Mental Arithmetic:
1. What is 9 multiplied by 8?
Answer:
2. What is 267 divided by 3?
Answer:
3. What is 19 multiplied by 11?
Answer:
4. What is 80% of 160?
Answer:
5. Multiply 12 by 6 and divide by 3
Answer:
6. Divide 42 by 7 and add 13
Answer:
7. What is 60% of 250?
Answer:
8. What is 5/6 of 360?
Answer:
9. Multiply 18 by 12 and subtract 17
Answer:
10. What is 9/8 of 200?
Answer:
11. What is 20% of 135 plus 35?
Answer:
12. Multiply 5 by 8 by 3
Answer:
13. Divide 28 by 7 and add it to 15
multiplied by 5
Answer:
14. What is 595 divided by 7?
Answer:
15. Add 28 + 27 + 39 + 18 + 36
Answer:
16. What is 35% of 150?
Answer:
17. What is 45 multiplied by 19?
Answer:
18. What is 3/8 of 128?
Answer:
19. What is 1257 less 749?
Answer:
20. Divide 126 by 14
Answer:
21. What is 45% of 120?
Answer:
22. Subtract 869 from 2482
Answer:
23. Multiply 72 by 19
Answer:
24. What is 1000 divided by 16?
Answer:
25. Add 3/4 of 216 to 3/5 of 75
Answer:
26. Add 963 to 471
Answer:
27. Multiply 49 by 11
Answer:
28. What is 12/16 expressed as a decimal?
Answer:
29. Deduct 4/7 of 49 from 100
Answer:
30. Divide 2682 by 894
Answer:

ang dami, haha ...............

 

[akuma]

Write a single SQL select statement that will list every consultant’s name, their total sales for previous month, total sales for current month, number of sales for current month:

FullName, LastMonthAmount, ThisMonthAmount, ThisMonthCount

any idea? thank you!

try pero wala ako sql e

select name as FullName,MONTH(DATE,-1) as LastMonthAmount,MONTH(DATE,0) as ThisMonthAmount,sum(Amount) as TotalSales,count(sales) as ThisMonthCount
from Consultant NATURAL JOIN SALES
GROUP BY LastMonthAmount, ThisMonthAmount, ThisMonthCount,sales

 

[akosiartas]

Hello mga ka-sb, eto po programming task s inaaplayang q:

You have the following two tables in the database:
Consultants (
ConsultID number,
FullName string,
... - other fields
)
Sales (
SaleID number,
ConsultID number,
SaleDate datetime,
SaleAmount number,
... - other fields
)

Write a single SQL select statement that will list every consultant’s name, their total sales for previous month, total sales for current month, number of sales for current month:

FullName, LastMonthAmount, ThisMonthAmount, ThisMonthCount

any idea? thank you!

try mo 'to. natest q rn eto s SQL server:

SELECT LTABLE.FullName, LTABLE.ThisMonthAmount, RTABLE.PreviousMonthAmount, LTABLE.ThisMonthCount FROM
(SELECT Consultants.FullName as FullName, CurrentMonthSales.ThisMonthAmount as ThisMonthAmount, CurrentMonthSales.ThisMonthCount as ThisMonthCount
FROM Consultants
LEFT JOIN
(select sales.ConsultID ,sum(Sales.SaleAmount) as ThisMonthAmount, count(Sales.SaleDate) as ThisMonthCount from Sales where month(sales.SaleDate) = month(GetDate()) AND YEAR(sales.SaleDate) = YEAR(GetDate()) group by Sales.ConsultID) as CurrentMonthSales
ON Consultants.ConsultID = CurrentMonthSales.ConsultID) as LTABLE
INNER JOIN
(SELECT Consultants.FullName as FullName, PreviousMonthSales.PreviousMonthAmount as PreviousMonthAmount
FROM Consultants
LEFT JOIN
(select sales.ConsultID ,sum(Sales.SaleAmount) as PreviousMonthAmount from Sales where month(sales.SaleDate) = month(DateAdd(month, -1 ,GetDate())) AND YEAR(sales.SaleDate) = YEAR(DateAdd(month, -1 ,GetDate())) group by Sales.ConsultID) as PreviousMonthSales
ON Consultants.ConsultID = PreviousMonthSales.ConsultID) as RTABLE
ON LTABLE.Fullname = RTABLE.FullName