Vidyasankul Foundation’s
Sanskruti junior College
(Arts, Commerce& Science -English Medium)
Lalonde,Boisar MIDC Road,Tal. Dist. Palghar-401404
First Term- I 2023-24
Sub: -Information Technology Std:XI
(Science, Commerce, Art’s) SET-B
Marks: - 50 Time:-2:00 Hrs
Instructions:
1. All questions are compulsory.
2. Read the given instructions of question paper carefully.
Q.1 Fill in the Blanks [05 marks]
1. RAM is also called as _______ memory.
2. The _______ is collection of interrelated data.
3. _______ OS is an open source operating system created by Google.
4. The _______ datatype stores time.
5. ISP stands for _______.
Q.2 True or False: [05 marks]
1. Record is also called tuple.
2. Hardware is a generic term used to describe computer program.
3. Make table command is used to create a new table.
4. The left bar of Ubuntu is called button.
5. Using SQL, you can update records in a database.
Q.3 Multiple Choice Questions (Select 1 Answer) [10 marks]
1. The _______ software is also called end-user programs.
a. System
b. Application
c. User
d. Client
2. _______ datatype holds the date including day, month and year.
a. Date
b. Time
1
c. Int
d. Number
3. The _______ memory is the internal memory of a computer.
a. Secondary memory
b. Private memory
c. Personal memory
d. Primary memory
4. Atomicity _______ Isolation Durability (ACID).
a. Continue
b. Convey
c. Control
d. Consistency
5. Root directory is written as _______.
a. /
b. //
c. \\
d. \
6. _______ are shown vertically in a table.
a.
b.
c.
d.
7. GUI is also called _______.
a. GNOME
b. GMOM
c. GNONE
2
d. GNOT
8. In _______ relationship, multiple records in a table are connected with multiple records in another table.
a. One to One
b. One to Many
c. Many to Many
d. Many to One
9. A _______ network has no dedicated servers.
a. Client Server
b. Peer to Peer
c. Local Area
d. Client to Client
10. The _______ command is used to extract data from a table.
a. Select
b. List
c. Display
d. Update
Q.4 Multiple Choice Questions (Select 2 Answers) [10 marks]
1. Following are the secondary storage devices.
a. Flash memory
b. RAM
c. ROM
d. Magnetic Disk
2. Data model describes the method of _______ and _______ the data.
a. Storing
b. Removing
c. Retrieving
3
d. Relationing
3. Following are the features of LAN:
a. Communication medium used is telephone network.
b. LAN is easy to setup.
c. Noise and errors are more.
d. It is less expensive.
4. Following are Data Manipulation Language (DML) commands:
a. Insertion into
b. Drop
c. Alter
d. Delete
5. Following are the popular IT enabled services:
a. Medical store
b. Call centers
c. General store
d. Data centers
Q.5 Multiple Choice Questions (Select 3 Answers) [06 marks]
1. Advantages of DBMS are:
a. Reducing data redundancy
b. University and colleges
c. Privacy
d. Backup and recovery
e. Data cannot be shared
4
2. Following are the output devices.
a. Printer
b. Magnetic Tapes
c. Speaker
d. Mouse
e. Monitor
Q.6 Match the following: [04 marks]
Column A Column B
1. RAM a. Hard Disk
2. ROM b. Volatile memory
3. Pen Joystick c. Non-volatile memory
4. Secondary memory d. Input unit
Q.7 Short Question Answers ( ANY 2 ): [06 marks]
1. Explain Data Model.
2. Explain categories of software.
3. Explain text datatype in DBMS.
4. Short note on Hardware.
Q.8 HTML Program ( ANY 1 ): [04 marks]
1. Create a webpage that will display a heading DBMS and a paragraph about DBMS.
2. Write the code for following output: