Bissoy.com
Doctors Medicines MCQs Q&A

A UNION query is which of the following?

A UNION query is which of the following? Correct Answer Combines the output from multiple queries and must include the same number of columns

A single UNION can combine only 2 sql query at a time.

Related Questions

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
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?
Consider the following for the dissolution of trade unions under the Trade Union Act, 1926. Which of the following statement(s) is/are correct?
1. When a registered Trade Union is dissolved, notice of the dissolution is signed by nine members and by the Secretary of the Trade Union.
2. The notice of dissolution must be sent within ten days to the Registrar.
3. Where the dissolution of a registered Trade Union has been registered and the rules of the Trade Union donot provide forthe distribution of funds of the Trade Union on dissolution, the registrar shall divide the funds amongst the members in such manner as may be prescribed.
Match List - I with List - II : List - I List - II A. Stamp duties and duties on medical I. Duties levied by the Union Government but collected and appropriated by the State B. Duties on succession to property other than agricultural land II. Taxes levied and collected by the Union but assigned to the States C. Taxes on income other than corporation tax and taxes on agricultural income III. Taxes levied and collected by the Union and distributed between the Union and the States D. Excise duty on items other than medical and toilet preparation IV. Taxes levied and collected by the Union but which may be distributed between the Union and the States Choose the correct answer from the options given below :
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
Any recursive view must be defined as the union of two subqueries: a _______ query that is nonrecursive and a __________ query.
A dispute has arisen regarding admission of membership of a union which is a registered and recognised trade union. Few workers had filed a joint application for membership of that union. The application was not considered because the application was not in accordance with the procedure laid down by the union. Aggrieved by this, the workers filed a complaint before the Registrar of Trade Unionsunder Section 28 (1-A). Which one among the following is competent authority to settle the issue?
Consider the following statements about European Union: (a) It is a Political and Economic Union. (b) It was formally established by the Maastricht Treaty. (c) In 2007 Austria and Sweden became the members of European Union. (d) In 2012 the European Union received the Nobel Peace Prize. Which of the above statements are correct?
Which of the following statements relating to the trade unions under the Trade Unions Act, 1926 are not true?
1. Every registered trade union has to submit a half yearly return to the Registrar of Trade Unions.
2. Any person who has attained the age of eighteen can become an office bearer of the trade union.
3. Retired or retrenched employees of an organisation holding an office in a trade union shall not be construed as an outsider.
4. The number of outsiders working as office bearers in registered trade union functioning other than in an unorganised section shall be limited to eight.
Which of the following statements is/are correct with regard to 'absolute liability' principle laid down in M. C. Mehta v. Union of India. Answer by using the below:
(1) The principle was approved except as to quantum of damages in Charan Lal Sahu v. Union of India
(2) The principle in determining compensation was applied in Union Carbide Corporation v. Union of India
(3) The compensation to be awarded must have some broad correlation not only with magnitude and capacity of the enterprise but also with the harm caused by it was held in Deepak Nitrite v. State of Gujarat
(4) The principle is not followed in India because Parliament could not yet pass Public Liability Insurance Bill, 1991