RBC Technical Skills Assessment 3

Question 1

Which Excel function counts only the cells in a range that meet a specific condition?

Accepted Answer

COUNTIF()

Answer

COUNTIF() counts cells within a range that satisfy a given criterion.

Question 2

A network engineer needs to divide a single IP network into multiple smaller subnetworks. This process is called:

Accepted Answer

Subnetting

Answer

Subnetting divides a large IP network into smaller, more manageable sub-networks.

Question 3

In object-oriented programming, what allows a subclass to provide a specific implementation of a method already defined in its parent class?

Accepted Answer

Overriding

Answer

Method overriding lets a subclass replace the parent's method implementation with its own version.

Question 4

A database table has 10,000 rows and a query without a WHERE clause returns all rows. Adding an index on a frequently filtered column will most likely:

Accepted Answer

Slow writes slightly but speed up filtered reads

Answer

Indexes speed up read queries on indexed columns but add slight overhead to write operations.

Question 5

Which number system uses only the digits 0 and 1?

Accepted Answer

Binary

Answer

The binary (base-2) number system represents all values using only 0 and 1.

RBC - Online Assessment Practice Test

RBC - Online Assessment Practice Test

RBC Technical Skills Assessment 3