Question 1easymultiple choice
Read the full Database Fundamentals explanation →FC0-U61 Database Fundamentals • Complete Question Bank
Complete FC0-U61 Database Fundamentals question bank — all 0 questions with answers and detailed explanations.
Refer to the exhibit. ``` INSERT INTO Products (ProductID, ProductName, Price) VALUES (1, 'Widget', 10); INSERT INTO Products (ProductID, ProductName, Price) VALUES (2, 'Gadget', 20); INSERT INTO Products (ProductID, ProductName, Price) VALUES (3, 'Widget', 15); SELECT ProductName, COUNT(*) FROM Products GROUP BY ProductName HAVING COUNT(*) > 1; ```
Refer to the exhibit. A database administrator runs the following query:
SELECT c.Name, SUM(o.Quantity) AS TotalItems FROM Customers c LEFT JOIN Orders o ON c.ID = o.CustomerID GROUP BY c.Name;
What is the result for 'Alice'?
Refer to the exhibit.
CREATE TABLE employees (
employee_id INT PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
department_id INT,
hire_date DATE
);
INSERT INTO employees VALUES (1, 'John', 'Doe', 10, '2021-01-15');
INSERT INTO employees VALUES (2, 'Jane', 'Smith', 20, '2020-06-01');
INSERT INTO employees VALUES (3, 'Bob', 'Johnson', 10, '2022-03-22');Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Drag a concept onto its matching description — or click a concept then click the description.
Small geographic area
Large geographic area
Personal devices around a person
City-sized network
SELECT * FROM Employees WHERE Department = 'Sales';
GRANT SELECT ON Customers TO user1;
DELETE FROM Customers WHERE CustomerID = 100;
Refer to the exhibit. CREATE TABLE Products ( ProductID INT PRIMARY KEY, ProductName VARCHAR(50), Price DECIMAL(10,2) ); INSERT INTO Products VALUES (1, 'Laptop', 999.99); INSERT INTO Products VALUES (2, 'Mouse', 25.50);
Refer to the exhibit. Database error log: ERROR: deadlock detected DETAIL: Process 1 waits for ShareLock on transaction 501; blocked by process 2. Process 2 waits for ShareLock on transaction 500; blocked by process 1. HINT: See server log for query details.
UPDATE Employees SET Salary = Salary + 500;
CREATE TABLE Orders (
OrderID INT PRIMARY KEY,
CustomerID INT,
OrderDate DATE,
FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);Refer to the exhibit. SELECT Customers.CustomerName, Orders.OrderDate FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE Customers.City = 'New York';