Important Question for ICS Computer Science Part-2, Important notes for ICS computer Science for all Boards and Federal Board.
Chapter-06(Table and Query)
|
1
|
A
one-to-many relationship is created through:
|
|||
|
|
Relationships Wizard
|
New Relationships Command
|
Relationships window
|
Relationship Design Command
|
|
2
|
Which
symbol is placed around dates in criterion?
|
|||
|
|
[]
|
*
|
()
|
#
|
|
3
|
Which
row in Design grid determines the records selected in query:
|
|||
|
|
Show
|
Criteria
|
Field
|
Sort
|
|
4
|
The
result of a query are displayed in a:
|
|||
|
|
Form
|
Design grid
|
Report
|
Dynaset
|
|
5
|
The
graphical query tool is known as:
|
|||
|
|
Query grid
|
Design grid
|
Query form
|
Design form
|
|
6
|
Which
of the following is NOT found in totals function in query?
|
|||
|
|
If
|
Average
|
Sum
|
Group by
|
|
7
|
Which
query is used to join two tables?
|
|||
|
|
SELCT
|
FIND UNMATCHED
|
FIND DUPLICATES
|
CROSSTABLE
|
|
8
|
Which
type of relationship is most common?
|
|||
|
|
One to One
|
One to Many
|
Many to Many
|
Many to One
|
|
9
|
Which
symbol is used at the end of join the line in a related table to signify
“many” side of a one to many relationship?
|
|||
|
|
#
|
M
|
∞
|
*
|
|
10
|
What
is Z to A order called:
|
|||
|
|
Ascending
|
Descending
|
Condescending
|
Alphabetical
|
|
11
|
Find
and replace command is found in:
|
|||
|
|
Edit Menu
|
File Menu
|
Tool
|
View Menu
|
|
12
|
Which
field type can be indexed?
|
|||
|
|
Memo
|
Number
|
Hyperlink
|
OLE
|
|
13
|
Field
properties determine:
|
|||
|
|
Field size
|
Input mask
|
Default value
|
All
|
|
14
|
How
many types of relationship can be used?
|
|||
|
|
2
|
3
|
4
|
5
|
Q-2: Write short answers any TEN, each question
carry 2 marks. 2x10=20
i.
How are records sorted in a query?
ii.
List some advantages of queries.
iii.
Define referential integrity is used?
iv.
List out the types of relationships.
v.
Define sorting.
vi.
Describe the term cascade update.
vii.
Write different options in Find and Replace
dialog box.
viii.
What is the use of input mask?
ix.
What are field validation rules?
x.
Write the uses of design view in MS Access.
xi.
Define the term table in Database.
xii.
What is degree of relation.
xiii.
Define the term cardinality.
Q-3: Write detail answers any 2 from the
following questions. 2x8=16
·
What is table? Write detail about different
parts of a table.
·
Define Primary key. What is the procedure of
applying primary key in MS Access?
·
What is relationship? Explain the procedure of
defining relationship in MS Access.