Cidl Bed for those celebrities who charges
thywhere in their namm
than 200000.
24. Consider the following structure of TEACHER and STUDENT table:
Table: TEACHER
TeacherID TName
City Subject
Qualification Designation
Informatics Practices with P
Pay
Table: STUDENT
FName Stream
StdID
Name
TeacherID
Write the SQL commands to get the following:
(a) Show the name of students enrolled in Science stream.
(b) Count the number of students in Commerce stream.
(c) Count the number of teachers in each designation.
(d) Display the maximum pay of teacher who is teaching English.
(e) Display the names of students who are taught by "Anand Mathur”.
(f) Display the names and designations of teachers who are teaching a student named "A
(g) Find out the name of the teacher who is getting the highest pay.
(h) Find out the cities of teachers who are teaching Maths.
() Find out the name of teacher who is getting the lowest salary among PGTS.
() Display the list of students who are taught by PGTs only.
4.42
Answers
1 Two students read the same passage yet construct entirely different interpretations of its meaning. Which of the following is true about them?
A. It is not possible and the students need to re-read the passage.
B. It is possible because the teacher has not explained the passage.
C. It is possible because different factors affect learning of individuals in varied ways.
D. It is not possible because learning is not meaning – making.
Q. 2 According to the National Curriculum Framework, 2005, learning is _________________ and _____________ in its character.
A. active; social
B. passive; simple
C. passive; social
D. active; simple
Q. 3 To enable students to think independently and become effective learners, it is important for a teacher to:
A. offer rewards for each success achieved by the students
B. teach students how to monitor their own learning
C. give information in small units or chunks
D. present information in an organised manner to make it easier to recall
Q. 4 If a teacher wants her students to acquire problem-solving skills, the students should be engaged in activities that involve:
A. structured worksheets containing multiple-choice questions
B. recall, memorization and comprehension
C. drill and practice
D. inquiring, reasoning and decision making
Q. 5 Knowing the naive conceptions that students bring to the classroom:
A. pulls down the teacher’s morale since it increases his work
B. does not serve any purpose of the teacher