MySQL, Python random module, and Output questions Sample Exam questions
1 view 0 purchase
Course
Computer Science (CSE)
Institution
Vellore Institute Of Technology
This is a sample question papers with questions from MYSQL , python programming questions, random module questions, and output questions, a complete revision before exam
1. Create table Item using the following specifications :
Column Data Type Size Constraint Description
Name
Item_No INT 8 PRIMARY KEY Item number
Item_name VARCHAR 30 Cannot be blank Name of Item
Category VARCHAR 25 By default should be accessories Type of Item
Stock INT 2 MUST BE BETWEEN 50 TO 60 Quantity available
Price FLOAT 7,2 Price of the item
2. Room_No, Cust_Name, Room_Type and Room_Rent of table “HOTEL” are
given below:
Table : HOTEL
Room_No Cust_Name Room_Type Room_Rent
204 Rajesh Single 700
308 Anuja Double AC 1600
105 Vinamra Single 500
202 Soma
Based on this information, find output of the following queries:
(I) SELECT Room_Type, SUM(Room_Rent) FROM hotel GROUP BY Room_Type;
(II) SELECT Room_no FROM hotel WHERE Cust_Name LIKE ‘%n%;
3)Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to
(vi) on the basis of the table Shop.
No. Shop_name Sale Area Cust_percent Rating City
1 West side 250000 North 68.6 C Delhi
2 Pantaloons 500000 South 81.8 A Chennai
3 Sir’s & Her’s 300000 North 79.8 B Amritsar
4 Sports king 380000 West 88.0 B Baroda
5 Biswas stores 456000 North 92.0 A Delhi
6 Big Bazar 290000 East 66.7 A Kolkota
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Stevendurby. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $5.49. You're not tied to anything after your purchase.
