Central board of secondary Education-New Delhi
SSAC PRACTICAL EXAMMINATION-2024
COMPUTER SCIENCE (083)
Exam centre: [Link] INTERNATIONAL SCHOOL (CBSE) (CODE NO: 56001)
MOTHER VIRGIN GARDEN, KODOKOTTAI.
MARK: 30 DATE: 13.1.2024
REG NO: Time: 03 Hrs.
1. WAP to create and search records in binary file. 08
2. To write Queries for the following Questions based on the given table: 04
Write SQL commands for the following statements:
i) Write a Query to insert all the rows of above table into Info table.
ii) Write a Query to display all the details of the Employees from the
above table 'STU'.
iii) Write a query to Rollno, Name and Department of the students from
STU table.
iv) Write a Query to select distinct Department from STU table.
v) To show all information about students of History department.
3 import [Link]
con=[Link](host='localhost',username='root',password='csgr
oup', database='employees')
if con.is_connected():
cur=_____________ #statement1
print('*******************************')
print("Welcome to Employee Search Screen")
print('*******************************')
No=int(input("Enter the employee number to search:"))
Query=____________ #statement2
[Link](____________) #statement3
data=cur.______________ () #statement4
if data!=None:
print(data)
else:
print("Record not Found!!!")
[Link]()
4. Report File 07
5. Project 08
6. Viva 03
Central board of secondary Education-New Delhi
SSAC PRACTICAL EXAMMINATION-2024
COMPUTER SCIENCE (083)
Exam centre: [Link] INTERNATIONAL SCHOOL (CBSE) (CODE NO: 56001)
MOTHER VIRGIN GARDEN, KODOKOTTAI.
MARK: 30 DATE: 13.1.2024
REG NO: Time: 03 Hrs
1. WAP to read a text file and display the number of vowels/consonants/lower case/ 08
upper case characters
2. To write Queries for the following Questions based on the given table: 04
Write SQL commands for the following statements:
i) Write a Query to delete the details of Roll number is 8
ii) Write a Query to change the fess of Student to 170 whose Roll number
is 1, if the existing fess is less than 130.
iii) Write a Query to add a new column Area of type varchar in table STU.
iv) Write a Query to Display Name of all students whose Area Contains
NULL.
v) Write a Query to delete Area Column from the table STU.
vi) DROP TABLE STU;
3 import [Link]
con=[Link](host='localhost',username='root',password='csgr
oup', database='employees')
if con.is_connected():
cur=_____________ #statement1
print('*******************************')
print("Welcome to Employee Search Screen")
print('*******************************')
No=int(input("Enter the employee number to search:"))
Query=____________ #statement2
[Link](____________) #statement3
data=cur.______________ () #statement4
if data!=None:
print(data)
else:
print("Record not Found!!!")
[Link]()
4. Report File 07
5. Project 08
6. Viva 03
Central board of secondary Education-New Delhi
SSAC PRACTICAL EXAMMINATION-2024
COMPUTER SCIENCE (083)
Exam centre: [Link] INTERNATIONAL SCHOOL (CBSE) (CODE NO: 56001)
MOTHER VIRGIN GARDEN, KODOKOTTAI.
MARK: 30 DATE: 13.1.2024
REG NO: Time: 03 Hrs
1. WAP to copy particular lines of a text file into another text file. 08
2. To write Queries for the following Questions based on the given table: 04
Write SQL commands for the following statements:
i) Write a Query to Create a new database in the name of "STUDENTS".
ii) Write a Query to Open the database "STUDENTS".
iii) Write a Query to create the above table called: "STU
iv) Write a Query to list all the existing database names.
v) Write a Query to List all the tables that exists in the current database.
3 import [Link]
con=[Link](host='localhost',username='root',password='csgr
oup', database='employees')
if con.is_connected():
cur=_____________ #statement1
print('*******************************')
print("Welcome to Employee Search Screen")
print('*******************************')
No=int(input("Enter the employee number to search:"))
Query=____________ #statement2
[Link](____________) #statement3
data=cur.______________ () #statement4
if data!=None:
print(data)
else:
print("Record not Found!!!")
[Link]()
4. Report File 07
5. Project 08
6. Viva 03
Central board of secondary Education-New Delhi
SSAC PRACTICAL EXAMMINATION-2024
COMPUTER SCIENCE (083)
Exam centre: [Link] INTERNATIONAL SCHOOL (CBSE) (CODE NO: 56001)
MOTHER VIRGIN GARDEN, KODOKOTTAI.
MARK: 30 DATE: 13.1.2024
REG NO: Time: 03 Hrs.
1. WAP to display short words from a text file. 08
2. To write Queries for the following Questions based on the given table: 04
Write SQL commands for the following statements:
i) Write a Query to list name of female students in Hindi Department.
ii) Write a Query to list name of the students whose ages are between 18
to 20
iii) Write a Query to display the name of the students whose name is
starting with 'A'
iv) Write a query to list the names of those students whose name have
second alphabet 'n' in their names.
3 import [Link]
con=[Link](host='localhost',username='root',password='csgr
oup', database='employees')
if con.is_connected():
cur=_____________ #statement1
print('*******************************')
print("Welcome to Employee Search Screen")
print('*******************************')
No=int(input("Enter the employee number to search:"))
Query=____________ #statement2
[Link](____________) #statement3
data=cur.______________ () #statement4
if data!=None:
print(data)
else:
print("Record not Found!!!")
[Link]()
4. Report File 07
5. Project 08
6. Viva 03
Central board of secondary Education-New Delhi
SSAC PRACTICAL EXAMMINATION-2024
COMPUTER SCIENCE (083)
Exam centre: [Link] INTERNATIONAL SCHOOL (CBSE) (CODE NO: 56001)
MOTHER VIRGIN GARDEN, KODOKOTTAI.
MARK: 30 DATE: 13.1.2024
REG NO: Time: 03 Hrs.
1. WAP to implement stack operations (List). 08
2. To write Queries for the following Questions based on the given table: 04
Write SQL commands for the following statements:
i) Write a Query to insert all the rows of above table into Info table.
ii) Write a Query to display all the details of the Employees from the
above table 'STU'.
iii) Write a query to Rollno, Name and Department of the students from
STU table.
iv) Write a Query to select distinct Department from STU table.
v) To show all information about students of History department.
3 import [Link]
con=[Link](host='localhost',username='root',password='csgr
oup', database='employees')
if con.is_connected():
cur=_____________ #statement1
print('*******************************')
print("Welcome to Employee Search Screen")
print('*******************************')
No=int(input("Enter the employee number to search:"))
Query=____________ #statement2
[Link](____________) #statement3
data=cur.______________ () #statement4
if data!=None:
print(data)
else:
print("Record not Found!!!")
[Link]()
4. Report File 07
5. Project 08
6. Viva 03