CBSE solutions for कम्प्यूटर साइंस विद पाइथान [अंग्रेजी] कक्षा १२ chapter 2 - Structure Query Language [Latest edition]

Mr. Rohan has created a table 'student' with rollno., name, class and section. Now he is confused to set the primary key. So identify the primary key column.

Ms. Ravina is using a table 'customer' with custno, name, address and phonenumber. She needs to display name of the customers, whose name start with letter 'S'. She wrote the following command, which did not give the result.

Select * from customer where name="S%";

Help Ms. Ravina to run the query by removing the errors and write the correct query.

Write SQL query to add a column totalprice with data type numeric and size 10, 2 in a table product.

The name column of a table 'student' is given below.

Based on the information, find the output of the following queries:

→ Select name from student where name like "%a";

→ Select name from student where name like "%h%";

A customer table is created with cno,cname, and address columns. Evaluate the following statement whether it is correct or not?

Delete cname from customer;

Shopkeeper needs to change the first name of one of his customers in table 'customer'. Which command should he use for the same?

Sonal needs to display name of teachers, who have "o" as the third character in their name. She wrote the following query.

Select name
From teacher
Where name ="$$o?";

But the query is not producing the result. Identify the problems.

Pooja created a table 'bank' in SQL. Later on, she found that there should have been another column in the table. Which command is used to add column to the table?

Surpreeth wants to add two more records of customer in customer table. Which command is used to implement this?

Deepak wants to remove all rows from the tableBank. But he needs to maintain the structure of the table. Which command is used to implement the same?

While creating table 'customer', Rahul forgot to add column 'price'. Which command is used to add new column in the table. Write the command to implement the same.

Write the syntax of creating table command.

Write the syntax of dropping table command.

What all are the clause possible in select statement.

What is the default value of order by command.

Differentiate between delete and drop table command.

Differentiate between update and alter table command.

Differentiate between order by and group by command.

Define the following:

Union

Define the following: 

Cartesian product

Define the following.

Equi Join

Define the following.

Non equi join.

What is the use of wildcard?

Create the following table items.

Insert the following information:

Table: Item

Write query based upon item table given.

Display all items information.

Write query based upon item table given.

Display item name and price value.

Write query based upon item table given.

Display soap information.

Write query based upon item table given.

Display the item information whose name starts with letter 's'.

Write query based upon item table given.

Display a report with item number, item name and total price. (total price = price * quantity).

Write query based upon item table given.

Display item table information in ascending order based upon item name.

Write query based upon item table given.

Display item name and price in descending order based upon price.

Write query based upon item table given.

Display item name, whose price is in between 50 to 100.

Write query based upon item table given.

Add new column totalprice with number (10, 2).

Write query based upon item table given.

Increase price value by 100.

Write query based upon item table given.

Fill up totalprice = price*quantity

Write query based upon item table given.

Remove powder information.

Write query based upon item table given.

Remove totalprice column.

Write query based upon item table given.

Remove whole item structure.

Write output based upon item table given.

select sum(price) from item;

Write output based upon item table given.

select avg(price) from item;

Write output based upon item table given.

select min(price) from item;

Write output based upon item table given.

select max(price) from item;

Write output based upon item table given.

select count(price) from item;

Write output based upon item table given.

select distinct price from item;

Write output based upon item table given.

select count(distinct price) from item;

Write output based upon item table given.

select iname,price*quantity from item;

In a database there are two tables - 'Brand' and 'Item' as shown below:

BRAND:

ITEM:

Write MYSQL queries for the following:

1. To display Iname, price and corresponding Brand name (Bname) of those items, whose price is between 25000 and 30000 both values inclusive).
2. To display ICode, Price and BName of the item, which has IName as "Television".
3. To increase the Prices of all items by Rs. 10%.

Create the following table.

Students

Insert the following information:

Students

Write query based upon item table given.

Students

Display all students' information.

Write query based upon item table given.

Students

Display Rohan Saini's information.

Write query based upon item table given.

Students

Display number of students in the table.

Write query based upon item table given.

Students

Display number of students in each sex.

Write query based upon item table given.

Students

Display students' information in ascending order using name.

Write query based upon item table given.

Students

Display students' information in descending order using average marks.

Write query based upon item table given.

Students

Display students' name starting with letter "K".

Write query based upon item table given.

Students

Display students' information, whose name ends with "l".

Write query based upon item table given.

Students

Display a report with adno,name,average*5 as total marks from student table.

Write query based upon item table given.

Students

Display students' information, whose average marks are in between 80 to 90.

Write query based upon item table given.

Students

Display students' info., who are getting average marks of more than 80 and scode 333.

Write query based upon item table given.

Students

Display students' name and average marks, whose scode is 222 and 333.

Write query based upon item table given.

Students

Display sum of average marks.

Write query based upon item table given.

Students

Display maximum average marks.

Write query based upon item table given.

Students

Display minimum average marks.

Write query based upon item table given.

Students

Display average value of average marks.

Write query based upon item table given.

Students

Display maximum, minimum and sum of average marks in each scode.

Write query based upon item table given.

Students

Display number of students in each scode.

Create the following table.

Insert the following information.

Streams

Write queries based upon item table given.

Students

Streams

1. To display Adno, Name, Sex and Average from Student's table and Stream name (Sname) and place from Stream table with respect to Scode.
2. Add the following information into the student table.
   999 Deepak Sharma  83   M   2222
3. Display science stream students' information.

Give the output of the following SQL query.

Select sum(Average)
From students
Where sex='M';

Give the output of the following SQL query.

Select distinct (Scode)
From students;

Remove 111 scode information.

Add new column state with varchar(10).

Increment 2 marks for 444 scode info.

Remove column state.

Remove the whole table stream.