Courseiva
Knowledge + Practice
CertificationsVendorsCareer RoadmapsLabs & ToolsStudy GuidesGlossaryPractice Questions
C
Courseiva

Free IT certification practice questions with explained answers for CCNA, CompTIA, AWS, Azure, Google Cloud, and more.

Certification Practice Questions

CCNA practice questionsSecurity+ SY0-701 practice questionsAWS SAA-C03 practice questionsAZ-104 practice questionsAZ-900 practice questionsCLF-C02 practice questionsA+ Core 1 practice questionsGoogle Cloud ACE practice questionsCySA+ CS0-003 practice questionsNetwork+ N10-009 practice questions
View all certifications →

Product

CertificationsCertification PathsExam TopicsPractice TestsExam Dumps vs Practice TestsStudy HubComparisons

Free Resources

Difficulty IndexLearn — Free ChaptersIT GlossaryFree Tools & LabsStudy GuidesCareer RoadmapsBrowse by VendorCisco Command ReferenceCCNA Scenarios

Company

AboutContactEditorial PolicyQuestion Writing PolicyTrust Center

Legal

Privacy PolicyTerms of Service

Courseiva is a free IT certification practice platform offering original exam-style practice questions, detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics for Cisco, CompTIA, Microsoft, AWS, and other technology certifications.

© 2026 Courseiva. Courseiva is operated by JTNetSolutions Ltd. All rights reserved.

Courseiva is an independent certification practice platform and is not affiliated with, endorsed by, or sponsored by Cisco, Microsoft, AWS, CompTIA, Google, ISC2, ISACA, or any other certification vendor. Vendor names and certification marks are used only to identify the exams learners are preparing for.

← Database Fundamentals practice sets

FC0-U61 Database Fundamentals • Complete Question Bank

FC0-U61 Database Fundamentals — All Questions With Answers

Complete FC0-U61 Database Fundamentals question bank — all 0 questions with answers and detailed explanations.

54
Questions
Free
No signup
Certifications/FC0-U61/Practice Test/Database Fundamentals/All Questions
Question 1easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 2mediummultiple choice
Read the full Database Fundamentals explanation →

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?

Question 3mediummultiple choice
Read the full Database Fundamentals explanation →

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?

Question 4hardmultiple choice
Read the full Database Fundamentals explanation →

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?

Question 5easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 6mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 7mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 8hardmultiple choice
Read the full Database Fundamentals explanation →

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

Question 9easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 10mediummultiple choice
Read the full Database Fundamentals explanation →

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?

Question 11hardmultiple choice
Read the full Database Fundamentals explanation →

A database has a 'Students' table with columns: StudentID (primary key), Name, Major. Another table 'Enrollments' has columns: EnrollmentID (primary key), StudentID (foreign key), CourseID. Which SQL query correctly lists each student's name and their enrolled courses by joining the tables?

Question 12mediummultiple choice
Read the full Database Fundamentals explanation →

Which of the following is a characteristic of a NoSQL database compared to a relational database?

Question 13mediummulti select
Read the full Database Fundamentals explanation →

A database administrator needs to choose a database for an e-commerce application that requires high availability and automatic scaling. Which TWO options are cloud database services?

Question 14hardmulti select
Read the full Database Fundamentals explanation →

A university database includes tables: 'Professors' (ProfessorID, Name, Department) and 'Courses' (CourseID, Title, ProfessorID). Which THREE statements about this design are correct?

Question 15mediummulti select
Read the full Database Fundamentals explanation →

Which TWO of the following are examples of NoSQL database types?

Question 16easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 17mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 18hardmultiple choice
Read the full Database Fundamentals explanation →

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

Question 19mediummultiple choice
Read the full Database Fundamentals explanation →

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?

Question 20easymultiple choice
Read the full Database Fundamentals explanation →

Which of the following best describes a NoSQL database?

Question 21mediummultiple choice
Read the full Database Fundamentals explanation →

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?

Question 22hardmultiple choice
Read the full Database Fundamentals explanation →

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?

Question 23easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 24mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 25mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 26hardmultiple choice
Read the full Database Fundamentals explanation →

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?

