RBC Technical Skills Assessment 2

Question 1

A SQL query returns duplicate rows. Which clause removes duplicates from the result set?

Accepted Answer

DISTINCT

Answer

The DISTINCT keyword eliminates duplicate rows from a SELECT result set.

Question 2

In a spreadsheet, cell A1 contains 50 and cell B1 contains 20. What does the formula =A1/B1*100 return?

Accepted Answer

250

Answer

Division and multiplication are evaluated left to right: 50/20 = 2.5, then 2.5×100 = 250.

Question 3

Which data structure processes elements in Last-In, First-Out (LIFO) order?

Accepted Answer

Stack

Answer

A stack follows LIFO — the most recently added element is the first one removed.

Question 4

An analyst notices that RAM usage is consistently at 95%. What is the most likely performance impact?

Accepted Answer

Increased disk I/O due to paging

Answer

When RAM is nearly full, the OS swaps data to disk (paging), which dramatically slows performance.

Question 5

Which HTTP status code indicates that a requested resource was not found on the server?

Accepted Answer

404

Answer

HTTP 404 means the server could not find the requested resource.

RBC - Online Assessment Practice Test