SQL
What must a query end with?
A semi-colon
What is a database
An organised collection of structured information
What must be at the beginning and end of pseudocode
a BEGIN/START and END
What are is APP
Australian Privacy Principles
What is a protocol?
A set of rules that allow communication
What function is used to return unique records
DISTINCT
What is a foreign key?
A field that relates to a primary key in another field
How many indentations total should their if a piece of pseudocode only has a single if statement?
2
What is meant by anonymity
Anonymity means that an individual cannot be identified, and the entity does not collect personal information or identifiers.
What does URL stand for
Universal Resource Locator
What data type does HAVING return
Boolean
What is meant by normalisation
Organising data in a database to remove redundancy and protect data
subfunction()
What are the three objectives of security
maintaining confidentiality, integrity, and availability.
What are the 4 main Transmission Principles?
Latency, Jitter, Guarantee, Timeliness of delivery
What is the purpose of an INNER JOIN
To join two tables and return records in both of them based on criteria
With a 1:many uniqueness constraint, what causes the uniqueness
The many column
What is the correct format of an IF statement?
IF cond THEN
....
ELSEIF cond THEN
....
ELSE
....
END IF
What is meant by dissemination?
The process by which producers of microdata from surveys and from public and official statistics make their data available to other users.
What is SHA?
Secure Hash algorithms
What would you write to finding words starting with letters after g
What is a transitive dependency?
When there is an indirect relationship between values in the table. If a relates to b and b relates to c then a relates to c.
What encryption method is regarded as mostly impervious to attack except for brute force?
Advanced Encryption Standard
What are the 7 OSI layers
Physical, Datalink, network, transport, session, presentation, application.