NIS_G12_CS_02_5RP_AFP


Чтобы посмотреть этот PDF файл с форматированием и разметкой, скачайте его и откройте на своем компьютере.
This document consists of
printed pages and
blank pages.
NIS_G12_CS_02/5RP
Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
[Turn over

10
Total
AEO Nazarbayev Intellectual Schools
Cambridge International Examinations
COMPUTER SCIENCE
May 2016
2 hours
Candidates answer on the Question Paper.
No additional materials are required.
12CSCI/02
READ THESE INSTRUCTIONS FIRST
Write Centre number and candidate number
in the spaces at the top of the page.
Write in dark blue or black pen.
Do not use staples, paper clips, glue or correction fluid.
WRITE IN ANY BARCODES.
Answer
questions.
The number of marks is given in brackets [ ] at the end of each question or part
question.
You should show all your working.
The total number of marks for this paper is 70.
Answer all questions in English.
Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
Examiner's
A CPU manufacturer describes an older device as having 32-bit registers. Its newer device
has 64-bit registers.
(a)
What is the word length in the newer CPU?
Suggest
reasons why they have increased the size of the register. You should refer
Describe the

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
[Turn over
Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
Examiner's
Field Data type
ProductID (primary key) String
Description String
Price Decimal
(a)
Write a SQL statement which will select the product description and price for all
the products that cost more than 5000 tenge.
(b)
The database also has a CUSTOMER table and an ORDER table with the following
definitions.
CUSTOMER
ORDER
Field Data type
Field Data type
CustomerID (primary key) String
OrderID (primary key) String
Name String
CustomerID String
ProductID String
OrderDate Date/Time
Explain the meaning of the term
. Refer to the
tables PRODUCT,
CUSTOMER and ORDER in your answer.

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
[Turn over
Examiner's
(c)
(d)
Write a suitable definition for a new table which allows the company to keep a record of
all product prices over time. It should include a composite primary key.

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
Examiner's
A computer programmer needs a data structure to store the following data:
O
(a)
Name the data structure. State how to store these data.
(b)

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
[Turn over
Examiner's
example of a declarative programming language.
(b)
Name
example of an imperative programming language.
(c)
The Java language is partially compiled and partially interpreted.
Briefly explain what this means.

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
Examiner's
Listed below are two reasons for using CSS in a web site. For each reason, briefly
Using CSS avoids code duplication.
Using CSS makes it easier to maintain the content of a website.
(b)
Explain how the use of CSS enables a single code change to affect a whole website.
Give an example.

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
[Turn over
Examiner's
(b)
(c)

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
Examiner's

(b) A user can enter -99 alone.
Name the type of error which would then occur.
(ii)
Briefly describe how a programmer could prevent this.

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
[Turn over
Examiner's
(b)
POP3 and SMTP are two protocols
two
features of
each protocol.
POP3
SMTP

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
Examiner's
Briefly explain the term
virtual machine
. You should include an example of the use of a
virtual machine.
(b)
(c)
Explain why pipelining is important in the design of a RISC processor.

Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
Examiner's
Some companies are now producing cars which do not need drivers.
Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
BLANK PAGE
Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
BLANK PAGE
Permission to reproduce items where third-party owned material pr
otected by copyright is included has been sought and cleared w
here possible. Every
reasonable effort has been made by the publis
her (UCLES) to trace copyright holders,
but if any items requiring clearance have
unwittingly been included, the
publisher will be pleased to make amends
at the earliest possible opportunity.
Cambridge International Examinations is par
t of the Cambridge Assessment Group. Cambri
dge Assessment is t
he brand name of Unive
rsity of Cambridge Local
Examinations Syndicate (UCLES), which is itself
a department of the University of Cambridge.
Center for Pedagogical Measurements
AEO Nazarbayev Intellectual Schools 2016
NIS/G12/CS/02
BLANK PAGE

Приложенные файлы

  • pdf 9485789
    Размер файла: 756 kB Загрузок: 29

Добавить комментарий