G.S. PUBLIC SCHOOL G.S.
PUBLIC SCHOOL
A Senior Secondary School, Affiliated to C.B.S.E., New Delhi, Upto 10+2 A Senior Secondary School, Affiliated to C.B.S.E., New Delhi, Upto
AN ISO 9001:2015 CERTIFIED SCHOOL AN ISO 9001:2015 CERTIFIED SCHOOL
Add: - Opp. Domchanch Thana, Domchanch, Koderma, Jharkhand Add: - Opp. Domchanch Thana, Domchanch, Koderma, Jharkhand
PERIODIC TEST-II, SESSION- 2023-24 PERIODIC TEST-II , SESSION- 2023-24
CLASS: - SEVEN SUBJECT: - COMPUTER F.M.: - 20 TIME: - 1 Hr. CLASS: - SEVEN SUBJECT: - COMPUTER F.M.: - 20 TIME: 1 Hr.
-: GENERAL INSTRUCTION: -
All questions are compulsory. -: GENERAL INSTRUCTION: -
Students answer in their own words as far as possible. All questions are compulsory.
Write the answer clearly . Students answer in their own words as far as possible.
A) Choose the correct option (1×5=5) Write the answer clearly.
1) In C++, the operator ___ is known as the insertion or put to operator. A) Choose the correct option (1×5=
(a) << (b) > (c) < 1) In C++, the operator ___ is known as the insertion or put to operator.
2) Data base management system (DBMS) is a software which allows access to____ (a) << (b) > (c) <
contains in a data base. 2) Data base management system (DBMS) is a software which allows access
(a) item (b) program (c) data contains in a data base.
3) The structure of database is divided into __ levels. (a) item (b) program (c) data
(a) one (b) three (c) four 3) The structure of database is divided into __ levels.
4) Date independent means that it may be possible to change the storage structure (a) one (b) three (c) four
without affecting the ___. 4) Date independent means that it may be possible to change the storage str
(a) application (b) operating (c) four without affecting the ___.
5) Customer may check the ___ of their bank account through the Internet. (a) application (b) operating (c) four
(a) balance (b) health (c) anger 5) Customer may check the ___ of their bank account through the Internet.
B) Fill in blanks :- (1×5=5) (a) balance (b) health (c) anger
1) END takes the cursor in the ___ line. B) Fill in blanks :- (1×5=5
2) __ is the shortcut of Run option. 1) END takes the cursor in the ___ line.
3) __ allows the user to control the data and to access them. 2) __ is the shortcut of Run option.
4) ___ interprets the online user's queries. 3) __ allows the user to control the data and to access them.
5) ____ contains data portion of the database. 4) ___ interprets the online user's queries.
(Helpbox:- Alt +F5, Next, Lable, DBMS, Qvery processor) 5) ____ contains data portion of the database.
C) Write 'True' & 'False' :- (1×4=4) (Helpbox:- Alt +F5, Next, Lable, DBMS, Qvery processor)
1) DBMS allows only to create a database. C) Write 'True' & 'False' :- (1×4=
2) DDL stands for data definition. 1) DBMS allows only to create a database.
3) An expression represents a number or a character. 2) DDL stands for data definition.
4) All variables must be declared after executing the statement. 3) An expression represents a number or a character.
D) Answer any three of the following questions.:- (2×3=6) 4) All variables must be declared after executing the statement.
1) What is meant by a declaration? Give an example. D) Answer any three of the following questions.:- (2×3
1) What is meant by a declaration? Give an example.
2) Write a program in C++ to add the two numbers. 2) Write a program in C++ to add the two numbers.
3) What does DBMS stands for? 3) What does DBMS stands for?
4) What are the major components of DBMS? 4) What are the major components of DBMS?
5) What are the three levels of database structure? 5) What are the three levels of database structure?
