HNOLOGT
Check Point
1. A is an interface in a user specified layout that lets users to view, enter, and
directly in database objects such as tables. change data
(a) frame (b) form (c) relation
(d) report ICBSE 202y
2. Computer based record keeping system is known as
(a) CRKS -Computerizd Reond Keeping Systerm
(b) DBMS -Data Base Management System
(c) DMS - Data Management System (d) All of these
3. Duplication of data is known as
(a) Data Redundancy (b) Data Repentance
(c) Data Inconsistency (d) None of these
4. Multiple copies of same data that mismatch, are known as
(a) Data Redundancy (b) Data Repentance
(c) Data Inconsistency (d) None of these
5. Astorage container storing data pertaining to simple object, subject or purpose is known as
(a) Table (b) Query (c) Report (d) Form
P 6. A field that uniquely identifies records in the table is known as
A (a) Primary key (b)Candidate key (c) Unique key (d) Special key
R 7. A statement that gives you filtered data according to your
conditions and specifications, is called
T (a) Table (b) Query (c) Report (d) Form
8. An interface in user-defined layout that lets users view, enter or
change data in tables, is known as
(a) Table (b) Query (c) Report (d) Form
9. A formal, presentable printed document that lists
data in formatted way is known as
(a) Table (b) Query (c) Report (d) Form
10. Named collection of fields which represent a
complete unit of information is called
(a) Field (b) Record (c) Table (d) None of these
11. A row in atable is also known as
:
(a) A record (b) A field
12. Which of the following holds a (c) A data type (d) A tuple
single piece of data ?
(a) Table (b) Record
13. What is the correct (c) Field (d) Form
definition of primary key ?
(a) The first field in a table.
(b) A field that contains
(c) The field which we
unique data in each record.
will use to search with.
(d) A field which
14. What is the contains numbers only.
correct definition of foreign
(a) The common key ?
field of two tables.
(b) A field that
contains unique data in each
(c) The field same record.
as primary key.
(d) Afield that
stores values coming
from primary key of another table.
INTRODUCING DATABASES
165
primary key contains more than one
field, it is krnown as
a
When
15 (a) Alternate key (b) Candidate key (c) Foreign key
identify each record in atable ? (a) Composite key
What
is used to uniquely
I6. (a) Foreign key (b) Field (c) Datatype
for a database file? (d) Primary key
Which is
not true
record may contain several fields
Each
(a)
columns
( Fields are organised in
(c) Data types
have to be declared in advance
(d) Each field may contain several records
While designing a database, we should keep in mind
(a) Purpose of database (b) Tables required
() Field needed (d) All of them
oWhat are the main building blocks of a database ?
(a) Lists (b) Queries (c) Tables (a) Reports
AWhich of the following describes a relational database ?
(a) It provides a relationship between integers.
(b) It consists of separate tables of related data.
(c) It retrieves data related to its queries.
(d) It can print reports.
21. Data should be organised into tables based on :
(a) Field properties (b) Subjects associated with the real-data
(c) Character lengths (d) All of these
22. Which of the following best describes a query ?
(4) A query enables people to enter or view data in your database easily.
(0) Aquery summarizes and prints data.
(() A query filters data from a database based on a criteria.
(d) All of these
Which of the following best describes aform ?
(a) Aform enables people to enter or view data in a database easily.
(6) A form summnarizes and prints data.
() Aform filters data from a database based on a criteria.
(d) All of these
24. WWhich of the following best describes a report ?
database easily.
nreport enables people to enter or view data in a
()A report summarizes and prints data.
on a criteria.
nrePort filters data from a database based
(d) All of these
25. Adatabase table
should always contain records
(b) lots of
(a) images
(d) a key field
(C) lots of ready made queries
26. D
Data ina database is stored in a
(d) search
(c) report SYSTEM
166 INFORMATION TECHNOLOGYLY
27. A collection of data which is stored in alopgical structure is known as a
(a) field (c) record (d) table
(b) database
28. One piece of data abouta single person or thing is knoWn an
(c) field (d) database
(a) record () file
known as a
29. All of the information about one person or one thing is
(c) file (d) record
(a) database (b) field
particular topic is stored as a
30. Acollection of records on :a (c) folder (d) field
(a) table (b) record
a database you would use
records in
31. To find a particular record or set of (d) relationship
(c) table
(a) query (b) reportdirectly in database objects.
users to view, enter, and change data
JZ. It enables (c) Form (d) Database
(a) Report (b) Query [CBSE Sample Paper, 2023-24]
primary key in a database.
33. A table can have only (c) 3 (d) Many
(a) 1 (b) 2 [CBSE Sample Paper, 2023-24]
following is not an example
of DBMS ?
34. Which one of the (c) FoxPro (d) Impress [CBSE 2023|
(b) SQLite
(a) PostgresSQL
specified layout that lets users to
view, enter, and change data
is an interface in auser
35. A
such as tables.
directly in database objects (c) relation (d) report [CBSE 2023]
(a) frame (b) form
Fill in the Blanks
is used.
tables of related data, a relational
1. To organise the different are created.
a summary of data,
2. To display data in a specificformat or distribute are used.
input from user in a well-organized, formatted way on screen,
3. Toget data
row of information is called a
4. In the database view of a relational database, a administratorS
database, programmers and database
B. To control how information is entered into a
create to help ensure data integrity.
two tables in a relationship but not a primary key is
6. In arelational database, a common field that links
called a key. databases are called a
tables. Thus such
7. The database use conmmon fields to create links between
databases.
8. Primary key is used to identify the record in a table.
9 is a collection of related information. [CBSE 2023]
10. is usually suitable for less amount of data.
True /False Questions
1. AForeign key is linked to the primary key of the same table.
wasted
2. A Database can have only one table. space is
the database, then storage
3. If a piece of data (field-value) is stored in two places in
inconsistency.
ana changing the data in one place will not cause data
7/ NIRODUCIN
values 167
8roup of
can store tables cannot have a common field.
Afield
relational
database, two
Ina key is the
primary key of another table.
;
for searching data in table.
f o r e i g n
AA are
used
Forms
Competency Based Questions
to store a huge amount of information
Akshat
wants
would be most
1 table organisation would
about his firm
suitable for this purpose ? in a database.
Which type of
(a) Relational
(b) Flat File
OEither Relational or Flat file (d) Hierarchical
[CBSE
Sample Paper Term I, 2021-22]
2 Juan has related to his work in multiple
stored the data
related to an important thing was stored in three different files. He did not
files separately. realise that same data
This type of storing data at multiple locations is
known as data
(a) Inconsistency (b) Redundancy
(c)Standardisation
(d) None of these
1 Juan has stored the data related to
his
related to an important thing was storedwork in multiple files. He did not realise
in three different files separately. that same data
This led to ahuge problem for Juan when he
update other files. This problem is known as datamodified the data in one file while forgetting to
(a) Inconsistency
(b) Redundancy
() Standardisation
(d) None of these
t. lo supPort and help Juan, his brother's friend Prabhnoor has
Of database in such a case. So he advised him to create
come. He explained the need and role
tables such that there should be a way to
recognise each row of the table uniquely. What does Prabhnoor mean by this way ?
(a) He wants to create a foreign key in each table.
(b) He wants to club fields in a
unique way.
(°) He wants to create a field having a special value in it.
(a) He wants to create a primary key in each table.
e designng the database, Prabhnoor suggested that if in a table there is a field which must take
only those values which are part of a field in another table, (where it can recognise the records
uniquely), then that field must be declared as key.
(a) primary (b) alternate (c) composite primary (d) foreign
