Analyst Questions


Q:

Difference between Candidate key and Primary key?

Answer

Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key. 


Primary Key – A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key.






        • One needs to be very careful in selecting the Primary Key as an incorrect selection can adversely impact the database architect and future normalization. For a Candidate Key to qualify as a Primary Key, it should be Non-NULL and unique in any domain.




Report Error

View answer Workspace Report Error Discuss

6 3594
Q:

What is Latus Rectum of Parabola?

A) line segment B) vertex
C) focus D) major axis
 
Answer & Explanation Answer: A) line segment

Explanation:

As parabola is a locus of a point, which moves so that its distance from focus and directrix is always equal.

 

The latus rectum of a conic section is the chord (line segment) that passes through the focus, is perpendicular to the major axis and has both endpoints on the curve. The length of the latus rectum is determined differently for each conic.

                                      download1522126663.jpg image

 

The length of a parabola's latus rectum is 4p, where p is the distance from the focus to the vertex.

Report Error

View Answer Report Error Discuss

Filed Under: Analytical Reasoning
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO

14 3593
Q:

Avinash gave a sum of 5400 at the simple rate of interest of 8% to Rajeev for 4 years and Rajeev gave this amount to Chanukya at the rate of 6% for 4 years. Find how much extra amount has to be paid by Rajeev to Avinash after 4 years?

A) Rs. 364 B) Rs. 432
C) Rs. 498 D) Rs. 554
 
Answer & Explanation Answer: B) Rs. 432

Explanation:

Here Avinash gave to Rajeev and Rajeev gave the same to Chanukya

Principal amount and Time is same but the only difference is Rate of interest.

Rajeev took @ 8% and gave it to Chanukya @ 6%

Here the difference in interest rate = 2%

2% of 5400 should be the extra amount paid by Rajeev to Avinash

Required amount = 2 x 5400 x 4100 = 432

 

Hence, Rs. 432 is the extra amount has to be paid by Rajeev to Avinash after 4 years.

Report Error

View Answer Report Error Discuss

Filed Under: Simple Interest
Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , IT Trainer

2 3586
Q:

Slip rings are usually made of

A) Aluminium B) Copper
C) Phosphor Bronze D) Carbon
 
Answer & Explanation Answer: C) Phosphor Bronze

Explanation:

A Slip ring is a ring in a dynamo or electric motor which is attached to and rotates with the shaft, passing an electric current to a circuit via a fixed brush pressing against it.

 

Slip rings are usually made of Phosphor Bronze.

 

Slip ring motors usually have a 'phase-wound' rotor. This type of rotor has a 3-phase, double-layer, distributed winding consisting of coils used in alternators. The rotor core is made up of steel laminations which have slots to accommodate formed 3-single phase windings.

slip_rings_are_usually_made_of1535005379.png image

Report Error

View Answer Report Error Discuss

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

3 3584
Q:

Who Discovered The Nucleus of a Cell?

A) Otto Hahn B) John Dalton
C) Robert Brown D) Marie Curie
 
Answer & Explanation Answer: C) Robert Brown

Explanation:

Robert Brown, Scottish botanist, Discovered The Nucleus of a Cell in 1831, London. When Brown was studying orchids under microscope when he observed an opaque area, which he called the "Areola" or "Nucleus", in the cells of the flower's outer layer.

The nucleus was also described by Franz Bauer in 1804 but in detail Robert Brown made it in 1831.

Report Error

View Answer Report Error Discuss

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

11 3580
Q:

In a class of 80 students and 5 teachers, each student got sweets that are 15% of the total number of students and each teacher got sweets that are 25% of the total number of students. How many sweets were there?

A) 1060 B) 960
C) 1020 D) 920
 
Answer & Explanation Answer: A) 1060

Explanation:

Total number of sweets

= 80 x 15 x 80/100 + 5 x 80 x 25/100

= 960 + 100 = 1060

Report Error

View Answer Report Error Discuss

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

31 3579
Q:

What is the major monosaccharide found in the body?

A) Galactose B) Sucrose
C) Fructose D) Glucose
 
Answer & Explanation Answer: D) Glucose

Explanation:

Glucose is the major monosaccharide found in the body. It is absorbed directly into the bloodstream duringdigestion and a vital carbohydrate as it is a source of energy.

 

Report Error

View Answer Report Error Discuss

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

4 3576
Q:

The New Deal ended in 1938 partly because

A) national concern shifted to overseas aggression B) FDR was defeated in his bid for reelection
C) the Supreme Court ruled most New Deal programs unconstitutional D) FDR was stricken with polio
 
Answer & Explanation Answer: A) national concern shifted to overseas aggression

Explanation:

The New Deal was a series of programs, public work projects, financial reforms and regulations enacted in the United States 1933-36, in response to the Great Depression organized by Franklin Roosevelt in US.

Report Error

View Answer Report Error Discuss

Filed Under: World History
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO

0 3574