CBSE Computer Science - Revision Tour(Solved)

CBSE Guess > eBooks > Class XII > CBSE Computer Science Structure Query Language Solved Revision Tour By Mr. Ravi Kiran

COMPUTER SCIENCE STRUCTURED QUERY LANGUAGE

(G) Assuming that there is one more table COACHES in the database as shown below:

TABLE:COACHES

What will be the output of the following query:

SELECT SPORTS PERSON, COACHNAME FROM CLUB,COACHES WHERE COACH_ID=COACH_NO

Ans:

1999:

5.) Given the following Teacher relation: Write SQL commands for questions (b) to (g). TEACHER

(b) To show all information about the teachers of history department.

Ans:select *from teacher where department=’history’;

(c) To list names of female teacher who are in math department.

Ans: select name from teacher where sex=’male’ and department= ’maths’;

d) To list names of all teacher with their date of joining in ascending order.

Ans:Select Name From Teacher order by dateofjoing;

(f) To count the number of teachers with age >23.

Ans: Select count(number of teachers) from ,teacher where age>23;

(g) To insert a new row in the teacher table with the following data: 9, “raja’, 26,“computer”, {13/5/95 }, 2300, “M”.

Ans: Insert into Teacher values(9,”raja”,26, ”computer”, {13/05/95},2300,”M”);

CBSE Computer Science Solved Revision Tour By Mr. Ravi Kiran ( [email protected] )