kendriya vidyalaya sangathan chandigarh region … class... · kendriya vidyalaya sangathan...

3

Click here to load reader

Upload: vuminh

Post on 18-Aug-2018

212 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: KENDRIYA VIDYALAYA SANGATHAN CHANDIGARH REGION … Class... · KENDRIYA VIDYALAYA SANGATHAN CHANDIGARH REGION Class XI (INFORMATICS PRACTICES) Sample Question Paper –1 Time Duration

KENDRIYA VIDYALAYA SANGATHAN CHANDIGARH REGION Class XI (INFORMATICS PRACTICES)

Sample Question Paper –1 Time Duration 3 Hrs Max. Marks 70 Note 1. This question paper is divided into three sections 2. Section – A consists of 30 marks. 3. Section – B and Section – C are of 20 marks each. 4. Answer the questions after carefully reading the text.

Section A

Q 1 Answer the Following A What are the three types of computers? How they differ? 2 B What is the difference between Compiler and Interpreter? 2 C What happen when files and folders are deleted n windows? Is it possible to retrieve deleted objects later? If so how? 1 D What do you mean by term word wrapping? 2 E Expand GUI and CUI? 1 F What is MIS? Explain? 2

SECTION B B Q 2 Answer the Following A Define is an event? Given some Example? 2 B What is control Array ? How to create a Control array? 2 C Give any two example of SDI and MDI ? 2 D Difference between 4 i Label and Text box ii Combo Box and List Box Q 3 Answer the Following A Difference between numeric and non numeric data types? 2 B Rewrite the following code using select case 4 If marks>=75 and marks<=100 then Grade=”A+” Else if marks>=60 and marks< 75 then Grade=”A” Else if marks>=50 and marks< 60 then Grade=”B” Else if marks>=40 and marks< 50 then Grade=”C” Else Grade=”F” End if End if End if End if C Name the Caption properties of Clear and Exit Button? 2 D What is windows Common Control name any three windows 2 common controls?

DOWNLOADED FROM WWW.STUDIESTODAY.COM DOWNLOADED FROM WWW.STUDIESTODAY.COM

DOWNLOADED FROM WWW.STUDIESTODAY.COM DOWNLOADED FROM WWW.STUDIESTODAY.COM

www.studiesto

day.com

Page 2: KENDRIYA VIDYALAYA SANGATHAN CHANDIGARH REGION … Class... · KENDRIYA VIDYALAYA SANGATHAN CHANDIGARH REGION Class XI (INFORMATICS PRACTICES) Sample Question Paper –1 Time Duration

Q 4.Answer the following

A. Code for clear button to clear all fields. 2 B. Code for Exit button 1 C. Write a code for third text box disable when user execute a program. 1 D. Write the caption properties of all command button 2 E. Write the code for AreaTriange and arearectangle command button for

calculate the values of area 4

SECTION C Q 5 Answer the Following A. What is a database System? What is its need? 2 B. What is Normalization? What is the need of normalization? Define the first, Second and third normal forms? 4 C Give some key features of Oracles. 2 D What is SQL? What are different categories of commands available in SQL? 2 Q 6 Answer the following A Explain Union and Minus set operator with suitable example? 2 B Explain Primary key? With example 2 C Difference between 4 i front end and back end ii Two tier and three tier computing model? D What is equi join? Explain it with suitable example? 2 Q.7 Answer the questions based on the table student given below:

Table:Student

Column Name Data Type Size Constraints Description RollNumber Number 2 Student’s Roll Primary Key Name Varchar2 25 Name of

Student NOT NULL

Class Varchar2 3 Class of student

Stream Varchar2` 15 Stream opted by the students

TotalMarks Number 8,2 Total marks scored by the students

Grade Varchar2 1 Grade scored by the students

Can be ‘A’ or ‘B’ or ‘C’

DOWNLOADED FROM WWW.STUDIESTODAY.COM DOWNLOADED FROM WWW.STUDIESTODAY.COM

DOWNLOADED FROM WWW.STUDIESTODAY.COM DOWNLOADED FROM WWW.STUDIESTODAY.COM

www.studiesto

day.com

Page 3: KENDRIYA VIDYALAYA SANGATHAN CHANDIGARH REGION … Class... · KENDRIYA VIDYALAYA SANGATHAN CHANDIGARH REGION Class XI (INFORMATICS PRACTICES) Sample Question Paper –1 Time Duration

A Write a command to create a table using constraints. 2 B Write the SQL command to display roll Numbers, Names, Total Marks and grades of all the students in Non medical stream sorted by total marks in descending order. 2

C Write a SQL commands to insert a records in a table 1. D What is the output of following 2

i Select sysdate from dual ii Select user from dual;

E Write a query to display the number of employee with same job. 1 F Write a query to display employees who earn more commission 1

than their salaries? G Write a query to display employee number, name, sal and 1

sal * 12 as Annual Salary whose commission is not NULL from the table Emp?

DOWNLOADED FROM WWW.STUDIESTODAY.COM DOWNLOADED FROM WWW.STUDIESTODAY.COM

DOWNLOADED FROM WWW.STUDIESTODAY.COM DOWNLOADED FROM WWW.STUDIESTODAY.COM

www.studiesto

day.com