CBSE Guess > Papers > Important Questions > Class XII > 2013 > Computer Science > Computer Science - by Mr. Sandip Kumar Srivastava

CBSE CLASS XII

Computer Science (C++ and Data Structure)

1. Display a report containing cust_id, cust_name, Item,qty,price and bill amount. Bill
   amount is calculated as the sum  of qty*price
2. Display how many customers have ordered Pizza in the month of March.
3.  Count the number of customer who have ordered item worth more than 1700. Total amount = sum of qty* price
4. Display the name of customer along with their city in alphabetical order of city
5. select Cust_name , City, ord_date  from Client A, Bill b Where A.Cust_id =b.Cust_id;
6. select Cust_name from Client where Cust_id=( Select Cust_id from  Bill where Year(ord_date) =2008)
7. select count(*) from Client group by City;
8. select Distinct (Item) from Bill;

1. Explain Candidate key and Relation?
2. Consider the following tables BOOKS and ISSUED. Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii)

BOOKS ISSUED

1. To list the names from books of Text type.
2. To display the names and price from books in ascending order of their price.
3. To increase the price of all books of EPB publishers by 50.
4. To display the Book Name, Quantity_Issued and Price for all books of EPB publishers.
5. Select max (price) from books;
6. Select count (DISTINCT Publishers) from books where Price >=400;
7. Select Book_Name, Author_Name from books where Publishers = ‘First’;
8. Select min(Price) from books where type = ‘Text’;

Submitted By : Mr. Sandip Kumar Srivastava
Email : [email protected]