CompTIA DataSys+ practice test

A table contains repeating groups of phone numbers stored in a single column for each customer. To bring this table into first normal form, the administrator should:

Which SQL statement is used to retrieve only rows from an orders table where the order total is greater than 500?

A query that filters on a frequently searched column is running slowly because the database performs a full table scan. The most appropriate action to improve performance is to:

A company performs a full backup every Sunday and differential backups on the other days. To restore the database after a failure on Thursday, the administrator must apply:

Granting users only the minimum database privileges necessary to perform their job duties is an application of which security principle?

Two transactions are each waiting for a resource that the other holds, and neither can proceed. This situation is known as a:

A foreign key constraint is defined on the orders table referencing the customers table. This constraint prevents:

A database administrator configures synchronous replication to a standby server in a separate data center. The primary benefit of this configuration is:

When promoting a database schema change from a development environment to production, the recommended practice is to:

Transparent data encryption protects a database primarily by:

A database administrator notices that a server's performance degrades during peak hours. To identify the slowest queries consuming the most resources, the administrator should:

Over time, an index becomes fragmented, reducing query efficiency. The appropriate maintenance task to address index fragmentation is to:

A document-oriented NoSQL database such as one storing JSON documents is most appropriate when:

In disaster recovery planning, the recovery point objective, or RPO, defines:

An administrator needs a result set that includes all rows from the employees table and any matching rows from the departments table, with nulls where no department match exists. The appropriate join is a:

Role-based access control improves database security management by:

In a data warehouse using a star schema, the central fact table typically contains:

Before applying a critical security patch to a production database server, the recommended first step is to:

The most effective technique to prevent SQL injection attacks in an application that queries a database is to: