Virtual Assistant Virtual Assistant Data Entry and Research Skills 3

Question 1

In database terminology, what is a 'master record'?

Accepted Answer

The authoritative, canonical version of a data entity

Answer

A master record is the single trusted source of truth for a data entity; all other copies or references should match it.

Question 2

Which SQL command is used to retrieve specific records from a database table?

Accepted Answer

SELECT

Answer

The SELECT statement queries a database and returns rows matching specified conditions without modifying the data.

Question 3

What problem does 'data normalization' primarily solve in database design?

Accepted Answer

Data redundancy and update anomalies

Answer

Normalization organizes database tables to eliminate redundant data and prevent inconsistencies when records are updated.

Question 4

What is a pivot table primarily used for in spreadsheet software?

Accepted Answer

Summarizing and dynamically analyzing large datasets

Answer

A pivot table lets users quickly group, sum, count, or average large amounts of data and reorganize the view interactively.

Question 5

Which practice best protects data confidentiality when transferring files to a client?

Accepted Answer

Encrypting files and sharing via a secure, password-protected link

Answer

Encrypting files and using password-protected sharing ensures that only the intended recipient can access the data during transfer.

Virtual Assistant Practice Test