Computer Science and IT Quiz Questions

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

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

What is the purpose of data normalisation?

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

What is the benefit of using an open data set?

What is the purpose of data validation?

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

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

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

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

What is the relationship between JSON and REST?

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?

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

What is the output format of the given algorithm?

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.