kv no. 2 delhi cantt. (i shift 2015-16 autumn break...

KV No. 2 Delhi Cantt. (I SHIFT)

2015-16

AUTUMN BREAK - Holiday’s Homework

Class - XII

Holiday Homework for Class XII Subject – Computer Science

Learn chapter 14 Networking for class test on 29 October, 2015

The following questions should be done in Practical File:

Q:1 Programs:

Q 2: Write the SQL query commands based on following table

Table : Book

Book_id Book name Author_name Publisher Price Type Quantity

C0001 Fast Cook Lata Kapoor EPB 355 Cookery 5

F0001 The Tears William Hopkins First Publi. 650 Fiction 20

T0001 My First c++ Brain & Brooke FPB 350 Text 10


2015-16


Class - XII

T0002 C++ Brain works A.W. Rossaine TDH 350 Text 15

F0002 Thunderbolts Anna Roberts First Publ. 750 Fiction 50

Table : issued

Book_Id Quantity Issued

T0001 4

C0001 5

F0001 2

Write SQL query for (a) to (f)

(a) To show book name, Author name and price of books of First Pub. Publisher (b) To list the names from books of text type (c) To Display the names and price from books in ascending order of their prices. (d) To increase the price of all books of EPB publishers by 50. (e) To display the Book_Id, Book_name and quantity issued for all books which have been issued (f) To insert a new row in the table issued having the following data. ‘F0003’, 1 (g) Give the output of the following

i. Select Count(*) from Books ii. Select Max(Price) from books where quantity >=15

iii. Select book_name, author_name from books where publishers=’first publ.’ iv. Select count(distinct publishers) from books where Price>=400

Q 3: Write the SQL query commands based on following table:

Table: Employees

Empid Firstname Lastname Address City

010 Ravi Kumar Raj nagar GZB

105 Harry Waltor Gandhi nagar GZB

152 Sam Tones 33 Elm St. Paris

215 Sarah Ackerman 440 U.S. 110 Upton

244 Manila Sengupta 24Friends street New Delhi

300 Robert Samuel 9 Fifth Cross Washington


2015-16


Class - XII

335 Ritu Tondon Shastri Nagar GZB

400 Rachel Lee 121 Harrison St. New York

441 Peter Thompson 11 Red Road Paris

Table: EmpSalary

Empid Salary Benefits Designation

010 75000 15000 Manager

105 65000 15000 Manager

152 80000 25000 Director

215 75000 12500 Manager

244 50000 12000 Clerk

300 45000 10000 Clerk

335 40000 10000 Clerk

400 32000 7500 Salesman

441 28000 7500 salesman

Write the SQL commands for the following :

(i) To show firstname,lastname,address and city of all employees living in paris (ii) To display the content of Employees table in descending order of Firstname. (iii) To display the firstname,lastname and total salary of all managers from the tables Employee and empsalary ,

where total salary is calculated as salary+benefits. (iv) To display the maximum salary among managers and clerks from the table Empsalary. (v) Give the Output of following SQL commands:

(i) Select firstname,salary from employees ,empsalary where designation = ‘Salesman’ and Employees.empid=Empsalary.empid;

(ii) Select count(distinct designation) from empsalary; (iii) Select designation, sum(salary) from empsalary group by designation having count(*) >2; (iv) Select sum(benefits) from empsalary where designation =’Clerk’;

Q 4: Draw K MAP of the following:

i. F(A,B,C,D)=∑(0,2,4,6,7,8,9,11,13,15)

ii. F(W,X,Y,Z)=π(2,3,4,5,6,7,8,9,10,11,12,13,14)


2015-16


Class - XII

ENGLISH 1. Solve two CBSE sample papers on class work notebook.

-The papers should be solved in time limit

-only answers are required within the word limit

2. Revise the novel “The Invisible Man” thoroughly.

-Focus on characters

-Events

-Plot of the story

-Special incidents

-Theme

B. STUDIES 1. Complete the project work on the following topic.

- Management- Principles of management

- Business Environment- Element of business environment

- Stock Market

- Marketing


2015-16


Class - XII

2. Solve any two sample papers on the separate loose sheets.

ACCOUNTANCY 1. Complete the project work on the following topics.

- Cash Flow

- Ratio

2. Solve any two sample paper on the separate loose sheets.

GEOGRAPHY 1. Learn and write last 5 years CBSE question paper.

2. Complete the practical file.

3. Draw relevant diagrams, flow chart, maps related to questions asked in last 5 years CBSE

board exam.

4. From 5 questions- one five marks, and one question, three marks questions from three

marks questions and one mark question from one mark from 5 different questions.

HISTORY 1. Complete the exercise of history chapter 13,14, and 15 with glossary, map, passage based

questions, timeline, in homework notebook.


2015-16


Class - XII

2. Prepare/complete project file/album for board examination practical/project for 20 marks

group wise allotted of topics as per CBSE norms.

3. Prepare one very short answer type questions, short answer type questions, and long

answer type questions from each chapter of the book.

4. Make relevant diagrams and maps for the questions of last 5 years question papers.

PHYSICS

1. A thin prism of angle of prism 6o gives a deviation of 3o. What is the refractive index of

the material of the prism?

2. The angle of minimum deviation for prism of angle 60o is 30o. Calculate the speed of light

in the material of the prism.

3. A ray of light is incident at an angle of 60o on one side of a 30o prism. The emergent ray

from the prism makes an angle of 30 with the incident ray. Show that the emergent ray is

normal to the surface from which it emerges. Also calculate the RI of the material of the

prism.

4. A glass prism whose RI is 1.53 and refracting angle is 60o is held in a liquid of RI 1.33.

Calculate the angle of minimum deviation.

5. The focal length of the objective and eye piece of an astronomical telescope 25cm and

2.5cm respectively. The telescope is focused on an object 1.5m from objective. The final

image is formed at 25cm from eye of the observer. Find the length of the telescope.

6. Given light of wavelength 5100Ao from a narrow slit is incident on a double slit. Is the

overall separation of 10 fringes on a screen 200cm away is 2cm, find the slit separation.

7. In YDSE, while using a source of light of wavelength 5000Ao, the fringe width obtained is

0.6cm. If the distance between the slit and screen is reduced to half, what should be the

wavelength of the light to get fringes 0.003m wide.


2015-16


Class - XII

8. Given the RI of the medium is √3. What is the angle of refraction if the unpolarised light

is incident on it at the polarizing angle of the medium?

9. A light of wavelength 600nm is incident normally on a slit of width 3mm. Calculate the

linear width of the central maxima on a screen kept 3m away from the slit.

10. Light reflected from the surface of a glass slab of refractive index 1.57 is linearly

polarized. Calculate the angle of reflection on the glass surface.


2015-16


Class - XII

Solve selection test paper


2015-16


Class - XII


2015-16


Class - XII

Solve the problem of lessons that are completed of

the papers given


2015-16


Class - XII

kv no. 2 delhi cantt. (i shift 2015-16 autumn break...

Documents