Back to Dashboard

2.2 Programming Fundamentals

Definitive 21-Question Sequence | Violet Tier Diagnostics

Question 1 2 Marks

[Danger Zone] Real vs Float: Identify the correct J277 data type for a variable storing `15.5` and justify.

Question 2 2 Marks

Calculate the result of the following ERL operations:

17 MOD 5
17 DIV 5
Question 3 2 Marks

Evaluate the output of the following string operations on:
phrase = "Computer Science"

phrase.left(4)
phrase.substring(9, 3)
Question 4 3 Marks

[SQL Grid Scan]: Write an SQL statement to retrieve the names of all students who scored more than 80 from the Results table.

SELECT
FROM
WHERE
Question 5 2 Marks

[Boolean Selector Trap]: Identify the error in the following condition:

if room == "Single" or "Double" then
Question 6 3 Marks

Complete the function scaffold. It must return double the input val.

function doubleUp(val)
  result =
   result
endfunction
Question 7 2 Marks

[Array 0-Indexing]: Given the array items = ["Apple", "Banana", "Cherry"], state the index of "Cherry" and explain why.

Question 8 1 Mark

Identify the SQL wildcard used to select all columns from a table.

Question 9 2 Marks

Describe what a 2D Array represents in real-world data storage.

Question 10 2 Marks

Explain the difference between a Function and a Procedure.