Scribd
Upload
24 views1 page

It Practical Set 2

The document outlines a lab test for Class XII Information Technology students at St. Xavier International School, consisting of programming tasks in Java and SQL queries based on a provided student table. It includes requirements for creating a Java program to print star patterns and Fibonacci series, as well as SQL commands for various operations on the student data. Additionally, it specifies components such as a practical file, project file, and viva-voce assessment.

Uploaded by

debojitsamal80
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
24 views1 page

It Practical Set 2

The document outlines a lab test for Class XII Information Technology students at St. Xavier International School, consisting of programming tasks in Java and SQL queries based on a provided student table. It includes requirements for creating a Java program to print star patterns and Fibonacci series, as well as SQL commands for various operations on the student data. Additionally, it specifies components such as a practical file, project file, and viva-voce assessment.

Uploaded by

debojitsamal80
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

ST.

XAVIER INTERNATIONAL SCHOOL


Subject -INFORMATION TECHNOLOGY(802)
CLASS - XII
LAB TEST( SET 2)
FULL MARK - 40
Q1.
a. Write a java program to print the stars in following pattern [5]
*
* *
* * *
* * * *
* * * * *
b. Write a java program to print Fibonacci series up to N terms. [5]

Q2.Write SQL queries on the basis of following table .

STUDENT

Roll_No Name Class Fees Gender DOB


1 Rahul XII 1250 M 2005-02-01

2 Mehul XII 1200 M 2004-12-11

3 Manisha XI 1050 F 2006-10-12

4 Sujoy XI 1050 M NULL

5 Sonakshi XII 1250 F 2005-09-19

6 Suman X 950 F 2008-06-16

a. Write SQL query for creating the STUDENT table with given fields. [5]
b. Write SQL commands for the statements given below. [5]
i. To display all records from S T U D E N T t a b l e .
ii. To display NAMEs of all M A L E students from STUDENT table with their CLASS.
iii. To display the details of the student(s) where the DOB is not known or NULL.
iv. To show the names of t h o s e students having fees between 950 to 1200.
v. To write query for adding a new field AADHAR_NO to the STUDENT table.

Q3.Practical File [10]


Q4.Project File [5]
Q5.Viva-Voce [5]
External Examiner Internal Examiner
Name: Name:

Sign: Sign:

You might also like