1 com (vii)

3rd Term Worksheet [2018 – 19]

Subject – Computer Application
Class – VII
Name : Sec. :
Chapter – 6
[Database and DBMS – An Introduction]
[Exercises]
[1] Answer the following questions: [79-80]
a. Write the steps how to create a New Blank Database in Microsoft Access 2010.
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
b. Define MS Access and its features.
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
c. What is Database?
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
d. What do you understand by DBMS and what are its advantages?
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
e. Name some DBMS softwares.
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
f. Define tables and the data types used in it.
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
 2 com (vii)
g. Write the steps to create new table in MS Access 2010.
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
h. Write the steps to save a table in MS Access 2010.
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
[2] Write ‘True’ or ‘False’: [80]
1. MS Access is a powerful Relational Database Management System (RDBMS) is used to
organize the data. ___________
2. It is a database creation program that does not allow anyone to easily maintain and edit
a database. ___________
3. A database is a collection of related information. ___________
4. A record in a row on a datasheet is a set of values defined by fields. ___________
5. Microsoft SQL Server is an example of DBMS. ___________
6. DBMS does not allow data to be easily shared. ___________
[3] Fill in the blanks: [81]
1. Microsoft’s SQL Server is an Example of DBMS that serves Database requests from
__________________________.
2. It is a user-friendly menu driven and easy program, which has a powerful
__________________________.
3. It is suitable for anything from small projects to __________________________.
4. Popular Database software is __________________________.
5. Full form of DBMS is __________________________.
[4] Define the following: [81]
a. Object __________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
b. Table _____________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
 3 com (vii)
c. Field _____________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
d. Record _____________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
Chapter – 7
[HTML – Advanced Features]
[Exercises]
[1] Answer the following questions: [96-97]
a. What are HTML Documents? What are its features?
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
b. Give some examples of HTML editors.
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
c. Write a short note on tag. Differentiate between the <HEAD> and <BODY> tag.
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
d. What is a marquee tag?
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
e. How many types of lists are there in HTML?
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
 4 com (vii)
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
f. What is an ordered list? Explain with examples.
Ans. __________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
g. Which software is used to write an HTML program?
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
h. How will you create a HTML document? Explain its steps.
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
[2] With reference to page structure explain the following terms: [97]
a. HTML _____________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
b. HEAD _____________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
c. TITLE _____________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
d. BODY _____________________________________________________________________
__________________________________________________________________________________
__________________________________________________________________________________
 5 com (vii)
[3] Write ‘True’ or ‘False’: [70]
a) HTML tag is a keyword enclosed in angle brackets (<HTML>).___________
b) HTML is easy to understand and interpret. ___________
c) <OL> tag is used to insert an unnumbered list in HTML. ___________
d) In HTML a user is not allowed to resize a table. ___________