Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

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
Which of these sentences is/are grammatically correct? A) He gone out to have food almost an hour ago but hasn't returned yet. B) He went out to have food almost an hour ago but hasn't returned yet. C) He went out to have food almost a hour ago but hasn't returned yet.
Which of the following statement (s) is/are true about the following eliminations? (1) Hoffmann product is major product in I (2) Saytzeff product is major product in I (3) Hoffmann product is major product in II (4) Saytzeffproduct is major product in II
Two stores A and B bought the same product from the company at the same price. Store A marked the price of the product 50% above its cost price and offered two successive discounts of 15% and 10% on the marked price of the product, while store B marked the price of the product 60% above its cost price and offered two successive discounts of 15% and 12% on the marked price of the product. If a customer buys the product from store B, he has to pay Rs. 986 more than that at store A. At what price the two stores bought the product from the company?
Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
Which of the following error is returned for a query for all changes when a parameter that is used to define the query interval is not valid?
The bar diagram given below shows the sales (in lakhs) of five different products A, B, C, D and E by a company during 2001 and 2005. Which of the following statement(s) is/are correct? I. The sale of product B in 2001 is 56.67 percent more than that of product C. II. The sale of product A in 2001 is 146.67 percent more than that of product E. III. The ratio of the sales of product C in 2001 to that of product D in 2005 is 1 : 7.
Product A is costlier than product B by Rs. 2. If the price of product A is increased by two times the price of product B. the new price of product A become Rs. 17. What is the price of product B?
Given below are three quantities named A, B and C. Based on the given information, determine the relation among the three quantities. A shopkeeper bought two products X and Y from a company. He bought product X for Rs. 3060 and sold it to the customer earning a profit of 20%, while he sold the product Y to a customer for Rs. 4160, thereby earning a profit of 30%. Quantity A: If the company earned a profit of 20% on the product X, what is the manufacturing cost of product X? Quantity B: If the company earned a profit of Rs. 600 on the product Y, what is the manufacturing cost of product Y? Quantity C: What is the difference between the total price paid by the customers and the total manufacturing cost of the products X and Y?