Nat 5 Computing Science Flashcards
(25 cards)
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.
What is the difference between a flowchart and structure diagram?
A structure diagram doesn’t have any parallelograms.
Is character a data type?
Yes
What is the exam process?
- Read the question fully twice.
- Double check all calculations.
- Get an understanding of their pseudocode/code before writing.
- Check my pseudocode/code.
* Declare all variables at the start.
* Check loops run the right amount of times.
* Check all values are correct including booleans.
* Make sure any indexes begin at 0
* Check all operators are correct.
* Ensure it is efficient and legible. - Be detailed and clear.
- Check for all ASC or DESC and add “;”.
- Check all variable and table names are correct.
What is the exam proccess
- Read the question fully twice highlighting key words.
- Double check all calculations.
- Get an understanding of their pseudocode/code before writing.
- Check my pseudocode/code.
* Declare all variables at the start.
* Check loops run the right amount of times.
* Check all values are correct including booleans.
* Make sure any indexes begin at 0
* Check all operators are correct.
* Ensure it is efficient and legible. - Be detailed and clear.
- Check for all ASC or DESC and add “;”.
- Check all variable and table names are correct, use the different fonts to identify them.
