WorksheetsA Level Yr 13 01
Total questions: 27
Worksheet time: 41mins
CPU stands for?
Computer Programming Unit
Central Programming Unit
Central Processing Unit
Central Processor Unit
Central (a) Unit
What type of device is this
Input
Storage
Processing
Output
A ---- is a programming construct that executes instructions in a specific order.
(a)
Using sign and magnitude, denary +12 is (a) in binary as an 8 bit number
Using sign and magnitude, denary -12 is (a) in binary as an 8 bit number
Denary +18 is (a) in two's complement binary. Use 8 bits
Denary -18 is (a) in two's complement binary. Use 8 bits
Convert the hexadecimal value B7E to a binary number (a) . No spaces
110010101 is a binary number that is represented using sign and magnitude. Convert this binary number to a denary number
(a)
Complete this binary subtraction. Both numbers are 8 bit integer values represented using two's complement
(a)
The normalised floating point number 1010 1110 is stored using 4 bit mantissa and 4 bit exponent, both in two's complement, give the denary version of this number
(a)
The normalised floating point number 1010 1111 is stored using 4 bit mantissa and 4 bit exponent, both in two's complement, give the denary version of this number
(a)
The normalised floating point number 0111 0010 is stored using 4 bit mantissa and 4 bit exponent, both in two's complement, give the denary version of this number
(a)
The normalised floating point number 011010 000100 is stored using 6 bit mantissa and 6 bit exponent, both in two's complement, give the denary version of this number
(a)
Which LMC instructions will change the contents of the Program Counter
BRA
BRZ
BRP
STA
Which LMC register stores the results of a ADD operation
(a)
Which compression method would be particularly good for large image areas of the same colour pixel
(a)
(a) encoding uses a list of words and an index pointer to store only one copy of the word
A table is in _ normal form if it contains no repeating attributes or groups of attributes
All attributes must be atomic – a single attribute cannot consist of two data items such as firstname and surname
first
second
third
none
A table is in _ normal form if it contains repeating attributes or groups of attributes
All attributes must be atomic – a single attribute cannot consist of two data items such as firstname and surname
first
second
third
none
A table is in ____ normal form if it is in ____ normal form
and contains no partial dependencies
third, second
first, second
second, second
second, first
All attributes are dependent on the key, the whole key and nothing but the key. This is a definition of (a) normal form
Product (productID, title, subject, level, price)
What does the underline represent
foreign key
primary key
abstract key
composite key
A ?????? key is an attribute that creates a join
between two tables (relations)
(a)
???? integrity means that no foreign key in one table can reference a non-existent record in a related table
(a)
What is a class
A template which inherits attributes and overrides methods
A template which inherits attributes and methods
A template for an class which defines its attributes and methods
A template for an object which defines its attributes and methods
