Exam 1: Flashcards
What is meant by the term Von Neumann architecture?
Both data and instructions share the same memory
A single bus for both instructions and data
What is one way Harvard differs from Von Neumann?
Separate memory for data and instructions
What features of a newer processor would increase performance?
Higher clock speed
More cores
What are 3 little man computer values?
10, 60, 200
How would you set the value of a little man computer to zero?
LDA total
SUB total
STA total
HLT
What is pipelining?
One instruction can be fetched while another is being decoded and another is being executed
Completing multiple fetch execute decode cycles at once
Output of 1 instruction is input of another
What is one benefit of using pipelining?
More instructions being carried out in a set amount of time
Increases performance/speed for the program to finish
How is the accumulator used in the fetch execute decode cycle?
Holds all inputs/outputs
Holds results of calculations
How is the program counter used in the fetch execute decode cycle?
Increments by one on each cycle
Holds the address/location of next instruction to be executed
What are three other registers used in fetch decode execute cycle?
Memory address register
Memory data register
Current instruction register
RISC vs CISC AO1?
CISC- complex instruction set, lots of instructions available
RISC- reduced instruction set, small number of instructions available
CISC- more circuits and transistors then RISC so harder to make
RISC-instructions take 1 cycle
RISC vs CISC AO2?
CISC- would run the same software as the desktop machines, more expensive to buy, got to buy cooling units in the phone
RISC- requires software to be written specifically for it, smaller longer lasting battery, do require greater RAM as longer scripts of code
RISC vs CISC AO3?
CISC- save money on software but more expensive
RISC- investment in software but cheaper to invest in, better performance battery wise
What is a primary key?
A unique identifier
What is the foreign key, where is it used?
PackageType
Membership
What data type is a decimal point?
float
What type of data can be said to be boolean?
True/False
What is the structure of a SQL query?
SELECT
FROM
WHERE
ORDER BY