Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

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 ?
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn;   Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn;   Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn;   Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?
Point out the correct statement. * executes a Hive query and prints results to standard output b) executes a Hive query and prints results to standard output c) executes a Hive query and prints results to standard output d) All of the mentioned
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.
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?
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.
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.
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at _____________
In MyISAM tables, when a table is emptied with the TRUNCATE TABLE, the counter begins at . . . . . . . .
Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;