Unit 4 Data Management and Cyber Security: WACE Computer Science ATAR practice quiz

A field that uniquely identifies each row in its own table

A field that references the primary key of another table

A field that stores data in an encrypted form

A field that joins two attributes into one value

Values must be atomic (1NF)

No transitive dependencies (3NF)

Every table needs a foreign key

No partial dependencies (2NF)

SELECT CustomerID, COUNT(*) FROM Orders GROUP BY CustomerID;

SELECT CustomerID, COUNT(*) FROM Orders;

SELECT CustomerID, SUM(CustomerID) FROM Orders GROUP BY CustomerID;

SELECT COUNT(CustomerID) FROM Customers ORDER BY CustomerID;

WHERE

ORDER BY

HAVING

JOIN

Referential integrity

Entity integrity

Domain integrity

Physical integrity

Consistency

Isolation

Durability

Atomicity

Alice's private key

Bob's public key

Bob's private key

Alice's public key

By encrypting the whole message with the receiver's public key

By hashing the message with a secret salt stored on the server

By encrypting a hash of the message with the sender's private key

By sending the sender's password alongside the message

Symmetric keys never need to be exchanged

Asymmetric encryption cannot protect traffic

Certificates expire when the handshake ends

Symmetric encryption is much faster for bulk data

Installing antivirus software on every client

Using parameterised queries

Enforcing longer passwords for users

Encrypting the database backups

Availability

Confidentiality

Integrity

Authentication

Authentication

Authorisation

Accounting

Availability

Publish it so that people can check it is correct

Store it only on servers located in Australia

Delete it within 30 days of collecting it

Take reasonable steps to protect it from misuse and loss