A database administrator needs to ensure that the company's database can be restored to a specific point in time, such as just before an accidental deletion occurred. Which backup strategy should be used?

Copy-only backups taken monthly

Full backups only, taken weekly

Full backups combined with transaction log backups

Differential backups only, taken daily

A company's database is 500 GB. They perform a full backup every Sunday night and differential backups every night. On Thursday, the database fails. The last full backup was Sunday, and the last differential backup was Wednesday. How many backups are needed to restore the database to Wednesday's state?

Four: the Sunday full backup and the Monday, Tuesday, and Wednesday differential backups.

Two: the Sunday full backup and the Wednesday differential backup.

One: the Wednesday differential backup only.

Five: the Sunday full backup and the Monday, Tuesday, Wednesday, and Thursday differential backups.

A new employee, Jane Doe, is being added to the company's employee database. The table 'employees' has columns: employee_id (auto-increment), first_name, last_name, department. Which SQL statement correctly adds Jane to the database?

INSERT INTO employees (employee_id, first_name, last_name, department) VALUES (1, 'Jane', 'Doe', 'Sales');

INSERT INTO employees (first_name, last_name, department) VALUES ('Jane', 'Doe', 'Sales');

INSERT INTO employees VALUES ('Jane', 'Doe', 'Sales');

UPDATE employees SET first_name = 'Jane', last_name = 'Doe', department = 'Sales';

What is the purpose of the WHERE clause in a DELETE statement?

To specify the table from which records are deleted

To specify the new values for the records

To specify the order in which records are deleted

To specify which records should be deleted

CompTIATech+

Domain 5Objective 3

Database Use FC0-U71 Practice Questions (Page 1)

Part of the Data and database fundamentals domain, which accounts for 13% of the FC0-U71 exam. CompTIA does not publish an official question count, but from its 60-minute exam (~25–40 total, ~3–5 in this domain), expect 1–1 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

10concepts

13%of the exam

Questions 1–5

1application · medium
A database administrator needs to ensure that the company's database can be restored to a specific point in time, such as just before an accidental deletion occurred. Which backup strategy should be used?
Select an answer first
2expert · hard
A company's database is 500 GB. They perform a full backup every Sunday night and differential backups every night. On Thursday, the database fails. The last full backup was Sunday, and the last differential backup was Wednesday. How many backups are needed to restore the database to Wednesday's state?
Select an answer first
3application · medium
A new employee, Jane Doe, is being added to the company's employee database. The table 'employees' has columns: employee_id (auto-increment), first_name, last_name, department. Which SQL statement correctly adds Jane to the database?
Select an answer first
4foundation · medium
Which SQL statement is used to modify the values of existing records in a database table?
Select an answer first
5foundation · easy
What is the purpose of the WHERE clause in a DELETE statement?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to FC0-U71

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “FC0-U71” is a trademark of its owner, used for identification only.

Database Use FC0-U71 Practice Questions (Page 1)

Questions 1–5

A database administrator needs to ensure that the company's database can be restored to a specific point in time, such as just before an accidental deletion occurred. Which backup strategy should be used?

A new employee, Jane Doe, is being added to the company's employee database. The table 'employees' has columns: employee_id (auto-increment), first_name, last_name, department. Which SQL statement correctly adds Jane to the database?

Which SQL statement is used to modify the values of existing records in a database table?

What is the purpose of the WHERE clause in a DELETE statement?

Keep studying — Data and database fundamentals