The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.

Ranjan purchased 120 tables at a price of Rs. 110 per table. He sold 30 tables at a profit of Rs. 12 per table and 75 tables at a profit of Rs. 14 per table. The remaining tables were sold at a loss of Rs. 7 per table. What is the average profit per table ?

A

Rs. 10.04

B

Rs. 10.875

C

Rs. 12.80

D

Rs. 12.875

Which of the following statements are true?
Statement I Big data refers to no precise quantity, but generally refers to data in the range of Petabytes and Exabyte, i.e. billions to trillions of records, all from various sources. Big data is generated much faster. than traditional data in much larger quantities.
Statement II Big data interests industries because they are able to learn more patterns and curious variances than smaller data sets, with the capability to provide valuable insights into consumer behaviour, weather systems, financial market activity, or other phenomena.
Statement III Various departments and product lines use various applications within most organisations and store data in separate datasets. These separate databases may contain similar data, but data from one data base to another is not always consistent. This is called data silo.

A

Both statements I and II

B

Both statements II and III

C

Both statements I and III

D

All of the above

Five tables T1, T2, T3, T4 and T5 are kept one above the other (Not necessarily in the same order) Number of tables above T4 are same as the number of tables below T5. T3 is just above T1. T5 is at the bottom. There are two tables between T2 and T5. Which of the following is the correct position of T1?

A

T1 is just below T5

B

T2 is two places below T1

C

T1 is just above T5

D

T1 is three places below T2

Amit, Vijaya, Kavya, Deeksha, Ishaan, Farhad, and Jenny are seated at three tables A, B, and C in a restaurant. There are at least two of them at each table and at least one girl at each table. Kavya does not get along with Amit, Diksha and Ishaan, so she does not sit with any of them. Farhad and Vijaya are best friends and sit together. Amit is sitting at table 'A' and Jenny is sitting at table 'C'. Who is sitting with Jenny?

A

Deeksha

B

Kavya

C

Amit

D

Ishaan

City High School must put together a debating team consisting of four debaters.There are candidates of equal ability : X,Y and Z who are all seniors; and A,B,C and D who are all juniors..The school requires that there should be two seniors and two juniors in the team.It is also necessary that all of the debaters be able to work with one another. *Debaters Y and A cannot work together. *Debaters Z and C cannot work together. *Debaters A and B cannot work together. which of the following statements must be false? 1.Debaters Y and C are never selected together. 2.Debaters Z and D are never selected together. 3.Debaters Z and D are never selected together.

A

Only I

B

Only II

C

Only III

D

All of these

Three statements are given followed by four conclusions numbered I, II, III and IV. Assuming that the statements are true even if they seem to be at variance from commonly known facts, decide which of the conclusions logically follows from the statements. Statements: 1. All carpets are beds. 2. Some tables are carpets. 3. All pillows are tables. Conclusions: I. All pillows are beds. II. Some pillows are beds. III. Some beds are tables. IV. All tables are beds.

A

Only conclusion III follows.

B

Conclusions I and II both follow.

C

Conclusions II and III both follow.

D

Only conclusion I follows.

When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?

A

T

B

U

C

V

D

Z

Match the following two sets given below. Set - I consists of terms related to specific deviations and Set - II consists of resultant impairments. Set-I (Terms denoting nature of deviations) Set-II (Resultant Impairments) (a) Cerebral Palsy (i) Problems related to reading words and letter (b) Congenital Cytomegalovirus (ii) Characterised by rapid, involuntary movements of eyes which make it difficult to focus on objects and causes dizziness (c) Dyslexia (iii) Disorder related to movements and posture (d) Nystagmus (iv) Herpes - related viral infection causes hearing loss (v) Disorder related to farsightedness

A

(a) - (iii), (b) - (ii), (c) - (i), (d) - (v)

B

(a) - (ii), (b) - (v), (c) - (i), (d) - (iv)

C

(a) - (iv), (b) - (iii), (c) - (i), (d) - (v)

D

(a) - (iii), (b) - (iv), (c) - (i), (d) - (ii)

Statements : Some tables are TVs. Some TVs are radios.

Conclusions :
I. Some tables are radios.
II. Some radios are tables.
III. All radios are TVs.
IV. All TVs are tables.

A

None follows

B

All follow

C

Only I and III follow

D

Only II and IV follow

E

Only I and IV follow

Statements : Some tables are T.V. Some T.V. are radios.

Conclusions :
I. Some tables are radios.
II. Some radios are tables.
III. All the radios are T.V.
IV. All the T.V. are tables.

A

Only (II) and (IV)

B

Only (I) and (III)

C

Only (IV)

D

Only (I) and (IV)

E

None of the four.

The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.

Related Questions