(a) Table employee has 4 records and Table Dept has 3records in it. Mr. Garvit wants to display all information stored in both of these related tables. He forgot to specify equi-join condition in the query. How many rows will get displayed on execution of this query. ( 1 ) (b) What is the purpose of DDL command in MySql ? How is it different from DML command. ( 2 ) (c) Write SQL commands for the statement (i) to (iv) and give outputs for SQL queries (v) to (viii) on basis of the table LAB. No ItemName CostPerItem Quantity DateOFPurchase Warranty Operational 1 Computer 60000 9 21/05/2006 2 7 2 Printer 15000 3 21/02/2007 4 2 3 Scanner 18000 1 29/08/2008 3 1 4 Camera 21000 2 13/06/2006 1 2 5 Hub 8000 1 31/10/2009 2 1 6 UPS 4000 5 21/05/2006 1 4 7 Plotter 25000 2 11/01/2010 2 2 (i) Select the item name purchased after 31/01/2007. (1) (ii) To list item name in ascending order of the date of purchase where quantity is more than 3 (1) (iii) To count the number of items whose cost is more than 10000 (1) (iv) To insert a new record in the LAB table . ( Assumed Data) (1) (v) Select MIN ( DISTINCT quantity ) from Labt where CostPerItem
Posted on: Sat, 01 Feb 2014 07:17:25 +0000
Trending Topics
Recently Viewed Topics
© 2015