Database Administration Questions


Q:

How many balls?

Number of balls in the figure...

balls1523099634.jpg image

Answer

You have to actually count all the balls in the pyramid.
Simple way is to count the balls in each level.


So lower most level lets say 1st level has 4 x 4 balls; i.e. 16 balls
Similarly 2nd level has 3 x 3 balls; i.e. 9 balls.
3rd level has 2 x 2 balls; i.e. 4 balls.
The top most level has just 1 ball.


So the total number of balls is 16+9+4+1 = 30.


 


So the image has 30 Balls in all.

Report Error

View answer Workspace Report Error Discuss

11 8136
Q:

Ajay who is a King, at his eleventh hour, called his three queens and distributed his gold in the following way: He gave 50% of his wealth to his first wife, 50% of the rest to his second wife and again 50% of the rest to his third wife. If their combined share is worth1,30,900 kilograms of gold, find the quantity of gold King Ajay was having initially?

A) 153145 kgs B) 147890 kgs
C) 152400 kgs D) 149600 kgs
 
Answer & Explanation Answer: D) 149600 kgs

Explanation:

Let the total quantity of gold be p kgs.

According to the question,

50% of p + 25% of p + 12.5% of p = 130900

87.5% of p = 130900

p = 130900 x 100/87.5  = 149600 kgs.

 

Therefore, the initial gold quantity that king has = p = 149600 kgs.

Report Error

View Answer Report Error Discuss

7 8126
Q:

What is the gram formula mass of Li2SO4?

A) 101.2487 B) 109.9446
C) 111.2687 D) 106.5871
 
Answer & Explanation Answer: B) 109.9446

Explanation:

The term gram formula mass is synonymous with molecular mass. So, to get this, we must add molar mass of all the elements in this compound.

 

Given compound is Lithium Sulphate - Li2SO4

Elemental calculation ::

Li  -  Lithium   -   6.941    -     2   -   13.88200 %
S  -  Sulfur     -    32.065   -    1   -   32.065 %
O  -  Oxygen   -   15.9994  -    4   -   63.9976 %

Now, total = 12.6264 + 29.1647 + 58.2090 = 109.9446 

 

Hence, the gram formula mass of Li2SO4 = 109.9446.

Report Error

View Answer Report Error Discuss

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

4 8121
Q:

What is the name of the service included with the Windows Server operating system that manages a centralized database containing user account and security information ?

A) Windows Directory B) Active Directory
C) Directory Plus D) None of the above
 
Answer & Explanation Answer: B) Active Directory

Explanation:

Active Directory (AD) is a centralized database that is included with the Windows Server operating system. Active Directory is used to store information about a network, such as user accounts, computers, printers, and security policies.

Report Error

View Answer Report Error Discuss

48 8119
Q:

A, B and C can do a piece of work in 72, 48 and 36 days respectively. For first p/2 days, A & B work together and for next ((p+6))/3days all three worked together. Remaining 125/3% of work is completed by D in 10 days. If C & D worked together for p day then, what portion of work will be remained?

A) 1/5 B) 1/6
C) 1/7 D) 1/8
 
Answer & Explanation Answer: B) 1/6

Explanation:

Total work is given by L.C.M of 72, 48, 36

Total work = 144 units

Efficieny of A = 144/72 = 2 units/day

Efficieny of B = 144/48 = 3 units/day

Efficieny of C = 144/36 = 4 units/day

 

According to the given data,

2 x p/2 + 3 x p/2 + 2 x (p+6)/3 + 3 x (p+6)/3 + 4 x (p+6)/3 = 144 x (100 - 125/3) x 1/100

3p + 4.5p + 2p + 3p + 4p = 84 x 3 - 54

p = 198/16.5

p = 12 days.

 

Now, efficency of D = (144 x 125/3 x 1/100)/10 = 6 unit/day

(C+D) in p days = (4 + 6) x 12 = 120 unit

Remained part of work = (144-120)/144 = 1/6.

Report Error

View Answer Report Error Discuss

7 7944
Q:

Planet : Orbit :: Projectile : ?

A) Path B) Milky way
C) Track D) Trajectory
 
Answer & Explanation Answer: D) Trajectory

Explanation:

The path traced by planet is called Orbit. Similarly, the path traced by projectile is called Trajectory.

 

Hence, Planet : Orbit : : Projectile : Trajectory.

Report Error

View Answer Report Error Discuss

Filed Under: Analogy
Exam Prep: AIEEE , Bank Exams , CAT , GATE , GRE , TOEFL
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

8 7943
Q:

Kilohertz is a unit which measures

A) Electromagnetic radio wave frequencies B) Electric resistance
C) Power used by a current of one ampere D) Voltage
 
Answer & Explanation Answer: A) Electromagnetic radio wave frequencies

Explanation:

The hertz (Hz) is defined as one cycle per second and is a SI unit of frequency. Here kilohertz is also a unit of frequency of waves and is defined as 1000 cycles per second. Radio waves are measured in kilohertz (KHz).

 

Kilohertz_is_a_unit_which_measures1561453991.jpg 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 , Database Administration , IT Trainer

6 7908
Q:

Define "Correlated Subqueries" ?

Answer

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Report Error

View answer Workspace Report Error Discuss

8 7873