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

The largest file stored on the server

Answer

A temporary staging record before import

Answer

The most recently modified record

Question 2

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

Accepted Answer

SELECT

Answer

INSERT

Answer

DELETE

Answer

DROP

Question 3

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

Accepted Answer

Data redundancy and update anomalies

Answer

Slow query performance due to too many indexes

Answer

Large file sizes caused by media attachments

Answer

Unauthorized user access

Question 4

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

Accepted Answer

Summarizing and dynamically analyzing large datasets

Answer

Sending formatted reports by email automatically

Answer

Converting spreadsheets to presentation slides

Answer

Applying conditional formatting rules

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

Sharing via a public link without a password

Answer

Sending as a plain text email attachment

Answer

Printing and mailing physical copies

Question 6

What is 'data deduplication' in database or list management?

Accepted Answer

Identifying and removing duplicate records to maintain data integrity

Answer

Creating redundant backup copies of critical records

Answer

Archiving inactive records to cold storage

Answer

Compressing large files to save disk space