MySQL SQL Revision Tour Sumita Arora Solution

MySQL SQL Revision tour sumita arora solution || MySQL SQL Revision tour class 12 sumita arora solution || MySQL SQL Revision tour class 12 sumita arora || MySQL SQL Revision tour sumita arora || sumita arora MySQL SQL Revision tour || sumita arora MySQL SQL Revision tour solution || MySQL SQL Revision tour sumita arora practical solution || sumita arora practical solution || MySQL SQL Revision tour class 12 solution || MySQL SQL Revision tour class 12

 

Q 1 = How are SQL commands classified ?

 

Q 2 = Differentiate between DDL and DML commands.

 

Q 3 =

(a) What is the use of UPDATE statement in SQL ? How is it different from ALTER statement

(b) Mr. Shankar created a table VEHICLE with 3 rows and 4 columns. He added 1 more row to it deleted one column. What is the Cardinality and Degree of the Table VEHICLE ?

(c) Consider the following table named "GYM" with details about fitness items being sold in the store. Write command of SQL for (i) to (iv). 

 

(i) To display the names of all the items whose name starts with "A".

(ii) To display ICODEs and INAMEs of all items, whose Brandname is Reliable or Coscore.

(iii) To change the Brandname to "Fit Trend India" of the item, whose ICODE as "G101".

(iv) Add a new row for new item in GYM with the details :

"G107", "Vibro exerciser", 21000, "GTCFitness"

 

 

 

Q 4 = 

(a) Mr. James created a table CLIENT with 2 rows and 4 columns. He added 2 more rows to it and deleted one column. What is the Cardinality and Degree of the Table CLIENT ?

(b) Consider the following table FITNESS with details about fitness products being sold in the store. Write command of SQL for (i) to (iv). 

 

(i) To display the names of all the products with price more than 20000.

(ii) To display the names of all products by the manufacturer "Aone".

(iii) To change the price data of all the products by applying 25% discount reduction.

(iv)To add a new row for product with the details

 "P7", "Vibro Exerciser", 28000, "Aone".

 

 

 

Q 5 = Write SQL commands for the following on the basis of given table CLUB.

 

(a) To show all information about the swimming coaches in the club.

(b) To list names of all coaches with their date of appointment (DATOFAPP) in descending order.

(c) To display a report, showing coachname, pay, age and bonus (15% of pay) for all the coaches.

 

 

 

Q 6 = Write SQL commands for the following on the basis of given table STUDENT1. 

 

(a) Select all the Nonmedical stream students from STUDENT1.

(b) List the names of those students who are in class 12 sorted by Stipend.

(c) List all students sorted by AvgMark in descending order.

 

 

Q 7 = What is foreign key ? How do you define a foreign key in your table ?

 

 

Q 8 = How is FOREIGN KEY commands different from PRIMARY KEY command ?

 

 

Q 9 = How is FOREIGN KEY commands related to the PRIMARY KEY ?

 

 

Q 10 = What are table constraints ? What are column constraints ? How are these two different .

 

 

Q 11 = Insert all those records of table Accounts into table Pending where amt_outstanding is more than 10000

 

 

Q 12 = Increase salary of employee records by 10% (table employee).

 

 

Q 13 = Add a constraint (NN-Grade) in table Empl (given before assignment) that declares column Grade not null.

 

 

Q 14 =  Drop the table Empl.

 

 

Q 15 = Differentiate between:

(i) DROP TABLE, DROP DATABASE

(ii) DROP TABLE, DROP clause of ALTER TABLE.

 

 

Q 16 = Mr. Mittal is using a table with following columns :

         Name, Class, Stream_ld, Stream_name

He needs to display names of students who have not been assigned any stream or have been assigned stream_name that ends with "computers".

He wrote the following command, which did not give the desired result.

SELECT Name, Class FROM Students

WHERE Stream_name = NULL OR Stream_name = "%computers" ;

Help Mr. Mittal to run the query by removing the error and write correct query.

 

 

Q 17 = The Doc_name Column of a table Hospital is given below : 

 

Doc_name

Avinash

Hariharan

Vinayak

Deepak

Sanjeev

 

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

(i) SELECT doc_name FROM HOSPITAL WHERE Doc_name like "%v";

(ii) SELECT dcc_name FROM HOSPITAL WHERE doc_name like "%e%";

Q 18 =  Sarthak, a student of class XII, created a table "Class". Grade is one of the columns of this table. 10 i the details of students whose Grades have not been entered, he wrote the following MySql query, which did not give the desired result :

SELECT * FROM Class WHERE Grade = "Null";

Help Sarthak to run the query by removing the errors from the query and write the correct query .

 

 

Q 19 =  What is the purpose of DROP TABLE command in MySql ? How is it different from DELETE Command ?

 

 

 MYSQL SQL Revision tour  || Sumita Arora || Class 12 || Computer science || Information practices || Solution ||