Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Computer Science Practical Examination 2023-24 for Class XII, Schemes and Mind Maps of Computer science

Computer science

The practical examination schedule for the computer science subject for class xii students at camellia public school. The examination consists of programming tasks, sql commands, and other related activities. The document also includes a report file and project requirements, as well as viva voce guidelines.

Typology: Schemes and Mind Maps

2023/2024

Uploaded on 01/27/2024

nexus-op
nexus-op 🇮🇳

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CAMELLIA PUBLIC SCHOOL
AISSCE PRACTICAL EXAMINATION,2023-24
SUBJECT – COMPUTER SCIENCE
SUBJECT CODE – 083
CLASS - XII
School Code:…………………
Date…………………….. Set- A
Time : 3 hours Maximum Marks : 30
Lab Test
1. Write a program in python to read a text file and display the number of
vowels/consonants/uppercase/lowercase characters in the file. 8
2. Consider the following tables BOOK,MEMBER AND ISSUE.
Write SQL commands for the statements (i) to (iv). 4
BOOK
BookID
Title
Author
Stream
Price
B102
Computer
Science
Sanmay Kundu
Science
360
B103
Economics
Sandeep Garg
Commerce
525
B104
Mathematics
R.S. Aggarwal
Science
600
B105
History
J.Jana
Arts
195
B106
Geography
Arvind Kumar
Science
200
MEMBER
MemberID
Name
Phone
Age
M10001
Sahrul Alam
9875511902
45
M10002
Priyabrata Das
9143589200
35
M10003
Goutam Jana
8961288550
51
M10004
Sourav Das
7797252859
32
M10005
Aftab Ali
8777024877
55
pf2

Partial preview of the text

Download Computer Science Practical Examination 2023-24 for Class XII and more Schemes and Mind Maps Computer science in PDF only on Docsity!

CAMELLIA PUBLIC SCHOOL

AISSCE PRACTICAL EXAMINATION,2023- 24

SUBJECT – COMPUTER SCIENCE

SUBJECT CODE – 083

CLASS - XII

School Code:………………… Date…………………….. Set- A Time : 3 hours Maximum Marks : 30 Lab Test

1. Write a program in python to read a text file and display the number of vowels/consonants/uppercase/lowercase characters in the file. **8

  1. Consider the following tables BOOK,MEMBER AND ISSUE.** Write SQL commands for the statements (i) to (iv). 4 BOOK BookID Title Author Stream Price B102 Computer Science Sanmay Kundu Science 360 B103 Economics Sandeep Garg Commerce 525 B104 Mathematics R.S. Aggarwal Science 600 B105 History J.Jana Arts 195 B106 Geography Arvind Kumar Science 200 MEMBER MemberID Name Phone Age M10001 Sahrul Alam 9875511902 45 M10002 Priyabrata Das 9143589200 35 M10003 Goutam Jana 8961288550 51 M10004 Sourav Das 7797252859 32 M10005 Aftab Ali 8777024877 55

ISSUE

IssueNo Date MemberID BookID I55231 25 - 10 - 2010 M10002 B I55230 14 - 12 - 2009 M10004 B I55232 25 - 11 - 2010 M10001 B I55234 09 - 05 - 2012 M10003 B I55233 17 - 08 - 2011 M10005 B (i) Display the tilte and author of ‘Science’ books which are priced less than or equal to

(ii) Display the names of members who have issued books on 25/11/ (iii) Display the names of books issued on 25/11/ (iv) Display the name of the book issued by member ‘Sahrul Alam’ on 25/11/

**3. Report File 7

  1. Project 8
  2. Viva Voce 3** Name: Name: School Name: School Name: School Code: School Code: External Examiner No: Internal Examiner No: Signature Signature________________________