RBC Technical Skills Assessment 2 — Questions and Answers
Question 1: A SQL query returns duplicate rows. Which clause removes duplicates from the result set?
- GROUP BY
- DISTINCT (Correct answer)
- HAVING
- ORDER BY
Correct answer: DISTINCT
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?
- 70
- 250 (Correct answer)
- 30
- 2.5
Correct answer: 250
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?
- Queue
- Linked list
- Stack (Correct answer)
- Heap
Correct answer: Stack
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?
- Faster CPU processing
- Increased disk I/O due to paging (Correct answer)
- Reduced network latency
- Improved cache hit rate
Correct answer: Increased disk I/O due to paging
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?
- 200
- 301
- 403
- 404 (Correct answer)
Correct answer: 404
HTTP 404 means the server could not find the requested resource.
Question 6: In Excel, which function returns the position of the largest value in a range?
- MAX()
- LARGE()
- MATCH() (Correct answer)
- INDEX()
Correct answer: MATCH()
MATCH() returns the relative position of a value within a range; combining MAX() with MATCH() locates the largest value's position.
Question 7: A developer uses version control and wants to create an isolated workspace to develop a new feature without affecting the main codebase. What should they create?
- A commit
- A tag
- A branch (Correct answer)
- A merge
Correct answer: A branch
A branch creates an independent line of development that does not affect the main codebase until merged.
RBC Technical Skills Assessment 2
A SQL query returns duplicate rows.
Which clause removes duplicates from the result set?