Page 1045 - SUBSEC October 2017_Neat

- 7 -

44. Which of the following is an example of 48. Which database feature can be used to
a spreadsheet function? list the names of the male students from
a particular class?
(A) function sum(A1, A2, A3)
(B) sum = A1 + A2 + A3 (A) Table
(C) = sum(A1:A3) (B) Form
(D) = A1 + A2 + A3 (C) Query
(D) Report

45. Which type of application is BEST suited
to prepare a budget? 49. What is the MOST appropriate database
data type for a field holding the marks from
(A) Database a class test?
(B) Spreadsheet
(C) Word processor (A) Text
(D) Desktop publishing (B) Numeric
(C) Currency
(D) Date/Time
46. Which of the following statements is NOT
true of primary keys?
50. What is the name given to a collection of
(A) They are unique identifiers. related fields in a database?
(B) They are always in text form.
(C) They do not contain blank (A) Table
values. (B) Field
(D) They may be composed of one (C) Record
or more attributes. (D) Column

47. A field in a table that appears as a match 51. The following variables s, t and u, have
of the primary key in another table is been assigned the values shown.
called a
s = 5
(A) foreign key t = 6
(B) candidate key u = 3
(C) secondary key
(D) composite key Which of the following statements does
NOT evaluate to true?

(A) u > 7 and t < = 7
(B) s < t or u =< s − 2
(C) t <> 4 or s = 5
(D) u – 2 >= 1

GO ON TO THE NEXT PAGE
01229010/CSEC/SPEC 2017