Data and Database Fundamentals

A technician is documenting a hospital system where each patient can have many appointments, but every appointment belongs to exactly one patient and one doctor. The technician must describe how the Appointment table relates to the Patient table. Which term correctly describes this relationship?

A junior database administrator is reviewing the structure of a relational database used by a library. The database contains a Books table, a Members table, and a Loans table that records which member borrowed which book and the loan date. Which TWO of the following statements accurately describe the role of the Loans table in this database? (Choose two.)

A logistics analyst needs to record which driver delivered each shipment. A driver can deliver many shipments, and each shipment is delivered by exactly one driver. Which relationship type exists between drivers and shipments?

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

An analyst runs a query against a sales database and wants to return only the rows where the Region column equals 'West' and the SaleAmount column is greater than 1000. The analyst also wants the results sorted from highest SaleAmount to lowest. Which clause combination should the analyst use?

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?

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

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

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?

A database administrator is designing a new table to store employee records. The administrator wants to ensure that no two employees can have the same employee identification number, and that the employee identification number cannot be left empty. Which constraint should be applied to the EmployeeID column to meet both requirements?

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

A database administrator is designing a table to store employee records. She needs to ensure that no two employees can have the same employee number, and that the employee number is never left blank. Which combination of constraints should she apply to the employee number column?

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

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?

A ticket system logs a row for every check-in scan at an event gate, capturing the timestamp, gate identifier, and badge number. Staff want a quick daily count of scans per gate. Which statement about this data is most accurate?

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

Which of the following best describes a NoSQL database?

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?

A help desk technician is creating a spreadsheet to track support tickets. They want each ticket to have a unique identifier that is automatically generated when a new row is added, and they want the value to never repeat even if rows are deleted. Which spreadsheet feature should they use?

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?

Which THREE of the following are valid SQL statements?

A small business keeps its customer list in a single spreadsheet where the customer's city and state are typed into every invoice row. The owner wants a structure that stores each customer's address once and references it from many invoices without duplicating the address text. Which database concept should the owner apply?

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?

A bookstore owner wants to list all book titles stored in a table named Inventory, sorted alphabetically by title. Which SQL statement should be used?

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

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

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

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

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

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?

A hospital stores patient records in a relational database. Administrators need to record that a patient can have multiple allergies, and each allergy may affect multiple patients. Which type of relationship exists between patients and allergies, and how is it implemented?

A software developer is building an application that needs to store user profiles with varying attributes, such as some users having multiple phone numbers and others having none. The developer wants a flexible schema that allows different users to have different sets of fields without altering the database structure. Which type of database is best suited for this requirement?

A user needs to retrieve only the 'ProductName' and 'Price' columns from a table named 'Products' where the 'Category' is 'Electronics'. Which SQL statement should the user execute?

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

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

A student is comparing storage technologies for a project. The student needs a system that stores data as key-value pairs and is designed to scale horizontally across many servers for very high read and write throughput. Which category of database best fits this requirement?

A startup is choosing a data store for a product catalog where each item may have a different set of attributes, such as a camera with lens mount and sensor size versus a book with ISBN and page count. The catalog is read far more often than it is written, and the schema is expected to change frequently. Which TWO characteristics make a document-oriented NoSQL store a suitable fit? (Choose two.)

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?

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

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

A database administrator is normalizing a table that currently stores order details. The table has columns OrderID, ProductID, ProductName, Quantity, and UnitPrice. The administrator notices that ProductName and UnitPrice depend on ProductID, not on the combination of OrderID and ProductID. Which normal form is the table violating?

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

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

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

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

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?

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?

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

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

A data analyst is working with a large dataset stored in a columnar database. She needs to retrieve only the customer name and total order amount for orders placed in the last 30 days. Which two actions are most appropriate for optimizing this query? (Choose two.)

A small business is setting up a database to track its customers and their orders. The owner wants to ensure that every order is linked to an existing customer and that the customer ID in the Order table cannot refer to a non-existent customer. Which database concept should be implemented?

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?

A data analyst runs a query that joins the Customers and Orders tables. The result includes only customers who have placed at least one order, and customers with no orders are excluded. Which type of join produced this result?

A junior administrator is learning about database fundamentals and needs to identify characteristics that apply to a relational database management system (RDBMS). (Choose two.)

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

A technician is explaining database concepts to a new employee. The employee asks what a record represents in a relational database table. Which statement best describes a record?

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

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?

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?

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

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?

A small retail company stores customer orders in a relational database. The IT administrator wants each order record to automatically receive a unique number without manual entry when a new order is inserted. Which database feature should be configured to meet this requirement?

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

A small business stores customer orders in a relational database. The Orders table has a foreign key column named CustomerID that references the Customers table. A developer needs to prevent any order from being inserted if the CustomerID does not already exist in the Customers table. Which database feature should be used?

A small retail store keeps its sales records in a spreadsheet file. The owner complains that customer addresses are typed slightly differently in different rows, and that correcting one address requires editing many rows. Which data concept best describes the root problem the owner is experiencing?

A junior administrator is reviewing a database schema and must identify which statements about primary keys and foreign keys are accurate. (Choose two.)

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

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

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?

A hospital's scheduling system must answer questions such as 'which appointments belong to patient 4471, and which physician is assigned to each?' Records change frequently, and staff need immediate, consistent answers. Which data structure characteristic is most important for this requirement?

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

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?

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

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