Class 10 Sample Paper Information Technology (Half Yearly)

SAMPLE
PAPER
Half Yearly Examination

Prepared For
NCERT BASED SYLLABUS
Applicable For
CBSE BOARD AND STATE BOARD USING NCERT

WWW.

HALF YEARLY EXAMINATION
SAMPLE QUESTION PAPER
Class - X Subject –Information Technology
Time – 2 Hours Maximum Marks- 50

1. Multiple Choice Questions: [1 x 10 = 10]
(i) The way of communication in which message is conveyed in imagery form.
(a) Visual Commnunication
(b) Verbal Communication
(c) Non-Verbal Communication
(d) None of these
(ii) One of the rule of 7'Cs of communication in which the meaning of the message should be clear so that audience
understand easily what is to be conveyed.
(a) Clarity
(b) Concrete
(c) Concise
(d) Courteous
(iii) The quality of the person to organize and monitor ones own behaviour and willingness of doing things.
(a) Self Motivation
(b) Self Regulation
(c) Self Awareness
(d) All of these
(iv) A network security device or system that monitors and safeguard the network traffic based on the defined security
rules.
(a) Hub
(b) Switch
(c) Firewall
(d) Router
(v) An inbuilt document that contains pre-defined formatting styles, graphics, tables, objects and other information
that is commonly used in a particular pattern.
(a) Mail Merge
(b) Anchors
(c) Styles
(d) Template
(vi) This option sends the selected object one layer down in the screen.
(a) Send Backward
(b) Send to Back
(c) Bring to Front
(d) Bring Forward
(vii) Duplication or repetition of data is known as:
(a) Sharing of data
(b) Inconsistency
(c) Data Redundancy
(d) Data Sharing

(viii) A formal presentable printed document that lists data in a formatted manner is known as:
(a) Query
(b) Form
(c) Report
(d) None of these
1

(ix) The statement used for modifying records in a database.
(a) UPDATE
(b) ALTER
(c) DELETE
(d) DROP
(x) This command deletes all the entries or data from the table but keeps the table structure secured in the database.
(a) DROP
(b) TRUNCATE
(c) DELETE
(d) REVOKE

2. Answer the following questions:
(i) List the measures to overcome Barrier in Communication. [2]
(ii) How working independently benefits us? [2]
(iii) Describe any four functions of an Operating System. [2]
(iv) How Operating System acts as messenger between hardware and application program? [2]
(v) What happens when a computer virus infects your system? State any four points in support of
your answer. [2]
(vi) Write the steps to perform the following actions:
(a) Apply a style to the selected Text. [2]
(b) To insert graphic from a File [2]
(c) To arrange an image on the top of any graphics [2]
(vii) What are the benefits of using DBMS? [2]
(viii) Can there be multiple primary keys in a table? Justify your answer. [2]
(ix) What do you mean by Data Definition Language (DDL)? Define any two DDL commands. [2]
(x) Write the output of the following SQL query: [2]
TABLE: ACCESSORIES
NO NAME PRICE ID
A01 MOTHER BOARD 12000 S01
A02 HARD DISK 5000 S01
A03 KEYBOARD 500 S02
A04 MOUSE 300 S01
A05 MOTHER BOARD 13000 S02

(a) SELECT * FROM ACCESSORIES
(b) SELECT * FROM ACCESSORIES WHERE PRICE>=5000
(c) SELECT * FROM ACCESSORIES ORDER BY PRICE ASC
(d) SELECT NAME FROM ACCESSORIES WHERE NAME="MOTHER BOARD"

2

3. Answer the following questions:
(a) State the significance of 'Mail Merge' in digital documentation. What are the steps to be followed to perform 'Mail
Merge'. [3]
(b) Explain the different styles of formatting. [3]
(c) What is the relationship between Primary Key and Foreign Key. Explain with example. [3]
(d) The management of a medical store decides to computerize its inventory. [3]
(i) Suggest any two tables which must be present in the database. You can also suggest fields of the
tables along with their data types.
(ii) Mention any two benefits that the management will have by computerizing the inventory.

4. Answer the questions on the basis of the following table: [4]
TABLE: STORE
STORE_NO STORE_NAME AREA
S101 Compunik Solution Jawahar Nagar
S102 HCL Karol Bagh
S103 Tezz Computers CP
S104 Micro Computers Nehru Place
S105 Digital Solutions CP

(i) To create and insert data as per the given table.
(ii) To display STORE_NO and STORE_NAME of all Stores located in CP.
(iii) Update Area of 'S102' to 'Rouse Avenue'
(iv) To arrange the database table on the basis of the field STORE_NAME in descending order.

3

AglaSem Earn while Learn Program. Send your papers and get paid.
Contact: support@