Analyst Questions


Q:

Which of the following is a comparison operator in SQL?

A) = B) <>
C) ` D) /
 
Answer & Explanation Answer: A) =

Explanation:

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

7 13438
Q:

6 boys and 8 girls can do job in 10 days , 26 boys & 48 women do work in 2 days. Find time taken by 15 boys and 20 girls to do same work ?

A) 2 days B) 3 days
C) 4 days D) 5 days
 
Answer & Explanation Answer: C) 4 days

Explanation:

One day work of 6 boys and 8 girls is given as 6b + 8g = 1/10 -------->(I)

 


One day work of 26 boys and 48 women is given as 26b + 48w = 1/2 -------->(II)

 

Divide both sides by 2 in (I) and then multiply both sides by 5

Now we get, 15b + 20g = 1/4.

Therefore, 15 boys and 20 girls can do the same work in 4 days.

Report Error

View Answer Report Error Discuss

Filed Under: Time and Work
Exam Prep: GATE , CAT , Bank Exams , AIEEE
Job Role: Bank PO , Bank Clerk , Analyst

13 13414
Q:

Main street high school has 10 members on its football team and 14 members on its science club. 5 members at the school belong to both the football and science teams. How many students belong to only science club team or football team?

A) 9 B) 14
C) 24 D) 21
 
Answer & Explanation Answer: A) 9

Explanation:

Given that,

Members in football team = n(f) = 10

Members in science club = n(s) = 14

Members in both football team and science club = n(f ^ s) = 5

 

Then, Members in only football team = n(F) = 10 - 5 = 5

Members in only science team = n(S) = 14 - 5 = 9

football_science_teams1533013879.jpg image

 

Hence, members in only football or science team = n(FUS) = n(F) + n(S) - n(f^s) 

= 9 + 5 - 5

= 9.

 

Hence, many students belong to only science club team or football team = 9.

Report Error

View Answer Report Error Discuss

Filed Under: Logical Venn Diagram
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO

62 13390
Q:

An Excel Workbook is a collection of

A) Charts B) Worksheets
C) Both A & B D) None of the above
 
Answer & Explanation Answer: C) Both A & B

Explanation:

An M.S Excel Workbook is a collection of both Worksheets and Charts.

 

An_Excel_Workbook_is_a_collection_of1558067892.jpg image

Report Error

View Answer Report Error Discuss

29 13324
Q:

Only movable bone in the skull

A) Occipital bone B) Frontal bone
C) Mandible D) Temporal bone
 
Answer & Explanation Answer: C) Mandible

Explanation:

The skul contains the bones like Occipital bone, Frontal bone, Mandible, Temporal bone, Parietal bone. The mandible, or jaw bone, is the only movable bone of the skull, forming the temporomandibular joint with the temporal bone. The lower teeth are rooted into the mandible while the upper teeth are rooted in the two maxillae.

 

Report Error

View Answer Report Error Discuss

Filed Under: Biology
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank PO

50 13321
Q:

Oxygen : Burn :: Carbon dioxide : ?

A) Extinguish B) Explode
C) Isolate D) Foam
 
Answer & Explanation Answer: A) Extinguish

Explanation:

Oxygen helps in burnings while carbon dioxide extinguished fires.

 

Hence, Oxygen : Burn :: Carbon dioxide : Extinguish.

Report Error

View Answer Report Error Discuss

Filed Under: Analogy
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

13 13299
Q:

Natural Rubber is a Polymer of

A) butadiene B) 2methyl-1,3butadiene
C) ethylene D) isoprene
 
Answer & Explanation Answer: D) isoprene

Explanation:

Natural Rubber is a Polymer derived from Isoprene. 

 rubber-bands-503028_6401547100511.jpg image

      • Natural rubber is an addition polymer that is obtained as a milky white fluid known as Latex from a Tropical Rubber Tree.
Report Error

View Answer Report Error Discuss

Filed Under: Chemistry
Exam Prep: GATE , CAT , Bank Exams , AIEEE
Job Role: Database Administration , Bank PO , Bank Clerk , Analyst

37 13245
Q:

Choose Odd one out of the options ?

A) PSRQ B) SVUT
C) MNPO D) KNML
 
Answer & Explanation Answer: C) MNPO

Explanation:

PSRQ --> {16, 19, 18, 17} - next 3 alphabets of "P" is written in reverse order
SVUT --> {19, 22, 21, 20} - next 3 alphabets of "S" is written in reverse order

MNPO --> {13, 14, 16, 15}


KNML --> {11, 14, 13, 12} - next 3 alphabets of "K" is written in reverse order

Except "MNPO", others are not in consecutive order.

Report Error

View Answer Report Error Discuss

Filed Under: Logical Sequence of Words
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO

51 13232