FC0-U71 Data and Database Fundamentals — 10 Questions

Question 1

Which of the following is a primary advantage of using a database over a flat file system for storing customer records?

Accepted Answer

Supports simultaneous multi-user access. Databases support concurrent multi-user access with locking mechanisms, while flat files cannot handle simultaneous writes safely.

Answer

Simpler to set up and manage

Answer

Stores data in a non-structured format

Answer

No need for a query language

Question 2

A database administrator wants to enforce that every record in the 'Orders' table must have a non-null unique value in the 'OrderID' column. Which database concept ensures this?

Accepted Answer

Entity integrity. Entity integrity requires a primary key to be unique and not null for each row.

Answer

Referential integrity

Answer

Input validation

Answer

Domain integrity

Question 3

In a relational database, a foreign key in the 'Enrollments' table references the primary key of the 'Students' table. What does this relationship primarily enforce?

Accepted Answer

Referential integrity. Foreign keys enforce referential integrity, ensuring that values in the foreign key column match a primary key value in the referenced table.

Answer

Entity integrity

Answer

Normalization

Answer

Domain integrity

Question 4

A company stores product data in a MongoDB database. Each product document contains fields like 'name', 'price', and 'tags' (an array). What type of NoSQL database is MongoDB?

Accepted Answer

Document store. MongoDB is a document-oriented NoSQL database that stores data in JSON-like documents.

Answer

Wide-column store

Answer

Graph database

Answer

Key-value store

Question 5

Which SQL statement is used to retrieve all columns from a table named 'Customers' where the city is 'London'?

Accepted Answer

SELECT * FROM Customers WHERE city = 'London';. The SELECT statement retrieves data. The correct syntax is: SELECT * FROM Customers WHERE city = 'London';

Answer

RETRIEVE * FROM Customers WHERE city = 'London';

Answer

SELECT * FROM Customers HAVING city = 'London';

Answer

GET * FROM Customers WHERE city = 'London';

Question 6

A database designer wants to split a table into two to reduce data redundancy and avoid update anomalies. This process is known as:

Accepted Answer

Normalization. Normalization is the process of organizing data to reduce redundancy and improve integrity.

Answer

Denormalization

Answer

Indexing

Answer

Partitioning

Question 7

Which DBMS is an example of a proprietary relational database system?

Accepted Answer

Oracle Database. Oracle Database is proprietary (commercial). MySQL, PostgreSQL, and SQLite are open-source.

Answer

MySQL

Answer

PostgreSQL

Answer

SQLite

Question 8

A company uses a cloud database service where the provider automatically handles backups, patching, and scaling. This deployment model is known as:

Accepted Answer

Database as a Service (DBaaS). Database-as-a-Service (DBaaS) is a cloud service where the provider manages the database infrastructure.

Answer

Platform as a Service (PaaS)

Answer

Software as a Service (SaaS)

Answer

Infrastructure as a Service (IaaS)

Question 9

Which SQL command is used to add a new row to a table?

Accepted Answer

INSERT INTO. INSERT INTO is the SQL command for adding new rows.

Answer

ADD

Answer

CREATE

Answer

UPDATE

Question 10

In a relational database, which type of relationship is typically implemented by creating a third table (junction table) that contains foreign keys from both related tables?

Accepted Answer

Many-to-many. Many-to-many relationships require a junction table to associate records from both sides.

Answer

Self-referencing

Answer

One-to-one

Answer

One-to-many