Scribd
Upload
6K views

CBSE Class 12 Computers Worksheet - SQL

The document provides a worksheet with questions on SQL and relational database concepts. It includes sample tables ACTIVITY and COACH with questions asking to write SQL commands to retrieve information from the tables in various ways. It also provides another set of sample tables GAMES and PLAYER with similar questions. The questions assess understanding of concepts like cardinality, DML vs DDL, and writing basic SELECT queries to retrieve, filter, aggregate and join data from multiple tables.

Uploaded by

Sameer Sardar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6K views

CBSE Class 12 Computers Worksheet - SQL

The document provides a worksheet with questions on SQL and relational database concepts. It includes sample tables ACTIVITY and COACH with questions asking to write SQL commands to retrieve information from the tables in various ways. It also provides another set of sample tables GAMES and PLAYER with similar questions. The questions assess understanding of concepts like cardinality, DML vs DDL, and writing basic SELECT queries to retrieve, filter, aggregate and join data from multiple tables.

Uploaded by

Sameer Sardar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Downloaded from www.studiestoday.

com
WORKSHEET-SQL

Q1.Define degree and cardinality of a table.


Q2.Differentiate between DML and DDL.
Q3.Consider the following tables ACTIVITY and COACH and answer the questions.
Table:ACTIVITY
Acode Activity Name Stadium Participants Prize Money Schedule Date
Number
1001 Relay Star Annex 16 10000 23-Jan-2004
1002 High Jump Star Annex 10 12000 12-Dec-2003
1003 Shot Put Super Power 12 8000 14-Feb-2004
1005 Long Jump Star Annex 12 9000 01-Jan-2004
1008 Discuss Throw Super Power 10 15000 19-Mar-2004

Table:COACH
PCode Name Acode Write the SQL commands for the following statements:
1 Ahmed Hussain 1001 (1)To display the names of all activities with their Acodes in descending order.
(2)To display the sum of PrizeMoney for the activities played in each of the
2 Rvinder 1008
Stadium separately.
3 Janila 1001 (3)To display the coach’s name and Acodes in ascending order of Acode from
4 Naaz 1003 the table Coach.
(4) To display the contents of the Activity Table whose ScheduleDate earlier
than 01/01/2004 in ascending order of ParticipantsNum.
Give the output of the following SQL queries.
(1)SELECT COUNT(DISTINCT ParticipantNum) FROM ACTIVITY;
(2)SELECT MAX(Schedule Date),MIN(Schedule Date) FROM ACTIVITY;
(3)SELECT Name, ActivityName FROM ACTIVITY A.COACH C WHERE A.ACode=C.Acode AND A.Participants Number=10;
(4)SELECT DISTINCT(PARTICIPANTS NUM) from ACTIVITY;
Q4.Consider the following tables GAMES and CODE and answer the questions.
Table: GAMES
Gcode Game Name Type Number Prize Money Schedule Date
101 Carrom Board Indoor 16 5000 23-Jan-2004
102 Badminton Outdoor 10 12000 12-Dec-2003
103 Table Tennis Indoor 12 8000 14-Feb-2004
105 Chess Indoor 12 9000 01-Jan-2004
108 Lawn Tennis Outdoor 10 25000 19-Mar-2004

Table:PLAYER
PCode Name Gcode Write the SQL commands for the following statements:
1 Nabi Ahmed 101 (1)To display the names of all GAMES with their Gcodes .
(2)To display the the details of those GAMES which are having PrizeMoney
2 Ravi Sahai 108
more than 7000.
3 Jatin 101 (3)To display the content OF THE GAME S table in ascending order of Schedule
4 Naveen 103 Date.
(4) To display the sum of PrizeMoney from each type of Game.
Give the output of the following SQL queries.
(1)SELECT COUNT(DISTINCT Number) FROM GAMES;
(2)SELECT MAX(Schedule Date),MIN(Schedule Date) FROM GAMES;
(3)SELECT Name, GameName FROM GAMES G,PLAYER P WHERE G.Gcode=P.Gcode AND PrizeMoney>10000;
(4)SELECT DISTINCT(Gcode) from PLAYER;
Downloaded from www.studiestoday.com

You might also like