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

Question 1

A company needs to store customer orders and ensure that each order is uniquely identified. Which database concept should be used?

Accepted Answer

Primary key. A primary key uniquely identifies each row in a table, ensuring no duplicates and no null values.

Answer

Constraint

Answer

Index

Answer

Foreign key

Question 2

A database designer wants to reduce data redundancy and avoid update anomalies. Which process should be applied?

Accepted Answer

Normalization. Normalization is the process of organizing data to minimize redundancy and dependency, typically by dividing tables and establishing relationships.

Answer

Denormalization

Answer

Encryption

Answer

Indexing

Question 3

A cloud database service is being considered for a startup to avoid hardware maintenance and allow automatic scaling. Which type of service is this?

Accepted Answer

Database as a Service (DBaaS). Database-as-a-Service (DBaaS) provides managed database instances in the cloud, handling maintenance, backups, and scaling.

Answer

Software as a Service (SaaS)

Answer

Infrastructure as a Service (IaaS)

Answer

Platform as a Service (PaaS)

Question 4

A user needs to retrieve all product names and prices from a table named 'Products' where the price is greater than 50. Which SQL statement should be used?

Accepted Answer

SELECT name, price FROM Products WHERE price > 50;. The SELECT statement with a WHERE clause filters rows based on a condition.

Answer

GET name, price FROM Products WHERE price > 50;

Answer

SELECT name, price FROM Products;

Answer

SELECT * FROM Products WHERE price > 50;

Question 5

Which of the following best describes a NoSQL database?

Accepted Answer

It provides a flexible schema for unstructured data.. NoSQL databases are designed for flexible schema and can handle unstructured data, often used for big data and real-time web applications.

Answer

It stores data in tables with rows and columns.

Answer

It uses SQL for querying.

Answer

It enforces strict referential integrity.

Question 6

An employee wants to add a new customer record to the 'Customers' table with columns 'ID', 'Name', and 'Email'. Which SQL statement should be used?

Accepted Answer

INSERT INTO Customers VALUES (1, 'John', 'john@example.com');. The INSERT statement adds new rows to a table.

Answer

ADD INTO Customers VALUES (1, 'John', 'john@example.com');

Answer

INSERT Customers VALUES (1, 'John', 'john@example.com');

Answer

UPDATE Customers SET Name='John' WHERE ID=1;

Question 7

A database has a 'Students' table and an 'Enrollments' table. Which type of relationship exists if a student can enroll in multiple courses and each course can have multiple students?

Accepted Answer

Many-to-many. A many-to-many relationship requires a junction table (like Enrollments) linking the two tables.

Answer

Many-to-one

Answer

One-to-many

Answer

One-to-one

Question 8

Which of the following is a benefit of using a database instead of a flat file?

Accepted Answer

Support for concurrent multi-user access. Databases provide concurrent access control, allowing multiple users to read/write data simultaneously without corruption.

Answer

Simpler setup and configuration

Answer

Faster file transfer speeds

Answer

Lower storage requirements

Question 9

A SELECT statement combines rows from two tables based on a related column. Which SQL clause is used to accomplish this?

Accepted Answer

JOIN. JOIN clauses, such as INNER JOIN, combine rows from two tables based on a related column.

Answer

GROUP BY

Answer

ORDER BY

Answer

WHERE

Question 10

Which of the following is an example of a NoSQL database that stores data as JSON-like documents?

Accepted Answer

MongoDB. MongoDB is a document-oriented NoSQL database that stores data in BSON (binary JSON) format.

Answer

MySQL

Answer

PostgreSQL

Answer

SQLite

Question 11

A developer modifies a database and wants to ensure that every value in a column meets a specific condition, such as age must be between 0 and 120. Which type of integrity constraint should be used?

Accepted Answer

Domain integrity. Domain integrity ensures that data falls within a valid range or set of values, often enforced with CHECK constraints.

Answer

Referential integrity

Answer

User-defined integrity

Answer

Entity integrity

Question 12

Which SQL statement is used to remove all rows from a table while keeping the table structure?

Accepted Answer

DELETE FROM table_name;. DELETE removes rows based on a condition or all rows if no WHERE clause is used, but TRUNCATE also removes all rows. However, DELETE is the standard DML command.

Answer

DROP TABLE

Answer

ALTER TABLE

Answer

REMOVE FROM table_name;

Question 13

Which TWO of the following are characteristics of a relational database? (Select TWO.)

Accepted Answer

Data is stored in tables with rows and columns.. Relational databases store data in tables and enforce relationships through keys.

Answer

It does not support SQL queries.

Answer

It is optimized for storing unstructured data like videos.

Answer

It uses a flexible schema that can change dynamically.

Question 14

Which TWO of the following are examples of popular relational database management systems (RDBMS)? (Select TWO.)

Accepted Answer

MySQL. MySQL and PostgreSQL are both widely used relational databases.

Answer

Cassandra

Answer

MongoDB

Answer

Redis

Question 15

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

Accepted Answer

No need to manage physical hardware. DBaaS provides managed services, automatic scaling, and no hardware management, reducing operational overhead.

Answer

Lower latency than on-premises in all cases

Answer

Full control over the operating system