ROLL NUMBER SUBJECT CODE: 083 COIMBATORE & MADURAI ...

ROLL NUMBER

SUBJECT CODE: 083

COIMBATORE & MADURAI SAHODAYA SCHOOLS COMPLEX

COMMON EXAMINATION

DECEMBER 2020

Grade: XII

COMPUTER SCIENCE

Max. Marks: 70

Date: 14.12.2020

(SET ¨C B)

Time: 3 hrs

General Instructions:

1. Reading time : 9.15 am to 9.30 am

2. Writing time: 9.30 am to 12.30 pm

3. This question paper contains two parts A and B. Each part is compulsory.

4. Both Part A and Part B have choices.

a. Section ¨C I is short answers, to be answered in one word or one line.

b. Section ¨C II has 2 case study questions. Each case study has 4 case-based sub parts.

An examinee is to attempt any 4 out of the 5 subparts.

5. Part B is Descriptive Paper.

6. Part B has 3 sections.

a. Section ¨C I is short answer questions of 2 marks each in which 2 question have internal options.

b. Section ¨C II is long answer questions of 3 marks each in which 2 questions have internal options.

c. Section ¨C III is very long answer questions of 5 marks each in which one question has internal

option.

6. All programming questions are to answered using Python Language only.

Question

Part A

Marks

allocated

No.

Section I

Select the most appropriate option out of the options given for

each question. Attempt 15 questions from question no 1 to 21.

1.

What is a Primary key? Give an example.

1

1

2.

Consider L=[0.5 * x for x in range (0,4)]

1

and write the contents of the list L.

3.

What will be the result of the following statements?

a) bool(int(¡®0¡¯))

b) type(¡°hello¡±)

1

4.

5.

Which of the following creates a tuple?

a) tuple1=(¡°a¡±,¡±b¡±)

b) tuple[1]=(¡°a¡±,¡±b¡±)

c) tuple1=(5)*2

d) None of the above

Evaluate the following expression.

35+5 and 23%35]

18.

A tuple is declared as

1

T=(12,23,34,45)

What will be the value of T.index(34)

3

19.

20.

Number of tuples in a relation is called as_________.

The traditional telephone system follows ____________switching

1

1

technique.

21.

In SQL, write a query to display all the details from the table

1

ACADEMICS .

Section II

Both the case study based questions are compulsory. Attempt

any 4 sub parts from each question. Each question carries 1

mark.

22.

Jey International School has stored the details of teachers in a table

¡°DATA¡± of the database ¡°TEACHER¡±

Attributes of the table are:

Name

- Character (20)

Age

- Numeric

Department

- Character(20)

Salary

- Numeric

Gender

- Character

Based on the table given answer the queries given below.

Name

Jugal

Sangeetha

Rakesh

Shalakha

Shyam

Age

34

32

42

33

50

Department

Computer

Maths

Maths

Physics

Physics

Salary

20000

30000

25000

23000

32000

Gender

M

F

M

F

M

a) List the names of teachers who belong to Maths department.

b) Identify the degree and cardinality of the table.

4

1

1

c) Display the number of male and female teachers in the

1

school.

d) Delete the records of teachers whose age is more

1

than 30.

e) Display the unique departments in the school.

1

23.

Legend sports wanted to store the number of prizes for each sport

as a SPORTS.CSV file.

As a programmer help them to complete the task successfully.

import _______________ #Line 1

fh=___________________ # Line 2

swriter = ______________(fh) #Line 3

ans=¡¯y¡¯

i=1

while ans==¡¯y¡¯:

print(¡°Record¡±,i)

sport=input(¡°Sport name¡±)

prizes=int(input(¡°Enter prizes won¡±))

________________ # Line 4

i=i+1

ans=input(¡°Want to enter records¡±)

fh._________________#Line 5

a) Name the module to be imported in Line 1.

b) Fill in line 2 to open the CSV file.

1

1

c) Write the correct statement to write the datas into file in line 3

d) Write the statement to write the records given as input from user

1

in line 4.

1

e) Write a statement to close the file.

1

5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download