FC0-U71 Practice Test 25 — 15 Questions

Question 1

A database administrator needs to retrieve, update, and delete records from a customer table. Which THREE SQL commands are required? (Select THREE.)

Accepted Answer

DELETE. The scenario requires three distinct operations: retrieving, updating, and deleting records. SELECT [CORRECT] is the SQL Data Manipulation Language (DML) command used to retrieve/query rows from the customer table, satisfying the 'retrieve' requirement. UPDATE [CORRECT] is the DML command that modifies existing column values in rows of the customer table, satisfying the 'update' requirement. DELETE [CORRECT] is the DML command that removes rows from the customer table, satisfying the 'delete' requirement. INSERT (A) is not needed because the task does not mention adding new records, and CREATE (D) is a Data Definition Language (DDL) statement used to create database objects such as tables, not to manipulate data.

Answer

INSERT

Answer

CREATE

Question 2

Which of the following software licenses allows users to modify and redistribute the source code, provided they keep the same license terms?

Accepted Answer

GNU General Public License (GPL). The GNU General Public License (GPL) is a copyleft license that requires derivative works to be distributed under the same license terms. This means users can modify and redistribute the source code, but they must keep the same license, ensuring that the software remains free and open source.

Answer

Apache License

Answer

Commercial License

Answer

MIT License

Question 3

A small office has five desktop computers that need to be connected to share files and a printer. Which network device should be used to create a local area network?

Accepted Answer

Switch. A switch is the correct device because it operates at Layer 2 of the OSI model, using MAC addresses to forward frames only to the specific port where the destination device is connected. This creates a dedicated, collision-free path between any two communicating devices, which is essential for a small office LAN where five computers need to share files and a printer efficiently.

Answer

Hub

Answer

Modem

Answer

Router

Question 4

Which of the following best describes the difference between a compiler and an interpreter?

Accepted Answer

A compiler translates the entire source code into machine code before execution; an interpreter executes code line by line.. A compiler translates the entire source code into machine code before execution, producing a separate executable. An interpreter translates and executes source code line by line at runtime. Compiled programs generally run faster at execution because translation is done ahead of time. Therefore, option C is correct. Option A confuses development speed (no separate compile step) with execution speed. Option B reverses the two definitions, and option D incorrectly describes when syntax checking occurs.

Answer

Compiled programs run slower than interpreted programs.

Answer

A compiler executes code line by line; an interpreter translates the entire program at once.

Answer

A compiler checks for syntax errors at runtime; an interpreter checks at compile time.

Question 5

A mobile app developer wants to integrate weather data into an app. The developer uses an HTTP request to a web service that returns JSON data. The web service requires an API key in the request header for authentication. What is this web service an example of?

Accepted Answer

REST API. This web service is a REST API because it uses HTTP requests to access and manipulate resources, returns data in JSON format, and requires an API key in the request header for authentication. REST APIs are stateless and rely on standard HTTP methods (GET, POST, etc.), making them ideal for integrating external data like weather information into mobile apps.

Answer

GraphQL API

Answer

WebSocket

Answer

SOAP API

Question 6

Which of the following SQL statements will add a new row to the 'Products' table?

Accepted Answer

INSERT INTO Products VALUES ('Widget', 10.99). The SQL INSERT statement is the standard Data Manipulation Language (DML) command used to add new rows to a table. The syntax INSERT INTO Products VALUES ('Widget', 10.99) inserts a new row with the specified values into the Products table, assuming the column order matches the table definition. This is the correct and ANSI-standard way to add data.

Answer

UPDATE Products SET name='Widget', price=10.99

Answer

CREATE ROW IN Products ('Widget', 10.99)

Answer

ADD INTO Products VALUES ('Widget', 10.99)

Question 7

A sales database has a Customers table with CustomerID as the primary key and an Orders table that includes CustomerID. Which type of relationship is typically established between Customers and Orders?

Accepted Answer

One-to-many. A single customer can place many orders, but each order belongs to exactly one customer, which is the definition of a one-to-many relationship. The CustomerID foreign key in the Orders table references the primary key in Customers, enforcing that each order is tied to one customer while allowing a customer to have multiple orders.

Answer

One-to-one

Answer

Many-to-many

Answer

Unrelated

Question 8

