8th Computer Science Periodic Test II (2018-19)

School Name: Venkateshwar Global School, Sector 13, Rohini, Delhi 110085 India
Time: 1 hr 30 mins
M.M. 40 marks
Date: 7/09/2018
Class: VIII

General Instructions:

Please write down the serial number of the question before attempting it.
All the questions are compulsory.
Please read the paper carefully and write all your answers only on the Answer Sheets provided separately.

Question I: Fill in the blanks: 5 mark

_________ data type stores up 1 GB of data.
_________ tag is used to start a new paragraph.
Font style tags are also known as ___________.
_________ pane in the Query window displays the Design grid.
Multiple criteria in a query can be set by using ________ property.

Question II: State True or False. 5 mark

<Body> tag contains the text which gets displayed on the web page.
Update Query is used when we have to update or change existing data in a set of records.
Yes/No data type stores information like date of birth, date of joining etc.
It is essential to specify the data type for a field name.
Tags are also known as attributes.

Question III: Multiple Choice Questions: 5 mark

a. Which tag in HTML breaks the line and displays the text from the next line?

<bl>
size

b. Which property is used to filter the data either in ascending or descending order?

Primary key
Data types
Sort
Forms

c. Which key combination is used to save the changes and close a table?

Ctrl+V
Ctrl+M
Ctrl+R
Ctrl+W

d. ________ is an application software which is used to create and manage a database.

DBMS
DBBS
DSSB
DDMS

e. How many views does Access provide to display a form?

Two
Three
Four
Five

Question IV: Determine the data type for the following fields in a Product table: 5 mark

Product ID
Product Nme
Quantity
Date of delivery
Cost

Question V: Identify the errors and rewrite the below code correctly. Underline the corrections. 5 mark

<html>
<head><title> title of the web page </head>
<body bgcolour=”red”>
My first program<//u>
 
 Learning html is fun! 
</body>
<html>

Question VI: Give the full forms of the following: 5 mark

WWW
HTML
URL
VoIP
IP

Question VII: Give distinction between forms and reports. 2 mark

Question VIII: What do you understand by tags? Name the two types of tags which are there in HTML. 2 mark

Question IX: Write an HTML code to display your class name in italics and hold. 2 mark

Question X: Rashmi wants to make a horizontal line across the web page that she is creating and also wants to change the size of the text. Suggest her the tags which she can use in her HTML program. 2 mark

Question XI: What will the output in case of the given query? Refer to the following data to answer the question: {HOTS} 2 mark

Adimision no

Student name

Marks

Grade

101

Aman Verma

102

Simaran Bajaj

103

Ajay Jain

104

Sumit Goyal/one_fourth]

105

Nitya Mittal

106

Priya Sen

Query: Display the Admission_no and Student_name of records where Admission_no=102 OR Grade=A.

Class Notes NCERT Solutions for CBSE Students

8th Computer Science Periodic Test II (2018-19)