Data and Database Fundamentals

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

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

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

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?

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?

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

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

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

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?

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 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 cloud database service is being considered for a startup to avoid hardware maintenance and allow automatic scaling. Which type of service is this?

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?

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

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

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 SQL statement is used to remove all rows from a table while keeping the table structure?

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

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