Class Xi Guess Paper Informatics Practices: General Instructions: MM: 70
Class Xi Guess Paper Informatics Practices: General Instructions: MM: 70
Class Xi Guess Paper Informatics Practices: General Instructions: MM: 70
com
CLASS XI
GUESS PAPER
INFORMATICS PRACTICES
General Instructions : MM : 70
1. All questions are compulsory.
2. Answer in sequence.
3. Put the questions no. properly.
4. Programming Language Java & Database MySQL
Q1.
a. Answer the following questions : (4)
i. What is an operating system ? Give two examples of an operating system ?
ii. Give the relationship between Byte and gigabyte.
iii. What is a computer virus ? How can it affect your computer ?
iv. How is backup utility useful ? Is it necessary to take backup of data ?
b. Give example for each of the following: (2)
i. A language processor. ii. A utility software.
iii. A package software. iv. A non-impact printer.
c. Differentiate between : (4)
i. A volalite and non volalite memory. ii. Compiler and Interpreter.
iii. Machine language and High level language. iv. System s/w and Application s/w.
Q2.
a. Answer the following questions :
i. What is e-Business ? (1)
ii. If you are e-Learner,how e-Learning will benefit you ? (2)
iii. How does the e-Business impact daily life of a common man ? (2)
Q3. Answer the following questions :
i. Differentiate between : (2)
a. Char and Varchar b. Primary Key and Unique Key
ii. What is the significance of DELETE command ? How does the WHERE clause
--------------------------------------------------------------------------------------------------------
CBSE Sample Papers | CBSE Guess Papers | CBSE Practice Papers | Important Questions | CBSE PSA | CBSE OTBA | Proficiency
Test | 10 Years Question Bank | CBSE Guide | CBSE Syllabus | Indian Tutors | Teacher' Jobs CBSE eBooks | Schools | Alumni |
CBSE Results | CBSE Datesheet | CBSE News
CBSEGuess.com
--------------------------------------------------------------------------------------------------------
CBSE Sample Papers | CBSE Guess Papers | CBSE Practice Papers | Important Questions | CBSE PSA | CBSE OTBA | Proficiency
Test | 10 Years Question Bank | CBSE Guide | CBSE Syllabus | Indian Tutors | Teacher' Jobs CBSE eBooks | Schools | Alumni |
CBSE Results | CBSE Datesheet | CBSE News
CBSEGuess.com
e. Create a Java Desktop Application to find the Discount of an item on the basis of Category
of item[Electrical Appliance/Electronic Gadget / Stationary ].The Categories will be implemented
in JRadioButton controls. The Discount will be calculated as follows : (4)
COST DISCOUNT(%)
<=1000 5
Otherwise 10
--------------------------------------------------------------------------------------------------------
CBSE Sample Papers | CBSE Guess Papers | CBSE Practice Papers | Important Questions | CBSE PSA | CBSE OTBA | Proficiency
Test | 10 Years Question Bank | CBSE Guide | CBSE Syllabus | Indian Tutors | Teacher' Jobs CBSE eBooks | Schools | Alumni |
CBSE Results | CBSE Datesheet | CBSE News
CBSEGuess.com
CATEGORY DISCOUNT(%)
Electrical Appliance 3
Electrical Gadget 2
Stationary 1
--------------------------------------------------------------------------------------------------------
CBSE Sample Papers | CBSE Guess Papers | CBSE Practice Papers | Important Questions | CBSE PSA | CBSE OTBA | Proficiency
Test | 10 Years Question Bank | CBSE Guide | CBSE Syllabus | Indian Tutors | Teacher' Jobs CBSE eBooks | Schools | Alumni |
CBSE Results | CBSE Datesheet | CBSE News
CBSEGuess.com
Text Stationery
JRadioButton3
Variable Name rdbtn3
JButton1 Variable Name btnComp
JButton2 Variable Name btnExit
Q5.
a. Create a Java Desktop Application to perform the following calculations: (4)
i) Calculation of Total and Average Marks
Total = English + Maths + Physics + Chemistry + IP
Average = Total / 5
ii) Displaying the Distinction /Average Marks based on the Total Marks scored.
iii) Displaying the grade (A,B,C,D,F) based on the average marks scored.
iv) On clicking of Exit Button ,it will exit the application.
AVERAGE RESULT GRADE
>=75 Distinction A
>=60 First Class B
>=50 Second Class C
>=40 Average D
Otherwise Fail F
Enter five Subject marks.Also the entered marks should be between 0 and 100 for each subject.
--------------------------------------------------------------------------------------------------------
CBSE Sample Papers | CBSE Guess Papers | CBSE Practice Papers | Important Questions | CBSE PSA | CBSE OTBA | Proficiency
Test | 10 Years Question Bank | CBSE Guide | CBSE Syllabus | Indian Tutors | Teacher' Jobs CBSE eBooks | Schools | Alumni |
CBSE Results | CBSE Datesheet | CBSE News
CBSEGuess.com
b. Write a method Min_Three that returns the smallest of three floating – point numbers. (2)
c. Write a method CheckVowel for a Java class that accepts a character and check whether it is
a vowel or a consonant.It returns 1 if character is a vowel else it returns 0. (2)
d. An integer is said to be prime if it is divisible only by 1 and itself.For example 2,3,5 and 7 are
prime but 4,6 and 9 are not prime.Write a method PrimeCheck that determines if a number is
prime or not. (2)
Q6. Answer the following questions :
a. Which command is used to change column size from VARCHAR(10) to VARCHAR(50). (1)
b. What is a NULLvalue? (1)
c. What do % and _ mean inside SELECT with LIKE statement? Explain with the help of examples of
each. (2)
d. After creating the "employee" database, you want to use it. Write the command that you shou ld
give. (2)
e. What will be the putput of the following : (2)
--------------------------------------------------------------------------------------------------------
CBSE Sample Papers | CBSE Guess Papers | CBSE Practice Papers | Important Questions | CBSE PSA | CBSE OTBA | Proficiency
Test | 10 Years Question Bank | CBSE Guide | CBSE Syllabus | Indian Tutors | Teacher' Jobs CBSE eBooks | Schools | Alumni |
CBSE Results | CBSE Datesheet | CBSE News
CBSEGuess.com
Q7. Write SQL commands for the queries given from a to f and write the output of the SQL
commands given in part g based on a table LIBRARY shown below: (10)
Table: LIBRARY
No. Title Author Subject Publisher Quantity Price
1 Data Structure Lipschute DS McGraw 4 217.00
2 DOS Guide NORTRON OS PHI 3 175.00
3 Turbo C++ Robort Lafore Prog Galgotia 5 270.00
a) To display the title of all books with Price between 100 and 300.
b) To display Title and Author of all the books having type Prog and published by BPB.
c) To display the list of all the books with price more than 130 in ascending order of Qty.
d) To display the list of all books whose quantity is less than 4.
e) To display the publishers and the number of books of each book in the table.
f) To insert a new book in the table LIBRARY.
g) To increase the price of the book title ‘TURBO C++’ by Rs.30.
h) To display the Title and Total Price of all Computer books.The Total Price is calculated as Price * Qty.
i) Write the output of the following:
i. Select MIN(Price) from Library;
ii. Select Sum(Price * Qty) from Library where Qty > 3;
iii. Select Avg(Price) from Library where Qty < 4;
--------------------------------------------------------------------------------------------------------
CBSE Sample Papers | CBSE Guess Papers | CBSE Practice Papers | Important Questions | CBSE PSA | CBSE OTBA | Proficiency
Test | 10 Years Question Bank | CBSE Guide | CBSE Syllabus | Indian Tutors | Teacher' Jobs CBSE eBooks | Schools | Alumni |
CBSE Results | CBSE Datesheet | CBSE News
CBSEGuess.com
--------------------------------------------------------------------------------------------------------
CBSE Sample Papers | CBSE Guess Papers | CBSE Practice Papers | Important Questions | CBSE PSA | CBSE OTBA | Proficiency
Test | 10 Years Question Bank | CBSE Guide | CBSE Syllabus | Indian Tutors | Teacher' Jobs CBSE eBooks | Schools | Alumni |
CBSE Results | CBSE Datesheet | CBSE News