RBC Technical Skills Assessment 5

Question 1

An analyst wants to find all customers whose names start with 'Sm'. Which SQL pattern is correct?

Accepted Answer

WHERE name LIKE 'Sm%'

Answer

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?

Accepted Answer

Asymmetric encryption

Answer

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?

Accepted Answer

=AVERAGE(B2:B50)

Answer

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:

Accepted Answer

Establish a link between two tables

Answer

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:

Accepted Answer

Analyze heap usage and check for memory leaks

Answer

An OutOfMemoryError indicates the JVM heap is exhausted; profiling heap usage reveals memory leaks or undersized heap settings.

RBC - Online Assessment Practice Test