Database Fundamentals

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

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?

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 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?

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

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

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

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

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

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 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?

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

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 university database includes tables: 'Professors' (ProfessorID, Name, Department) and 'Courses' (CourseID, Title, ProfessorID). Which THREE statements about this design are correct?

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

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

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

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 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 of the following best describes a NoSQL database?

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 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?

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

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

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

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?

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

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

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

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

Which of the following is a characteristic of a relational database 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?

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

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 SQL statement is used to retrieve all columns from a table named 'Employees'?

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?

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

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 of the following is a valid reason to use a database instead of a spreadsheet?

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

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

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 of the following are advantages of using a cloud database service (DBaaS) compared to an on-premises database? (Select TWO.)

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

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

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

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?

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 SQL statement would you use to retrieve the names of all products with a price greater than $50 from a table named 'Products'?

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

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 types of data integrity enforced in relational databases?

Which THREE of the following are valid SQL statements?

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