Nat 5 Computing Science Flashcards
How many bits in a byte?
8
How many bytes in a kilobyte?
1024
How do you write a date in SQL?
With quotation marks. For example: “xx/xx/xx”
What are the two translator types?
Interpreter and compiler
What are the two types of loops?
Fixed and conditional
What are all the vector objects?
- Ellipse
- Rectangle
- Polygon
- Line
What are all the vector object attributes?
- Coordinates
- Line colour
- Fill colour
What are the design process keywords?
- Calculate
- Retrieve
- Validate
What are end user requirements?
End user requirements are what the final users of the database need it to do. For example: Search for dogs based on their breed.
What are functional requirements?
Functional requirements are what the database needs to do, think SQL command words. For example: Insert new details about dogs such as their name and breed.
What are the requirements of GDPR?
- Data is processed fairly, legally and in a transparent manner
- Data is used for the declared use only
- Data must be relevant and limited to the declared purpose only
- Data must be accurate
- Data must be held securely
- Data must not be kept for longer than necessary
Describe an executional error?
An error that occurs when the computer is asked to do something it cannot, such as divide by 0 or store a string as an integer.
What are predefined functions used for?
To save time because you do not need to write as much code. Used for tasks that occur frequently such as round, length or random.
If a user interface is to be used by multiple people what must it have?
A submit button
When referring to a computer’s memory what must you refer to it as?
RAM which has unique addresses
When describing what code does what must you do?
Check the marks and make sure you describe it accordingly
What are all of the computational constructs, there are 8?
- Assigning values - Setting or changing variables
- Returning values using arithmetic operators - Using variables to do calculations
- Concatenating strings - Join two smaller strings into one larger string
- Selection constructs using simple conditional statements - An if statement with a simple condition
- Selection constructs using complex conditional statements - An if statement with a complex condition
- Logical operators - AND, OR and NOT
- Iteration and repetition - Using fixed and conditional loops
- Predefined functions with parameters - Round, length, random
What are the standard algorithms?
- Input validation
- Running total within a loop
- Traversing a 1D array
What are firewalls used for?
A firewall is used to check packets that are coming in and ensure they are coming from a safe source.
What must you show when writing INSERT INTO SQL statements?
All the fields that will be filled
