RBC Technical Skills Assessment 5 — Questions and Answers
Question 1: An analyst wants to find all customers whose names start with 'Sm'. Which SQL pattern is correct?
- WHERE name = 'Sm'
- WHERE name LIKE 'Sm%' (Correct answer)
- WHERE name LIKE '%Sm'
- WHERE name IN ('Sm')
Correct answer: WHERE name LIKE 'Sm%'
LIKE 'Sm%' matches any string beginning with 'Sm', where % is a wildcard for any sequence of characters.
Question 2: Which encryption approach uses one key to encrypt data and a different key to decrypt it?
- Symmetric encryption
- Hashing
- Asymmetric encryption (Correct answer)
- Base64 encoding
Correct answer: Asymmetric encryption
Asymmetric encryption uses a public key to encrypt and a corresponding private key to decrypt.
Question 3: A spreadsheet contains sales figures in column B (rows 2–50). Which formula calculates the average of those figures?
- =SUM(B2:B50)
- =COUNT(B2:B50)
- =AVERAGE(B2:B50) (Correct answer)
- =MEDIAN(B2:B50)
Correct answer: =AVERAGE(B2:B50)
The AVERAGE function computes the arithmetic mean of all numeric values in the specified range.
Question 4: In a relational database, a foreign key is used to:
- Uniquely identify each row in its own table
- Encrypt sensitive column data
- Establish a link between two tables (Correct answer)
- Speed up queries on large tables
Correct answer: Establish a link between two tables
A foreign key references the primary key of another table, enforcing referential integrity between related tables.
Question 5: A developer checks application logs and sees an OutOfMemoryError. The most appropriate first step is to:
- Reboot the database server
- Analyze heap usage and check for memory leaks (Correct answer)
- Increase network bandwidth
- Reinstall the operating system
Correct answer: Analyze heap usage and check for memory leaks
An OutOfMemoryError indicates the JVM heap is exhausted; profiling heap usage reveals memory leaks or undersized heap settings.
Question 6: Which Agile ceremony is specifically held to reflect on the team's process and identify improvements for the next sprint?
- Sprint planning
- Daily standup
- Sprint review
- Sprint retrospective (Correct answer)
Correct answer: Sprint retrospective
The sprint retrospective focuses on how the team worked together and what process improvements to apply going forward.
Question 7: A program crashes with a 'division by zero' error. This is an example of which type of error?
- Syntax error
- Compile-time error
- Runtime error (Correct answer)
- Logic error
Correct answer: Runtime error
A division by zero error occurs during program execution, making it a runtime error rather than a compilation issue.
RBC Technical Skills Assessment 5
An analyst wants to find all customers whose names start with 'Sm'.
Which SQL pattern is correct?