IT 9626 - Sensors

A school has a computerised weather station which monitors a number of atmospheric conditions or variables.

Choose three statement showing how data is collected, processed and displayed using such a system.

• sensor are used to feed data back to a computer

• computer stores readings in a table for processing

• computer outputs the results on screen or printer

• computer plots the graph manually

• digital data converted into computer for processing

Tick three most accurate statements about relational databases.

• duplication of data is avoided saving storage space

• it is easier to produce cross tabular-reports in a relational databases than with flat file database

• tables can be linked using a key field

• the only two possible relationship is one to one or many to many

• there must be at least three tables in a relational database

People who are employed to develop software often refer to the need for a detailed data dictionary.

choose more than two statements that describe the components of a typical data dictionary.

• table name - a unique name for each table in a database

• field name - to identify each field

• keys - primary keys are identified

• field length - the number of data in each field

• validation - checking data security in each field

What should a primary key contain?

• A lot of different values
• A null value
• An unique value

What is a relational database?

• A relational database organizes data into tables, and links them together, based on key-fields. These relationships enable you to retrieve and combine data from one or more tables with a single query
• A relational database arranges data into a tree structure, which is similar to folders and files on a computer. 

What is a flat file database?

• Contains a single table

• Two or more linked tables

• Used to create formula's

Which of the following is not an indicator of a phishing attack?

• A message asking you to open your browser, type the URL of your bank into your browser, and then asking you to log in and verify your account information

• A message requiring immediate action, such as threatening to close down your online account or fining you large amounts of money

• A message claiming to be from an official organization but coming from a Gmail, Yahoo, or Hotmail account

Why is it important to verify whom you are sending an email to when using the auto-complete feature in email?

• You may accidentally send sensitive information to someone who is not authorized to see it

• You may accidentally share details of an event with a friend who is not invited

• You may accidentally delete information that you may need in the future

What is a broad term used for many attacks on computer systems?

• Adware
• Malware
• Ransomeware
• Spyware

Phishing is

• using a fishing pole to catch fish.

• tricking someone into giving out private information.

• pretending to be someone you're not.

• being at high risk of attack or harm