Question 27easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 28mediummulti select
Read the full Database Fundamentals explanation →

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

Question 29mediummulti select
Read the full Database Fundamentals explanation →

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

Question 30hardmulti select
Read the full Database Fundamentals explanation →

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

Question 31easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 32mediummultiple choice
Read the full Database Fundamentals explanation →

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?

Question 33mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 34hardmultiple choice
Read the full Database Fundamentals explanation →

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?

Question 35easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 36mediummultiple choice
Read the full Database Fundamentals explanation →

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?

Question 37mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 38hardmultiple choice
Read the full Database Fundamentals explanation →

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?

Question 39easymultiple choice
Read the full Database Fundamentals explanation →

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

Question 40mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 41mediummultiple choice
Read the full Database Fundamentals explanation →

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

Question 42hardmultiple choice
Read the full Database Fundamentals explanation →

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?

Question 43easymulti select
Read the full Database Fundamentals explanation →

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

Question 44mediummulti select
Read the full Database Fundamentals explanation →

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.)

Question 45hardmulti select
Read the full Database Fundamentals explanation →

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.)

Question 46easymultiple choice
Read the full Database Fundamentals explanation →

Which of the following is a primary advantage of using a database instead of a flat file system?

Question 47mediummultiple choice
Read the full Database Fundamentals explanation →

A database administrator needs to ensure that every record in the 'Orders' table can be uniquely identified. Which constraint should be applied to the 'OrderID' column?

Question 48mediummultiple choice
Read the full Database Fundamentals explanation →

A company uses a relational database with a 'Customers' table and an 'Orders' table. Each order must be linked to exactly one customer. Which type of relationship exists between Customers and Orders?

Question 49hardmultiple choice
Read the full Database Fundamentals explanation →

Which SQL statement would you use to retrieve the names of all products with a price greater than $50 from a table named 'Products'?

Question 50easymulti select
Read the full Database Fundamentals explanation →

Which TWO of the following are key characteristics of a NoSQL database compared to a traditional relational database?

Question 51mediummulti select
Read the full Database Fundamentals explanation →

Which TWO of the following are benefits of using a cloud database service (DBaaS) over an on-premises database?

Question 52mediummulti select
Read the full Database Fundamentals explanation →

Which THREE of the following are types of data integrity enforced in relational databases?

Question 53hardmulti select
Read the full Database Fundamentals explanation →

Which THREE of the following are valid SQL statements?

Question 54hardmulti select
Read the full Database Fundamentals explanation →

A database designer wants to reduce data redundancy in a relational database. Which THREE of the following are normalization techniques or concepts?

Practice tests

Scored 10-question sessions with instant feedback and explanations.

FC0-U61 Practice Test 1 — 25 Questions→FC0-U61 Practice Test 2 — 25 Questions→FC0-U61 Practice Test 3 — 25 Questions→FC0-U61 Practice Test 4 — 25 Questions→FC0-U61 Practice Test 5 — 25 Questions→FC0-U61 Practice Exam 1 — 20 Questions→FC0-U61 Practice Exam 2 — 20 Questions→FC0-U61 Practice Exam 3 — 20 Questions→FC0-U61 Practice Exam 4 — 20 Questions→Free FC0-U61 Practice Test 1 — 30 Questions→Free FC0-U61 Practice Test 2 — 30 Questions→Free FC0-U61 Practice Test 3 — 30 Questions→FC0-U61 Practice Questions 1 — 50 Questions→FC0-U61 Practice Questions 2 — 50 Questions→FC0-U61 Exam Simulation 1 — 100 Questions→

Practice by domain

Each domain maps to a weighted exam section. Focus on the domain where you are weakest.

IT Concepts and TerminologyInfrastructureApplications and SoftwareSoftware DevelopmentDatabase FundamentalsSecuritySoftware Development Concepts

Practice by scenario

Filter questions by type — troubleshooting, exhibit, drag-and-drop, PBQ, ACLs, OSPF, and more.

Browse scenarios→

Continue studying

All Database Fundamentals setsAll Database Fundamentals questionsFC0-U61 Practice Hub