EXAM

Question 1

What do you have to do when you store something in LMC

Answer 1

You have to store it into a memory address with an integer value between 1 and 99

Question 2

FIVE DAT 5 or 5 DAT FIVE

Answer 2

FIVE DAT 5

Question 3

What should you do when branching in LMC

Answer 3

Put your first instruction on the same line as the line for example POSITIVE LDA X all needs to be on the same line

Question 4

How do you declare a 1d array pseudocode(first way)?

Answer 4

array names[3]
names[0] = “Ahmad”
names[1] = “Ben”
names[2] = “Catherine

Question 5

How do you declare a 1d array pseudocode(second way)?

Answer 5

array names[3] = [“Ahmad”, “Ben”, “Catherine”]

Question 6

First way to declare 2d array

Answer 6

array scores[2][2]
scores[0][0] = 14
scores[0][1] = 80
scores[1][0] = 20
Scores[1][1] = 82

Question 7

Second way to declare 2d array

Answer 7

array scores[2][2] = [[14, 80],[20, 82]]

Question 8

How many elements would be in the array chores[3][3]

Answer 8

9

Question 9

How to delete whole rows from sql

Answer 9

Do not use a where clause so all values will be deleted

Question 10

How to delete specific rows from sql

Answer 10

Use where clause to specify conditions that need to be met

Question 11

Can you delete specific columns from sql

Answer 11

No

Question 12

What do you need to remember

Answer 12

How many bits to use

Question 13

Two’s comp

Answer 13

First bit is negative if it is 1

Question 14

Sign and mag

Answer 14

First bit just determines wether it is pos or negative

Question 15

Subtracting values tc

Answer 15

Convert the right one to other sign

Question 16

Adding negatives values

Answer 16

Do it normally

Question 17

When talking about what a queery does, what do you say

Answer 17

From “whatever the table is called” and then put what it returns

Question 18

How do you select multiple atributes in SQL

Answer 18

Put a comma between them

Question 19

How do you delete a table

Answer 19

DROP TABLE Students

Question 20

How do you delete a database

Answer 20

DROP DATABASE GuestHouse

Question 21

Can you do OR in SQL

Answer 21

Yes

Question 22

Can you do AND in SQL

Answer 22

Yes

Question 23

How to do like

Answer 23

WHERE City LIKE “Ber%”, this means it stars with Ber, if it was before it would end in Ber and if it was on either side it would contain Ber

Question 24

In the select clause, what do you do when there is two tables

Answer 24

Customers.FirstName, Orders.OrderDate

Question 25

What do you put in the WHERE clause when you are joining tables (inner)

Answer 25

WHERE Customers.CustomerID = Orders.CustomerID

Question 26

How do you do a nested select

Answer 26

Question 27

What is normalisation?

Answer 27

The process of structuring the data in a relational database according to formal rules, in order to avoid problems of data redundancy which leads to inconsistency and inaccuracy.

Question 28

What is the aim of normalisation?

Answer 28

The aim of normalisation is to minimize data redundancy and maximise data integrity

Question 29

What do you do for first normal form?

Answer 29

Each record (row) is unique i.e. it has a primary key Each field (column) has an unique name There are no fields with repeated or similar data e.g. choice1, choice2, choice3... Each field cannot be broken down any further e.g. addresses should be broken up

Question 30

What does first normal form do?

Answer 30

Makes all the data atomic

Question 31

What does atomic mean?

Answer 31

Atomic means each item of data is distinct and you can't separate the data any more or break it up any smaller without losing meaning.

Question 32

What does second normal form do?

Answer 32

Non-key fields must depend on every part of the primary key In other words, if a field that isn't the primary key depends on only one part of the primary key (i.e. a partial key dependency) then it isn't in second normal form.

Question 33

When would you not need to do anything for second normal form?

Answer 33

If you don't have any composite primary keys

Question 34

Passing a parameter by value

Answer 34

A copy of the variable is passed where it is treated as a local variable to project the value being changed

Question 35

Passing a parameter by reference

Answer 35

The reference to the memory location is passed so the value can be changed

Question 36

What can't be passed by reference?

Answer 36

Literal values as there is no reference

Question 37

What will happen if ref or val is not stated

Answer 37

It will be passed by value

Question 38

What is bad about value

Answer 38

It uses additional memory space

Question 39

What is abstraction?

Answer 39

Removing unnecessary details from a problem to focus on the details are are needed which makes the problem easier to solve

Question 40

Example of abstraction

Answer 40

Underground tube maps as they leave out above ground landmarks and roads as that is not relevant to travelling on the tube

Question 41

Why would a man who works in an office use a usb

Answer 41

To transfer data between his home and work computer

Question 42

Man in office Hard drive

Answer 42

Used to store data on work computer as generally companies would use hard drives as they are cheaper especially because multiple devices have to be provided

Question 43

Man in office ssd

Answer 43

For home computer

Question 44

What are two of the gaps you need to fill in the gap fill exercise

Answer 44

13 and position

Question 45

Why does passing something be reference require less storage

Answer 45

Because A copy does not have to be made

Question 46

What is another advantage of passing by value

Answer 46

Value is good as if there is a logical error it wont affect code

Question 47

Why would passing my reference be used here

Answer 47

there wasnt a point where you could accidentally override the player so no need to pass by value to use less storage

Question 48

Another advantage of abstraction

Answer 48

Requires less computing power as details are removed

Question 49

Example 1 of abstraction furniture

Answer 49

Only one room will be customisable at a time so the computer does not have to render the other rooms

Question 50

Example 2 of abstraction furniture

Answer 50

Textures for carpet/floor and cieling dont have to be loaded

Question 51

first two positives of waterfall model

Answer 51

Lots of documentation, does not require a lot of customer involvement

Question 52

Second two positives of waterfall model

Answer 52

Easy to schedule and arrange tasks and judge progress, Simple and easy to understand model

Question 53

First two negatives of waterfall model

Answer 53

Lots of documentation, efficient code is not prioritized

Question 54

Second two negatives of waterfall model?

Answer 54

No new ideas can be included during development, Users not involved until testing

Question 55

When might waterfall model be used?

Answer 55

Straight forward projects where requirements are known and understood at the beginning and do not change, When there is no benefit to the customer of having parts of the system available early and Short projects

Question 56

What is the waterfall model?

Answer 56

A linear, sequence of stages. Each stage is completed before the next stage begins. Good for small, simple projects where requirements are clear and do not change.

Question 57

first normal form

Answer 57

Each row is unique, data is atomic and no fields taht represent a group of data

Question 58

What does it mean if data is atomic

Answer 58

Atomic means each item of data is distinct and you can’t separate the data any more or break it up any smaller without losing meaning.

Question 59

Second normal form?

Answer 59

Data is in first normal form Non-key fields must depend on every part of the primary key (no partial dependencies)

Question 60

Why wasn't it in thirds normal form?

Answer 60

3nf as destination name relies on destination code which isnt the primary key

Question 61

What are the three stages of an LOR?

Answer 61

Knowledge and Understanding, Application, Evaluation