Computer Science and IT Quiz Questions

Questions and Answers

What data processing steps are necessary to develop a mobile application that identifies basketball courts in a suburb?

normalised, validated and encrypted

retrieved, modularised and validated

retrieved, normalised and verified

retrieved, normalised and validated (correct)

In a data dictionary, which item type is likely to be stored as a float?

quantity

numSold

shoeID

wholesalePrice (correct)

What is the purpose of data normalisation?

to ensure data consistency (correct)

to remove duplicates

to encrypt sensitive data

to reduce storage space

What SQL query will return the name and mean temperature of planets with a diameter less than 50,000?

SELECT Name, MeanTemperature FROM Planets WHERE Diameter < 50000 ORDER BY MeanTemperature DESC Signup and view all the answers

What is the benefit of using an open data set?

access to a wide range of data Signup and view all the answers

What is the purpose of data validation?

to check for errors in data Signup and view all the answers

What encryption method uses a private and public key to secure data during transmission over the internet?

RSA Signup and view all the answers

Which usability principle is demonstrated by screen-based user interfaces that dynamically adjust for different screen sizes?

utility Signup and view all the answers

What is the primary cause of a long delay between asking a question and receiving a response during a video call?

latency Signup and view all the answers

Which encryption method uses a fixed shift of letters down the alphabet with a modulus operation?

Caesar Signup and view all the answers

What is the relationship between JSON and REST?

JSON is a format used to exchange data through REST architecture Signup and view all the answers

1 BEGIN 2 INPUT firstNum 3 INPUT secondNum 4 FOR i = 1 TO firstNum 5 FOR j = 1 TO secondNum 6 CALCULATE result = i * j 7 OUTPUT i "*" j "=" result 8 ENDFOR 9 ENDFOR 10 END

How many times would line 6 of the given algorithm be executed if the user inputs firstNum = 6 and secondNum = 10?

60 Signup and view all the answers

What is the purpose of the FOR loops in the given algorithm?

To iterate over the input values Signup and view all the answers

What is the output format of the given algorithm?

A string in the format 'i * j = result' Signup and view all the answers

Study Notes

Encryption

RSA uses a private and public key to secure data during transmission over the internet.
Caesar encryption method uses a fixed shift of letters down the alphabet with a modulus operation.

User Interface

Screen-based user interfaces must dynamically adjust for different screen sizes because devices have different aspect ratios and dimensions, demonstrating the useability principle.
Arranging and organising UI elements demonstrates the principle of visual communication.

Networking

Latency can cause delays in video calls, such as a long delay between asking a question and responding.
Jitter is not the primary cause of delays in video calls.

Data Exchange

JSON is a format used to exchange data through REST architecture.
JSON is not a format used to exchange data with XML.

Algorithm

The algorithm outputs a data set according to values a user inputs, with a nested FOR loop structure.
The number of times a line is executed depends on the input values.

Data Analysis

An open data set contains plain text, requiring data to be retrieved, normalised, and verified for use in a mobile application.
Normalising, validating, and encrypting data is not necessary for developing a mobile application.

Data Types

In a data dictionary, numeric item types include quantity and wholesalePrice, which would be stored as a float.

SQL Queries

A SQL query can return specific data from a database, such as the name and mean temperature of planets with a diameter less than 50,000, ordered in descending order of mean temperature.
The correct syntax for the SQL query involves using the WHERE and ORDER BY clauses correctly.