Virtual Assistant Data Entry and Research Skills Flashcards

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

Answer: The authoritative, canonical version of a data entity

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

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

Answer: SELECT

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

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

Answer: Data redundancy and update anomalies

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

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

Answer: Summarizing and dynamically analyzing large datasets

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

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

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

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

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

Answer: Identifying and removing duplicate records to maintain data integrity

Data deduplication finds and eliminates exact or near-identical records, ensuring each entity appears only once in the dataset.