Database Administration Questions

A computer can perform inputting, processing and cotrolling but it can't perform understanding as it is has no brain. It can't earn from its previous experiances.

Microprocessors are used in the computers of fourth generation computers. Personal microcomputers were possible due to the microprocessors.

Microprocessors further revolutionized the development of computers.

The first microprocessor called Intel 4004 was developed by American Intel Corporation in 1971.

An actor performs in a play. A musician performs at a concert.

Choices b, c, and d are incorrect because none is people who perform.

Hence, Play is to actor as concert is to Musician.

What has one eye yet cannot see is An Eye of a Needle.

A needle has an eye through which we thread it but it is not for seeing.

Let the salaries of Maneela and Shanthi one year before be M1, S1 & now be M2, S2 respectively.

Then, from the given data,

M1/S1 = 3/4  .....(1)

M1/M2 = 4/5 .....(2)

S1/S2 = 2/3  .....(3)

and M2 + S2 = 4160  .....(4)

Solving all these eqtns, we get M2 = Rs. 1600.

LCM of (80, 85, 90) can be found by prime factorizing them.

80 → 2 × 2 × 2 × 2 × 5

85 → 17 × 5

90 → 2 × 3 × 3 × 5

L.C.M of (80,85,90) = 2 × 2 x 2 × 2 × 3 × 3 × 5 × 17

= 16 x 9 x 85

= 144 x 85

= 12240

L.C.M of (80,85,90) = 12240.

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.