A small business uses a MySQL database to manage inventory and sales. The database has two tables: Products (ProductID, ProductName, QuantityInStock) and Sales (SaleID, ProductID, QuantitySold, SaleDate). The business runs a nightly script that updates QuantityInStock by subtracting QuantitySold from the Products table based on the day's sales. Recently, the inventory levels have become inaccurate. For example, a product shows negative stock even though no sales occurred that day. The database administrator suspects the issue is related to how transactions are handled. The nightly script runs multiple UPDATE statements in a loop. If the script fails partway through, some products' stock is updated while others are not, leaving inconsistent data. The administrator wants to ensure that either all updates succeed or none do, and that the script does not interfere with daytime operations. Which action should the administrator take?

Accepted Answer

Wrap all UPDATE statements in a single transaction with READ COMMITTED isolation level and add error handling to roll back on failure. Wrapping all UPDATE statements in a single transaction with READ COMMITTED isolation level ensures atomicity: either all updates commit or none do, preventing partial updates. Adding error handling with a rollback on failure guarantees that if the script fails partway through, the entire transaction is undone, leaving the database consistent. READ COMMITTED isolation prevents dirty reads and minimizes locking, reducing interference with daytime operations.

Answer

Use a stored procedure that updates all products in one statement without error handling

Answer

Increase the frequency of the script to run every hour with smaller batches

Answer

Remove the transaction and use individual UPDATE statements with error logging

Question 9

Refer to the exhibit. A user executes: SELECT AVG(Salary) FROM Employees; What is the result?

Accepted Answer

55000. The AVG function calculates the arithmetic mean of the Salary column across all rows in the Employees table. Given the salaries 50000, 60000, and 55000, the average is (50000 + 60000 + 55000) / 3 = 55000. Therefore, option A is correct.

Answer

50000

Answer

165000

Answer

60000

Question 10

An organization issues smartphones to employees and needs to enforce security policies such as remote wipe and mandatory encryption. Which technology should be used to manage these devices centrally?

Accepted Answer

MDM. Mobile Device Management (MDM) is the centralized platform for enrolling, configuring, and securing employee smartphones. It enforces policies such as mandatory encryption, passcode requirements, and remote wipe, and it can push configuration profiles and certificates to devices over the air. VPN, NAT, and DNS do not provide device policy enforcement or remote management capabilities.

Answer

VPN

Answer

NAT

Answer

DNS

Question 11

Based on the exhibit, which device is the default gateway?

Accepted Answer

192.168.1.1. The default gateway is the IP address of the router that connects the local network to other networks. In the exhibit, the computer's IP configuration shows a default gateway of 192.168.1.1, which is the router's interface on the same subnet. This address is used by the computer to send traffic destined for IP addresses outside its own subnet (e.g., the internet).

Answer

The computer itself

Answer

255.255.255.0

Answer

192.168.1.10

Question 12

A database administrator notices that a transaction that updates two tables is failing halfway, leaving data inconsistent. Which property of ACID ensures that the database returns to its original state if the transaction fails?

Accepted Answer

Atomicity. Atomicity (option D) ensures that a transaction is treated as a single, indivisible unit of work. If any part of the transaction fails (e.g., updating the second table), the entire transaction is rolled back, and the database returns to its original state before the transaction began. This prevents partial updates that would leave data inconsistent.

Answer

Consistency

Answer

Durability

Answer

Isolation

Question 13

A development team is using version control for their project. They need to isolate a new feature from the main codebase until it is complete. Which version control operation should they perform?

Accepted Answer

Branch. Branching creates a separate line of development within a version control system (e.g., Git, Mercurial), allowing the team to work on a new feature in isolation without affecting the main codebase (often called 'main' or 'master'). Once the feature is complete and tested, the branch can be merged back. This directly addresses the requirement to isolate work until it is finished.

Answer

Merge

Answer

Commit

Answer

Push

Question 14

A security administrator wants to protect data at rest on a laptop that may be lost or stolen. Which of the following is the BEST solution?

Accepted Answer

Enable full disk encryption. Full disk encryption (FDE) protects data at rest by encrypting the entire volume, so if the laptop is lost or stolen the data is unreadable without the decryption key. This directly addresses the threat of physical device compromise, which is the scenario described.

Answer

Use a VPN when connecting to the internet

Answer

Install a host-based firewall

Answer

Implement strong password policies

Question 15

A database designer wants to ensure that every value in a column called 'Status' is either 'Active', 'Inactive', or 'Pending'. Which type of constraint should be applied?

Accepted Answer

Domain integrity. Domain integrity is the correct constraint type because it restricts the values of a column to a defined domain — in this case, the set {'Active', 'Inactive', 'Pending'}. This is typically enforced with a CHECK constraint or an ENUM data type that limits acceptable values. The scenario describes exactly a domain restriction on the 'Status' column.

Answer

Entity integrity

Answer

User-defined integrity

Answer

Referential integrity