FC0-U71 Data and Database Fundamentals Practice Test 3 — 15 Questions

Question 1

Which of the following is a characteristic of a relational database table?

Accepted Answer

Rows represent records and columns represent fields. In a relational database, each row represents a single record (tuple) and each column represents an attribute (field).

Answer

Rows represent fields and columns represent records

Answer

Each table must have a composite key

Answer

Tables are stored in a hierarchical structure

Question 2

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 customer can have multiple orders, but each order belongs to one customer, so it's a one-to-many relationship.

Answer

One-to-one

Answer

Many-to-many

Answer

Unrelated

Question 3

Which of the following best describes normalization in a relational database?

Accepted Answer

Removing duplicate data from a table. Normalization is the process of organizing data to reduce redundancy and improve data integrity.

Answer

Encrypting sensitive data in the database

Answer

Increasing the number of tables to improve performance

Answer

Combining all data into a single table

Question 4

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 enforced by data type and check constraints. A CHECK constraint on the Status column can restrict values to the allowed list.

Answer

Entity integrity

Answer

User-defined integrity

Answer

Referential integrity

Question 5

Which SQL statement is used to retrieve all columns from a table named 'Employees'?

Accepted Answer

SELECT * FROM Employees. The SELECT * statement retrieves all columns from the specified table.

Answer

RETRIEVE Employees

Answer

SHOW * FROM Employees

Answer

GET * FROM Employees

Question 6

A company stores customer data in a flat file. Which of the following is a disadvantage of using a flat file compared to a relational database?

Accepted Answer

Flat files do not support concurrent multi-user access. Flat files lack built-in support for concurrent access, leading to data corruption or conflicts when multiple users try to update the file simultaneously.

Answer

Flat files are slower for sequential reads

Answer

Flat files support complex queries

Answer

Flat files enforce referential integrity

Question 7

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

Accepted Answer

INSERT INTO Products VALUES ('Widget', 10.99). INSERT INTO table VALUES (value1, value2, ...) adds a new row.

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 8

A database contains two tables: 'Authors' (AuthorID, Name) and 'Books' (BookID, Title, AuthorID). A query needs to return all authors and any books they have written, including authors with no books. Which type of JOIN should be used?

Accepted Answer

LEFT JOIN. A LEFT JOIN returns all rows from the left table (Authors) and matching rows from the right table (Books). If no match, NULLs are returned for the right table.

Answer

CROSS JOIN

Answer

RIGHT JOIN

Answer

INNER JOIN

Question 9

Which of the following is a valid reason to use a database instead of a spreadsheet?

Accepted Answer

Databases provide query capabilities and enforce data integrity. Databases support complex queries using SQL and provide data integrity features like constraints.

Answer

Spreadsheets cannot store numbers

Answer

Spreadsheets are harder to learn

Answer

Databases are always free

Question 10

Which of the following is an example of a NoSQL database?

Accepted Answer

MongoDB. MongoDB is a popular document-oriented NoSQL database.

Answer

Oracle Database

Answer

MySQL

Answer

PostgreSQL

Question 11

In a relational database, which constraint ensures that a foreign key value matches an existing primary key value in the referenced table?

Accepted Answer

Foreign key constraint. Referential integrity is enforced by foreign key constraints, ensuring that relationships between tables remain consistent.

Answer

Primary key constraint

Answer

Check constraint

Answer

Unique constraint

Question 12

A database has a table 'Orders' with columns OrderID (primary key), CustomerID, OrderDate, and TotalAmount. Which SQL statement will delete all orders placed before January 1, 2023?

Accepted Answer

DELETE FROM Orders WHERE OrderDate < '2023-01-01'. DELETE FROM table WHERE condition removes rows that satisfy the condition.

Answer

DROP FROM Orders WHERE OrderDate < '2023-01-01'

Answer

DELETE OrderDate < '2023-01-01' FROM Orders

Answer

REMOVE FROM Orders WHERE OrderDate < '2023-01-01'

Question 13

Which of the following are advantages of using a cloud database service (DBaaS) compared to an on-premises database? (Select TWO.)

Accepted Answer

Managed maintenance and updates. DBaaS provides managed maintenance and automatic scalability without hardware management. High availability is inherent, and initial cost is lower (pay-as-you-go).

Answer

Full control over underlying hardware

Answer

Requires dedicated IT staff for database administration

Answer

Higher initial capital expenditure

Question 14

An online store uses a relational database with tables: Customers, Orders, and Products. Which of the following are valid ways to query the database structure? (Select THREE.)

Accepted Answer

DESCRIBE Customers. SELECT retrieves data, SHOW TABLES lists tables in MySQL, and DESCRIBE shows column info. INSERT adds data, not structure.

Answer

SELECT * FROM Customers

Answer

INSERT INTO Customers VALUES (...)

Question 15

A database designer is normalizing a table that contains repeating groups (multiple values in one column). Which of the following are goals of normalization? (Select THREE.)

Accepted Answer

Eliminate update anomalies. Normalization aims to reduce redundancy, enforce data integrity, and eliminate update anomalies. It rarely improves query performance (often may reduce it due to more joins).

Answer

Simplify the database schema

Answer

Improve query performance