NEW
Font size
WorksheetsDatabase Practice Test 1 Review
Total questions: 13
Worksheet time: 11mins
Which SQL statement correctly retrieves a list of customers from Utah, sorted by last name?
SELECT lastname, firstname FROM customers WHERE state = 'UT' ORDER BY lastname;
SELECT lastname, firstname FROM customers ORDER BY lastname WHERE state = 'UT';
SELECT lastname, firstname FROM customers WHERE state = 'UT' GROUP BY lastname;
SELECT lastname, firstname FROM customers ORDER BY lastname;
Which of the following statements about the GROUP BY clause are true?
Yes, No, No
No, Yes, No
Yes, Yes, No
No, No, Yes
What is the issue with the following SQL statement? SELECT LastName, FirstName, COUNT(OrderID) FROM Customers GROUP BY LastName HAVING COUNT(OrderID) >= 5;
The SQL statement is missing a GROUP BY clause for all selected columns.
The HAVING clause is incorrectly used instead of WHERE.
The COUNT function is used incorrectly with non-aggregated columns.
The SQL statement is correct and has no issues.
What would cause a runtime error in the following SQL statement? sql CopyEdit UPDATE Customers SET Status = 'Gold' IF TotalAmount > 10000;
The object type needs to be specified within the UPDATE statement.
The IF clause needs to be at the beginning of the statement.
The IF clause needs to be a WHERE clause.
The statement needs semicolons.
Which SQL statement allows inserting multiple rows at once using the VALUES keyword?
INSERT INTO table_name VALUES (value1, value2, value3,...);
INSERT INTO table_name SELECT (column1, column2, column3);
INSERT INTO table_name(column1, column2) VALUES (value1a, value1b), (value2a, value2b);
INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...);
A quality control specialist wants to retrieve an orderID after inputting an orderdetailID. Which of the following SQL statements correctly creates the required stored procedure?
CREATE PROCEDURE uspGetOrderID @orderdetailIID int, @orderID int OUTPUT BEGIN SELECT @orderID = orderid FROM orderdetails WHERE orderdetailid = @orderdetailID END
CREATE PROCEDURE uspGetOrderID @orderdetailIID int, @orderID int OUTPUT AS BEGIN SELECT orderid FROM orderdetails WHERE orderdetailid = @orderdetailID RETURN @orderID END
CREATE PROCEDURE uspGetOrderID @orderdetailIID int AS BEGIN SELECT orderid FROM orderdetails WHERE orderdetailid = @orderdetailID END
CREATE PROCEDURE uspGetOrderID @orderdetailIID int, @orderID int OUTPUT AS BEGIN SELECT @orderID = orderid FROM orderdetails WHERE orderdetailid = @orderdetailID END
What is the correct SQL statement to create a stored procedure that retrieves an order ID based on the order detail ID?
CREATE PROCEDURE uspGetOrderID @orderdetailID int, @orderID int OUTPUT AS BEGIN SELECT @orderID = orderid FROM orderdetails WHERE orderdetailid = @orderdetailID END
CREATE PROCEDURE uspGetOrderID @orderdetailID int, @orderID int OUTPUT AS BEGIN SELECT orderid FROM orderdetails WHERE orderdetailid = @orderdetailID END
CREATE PROCEDURE uspGetOrderID @orderdetailID int, @orderID int OUTPUT AS BEGIN SELECT @orderID = orderid FROM orderdetails WHERE orderdetailid = @orderdetailID RETURN @orderID END
CREATE PROCEDURE uspGetOrderID @orderdetailID int, @orderID int OUTPUT AS BEGIN SELECT @orderID = orderid FROM orderdetails WHERE orderdetailid = @orderdetailID END
A list of students volunteering at a Science Fair is stored in the Students table. If Benjamin is no longer attending and is replaced by Kayden, which SQL statement correctly updates the table?
REPLACE INTO Students (FirstName) VALUES ('Kayden') WHERE FirstName = 'Benjamin';
UPDATE Students SET FirstName = 'Kayden' WHERE FirstName = 'Benjamin';
MODIFY Students SET FirstName = 'Kayden' WHERE FirstName = 'Benjamin';
What is the purpose of the following SQL statement? INSERT INTO Students (FirstName) VALUES ('Kayden') WHERE FirstName = 'Benjamin';
To add a new record with the name 'Kayden'
To update the name 'Benjamin' to 'Kayden'
To delete the record with the name 'Benjamin'
To select the record with the name 'Benjamin'
What is being enforced using this SQL statement? ALTER TABLE salesterritory ADD CONSTRAINT fk_location FOREIGN KEY (locationID) REFERENCES locations(locationID);
Primary key
Foreign key
Referential integrity
Compound key
A student database contains multiple records with the same last name "Smith" and first name "David." If these records are not duplicates, how does the database differentiate them?
By using unique student IDs
By using different last names
By using different first names
By using different addresses
What uniquely identifies each record in a table, ensuring that no two records share the same identifier, even if they have identical first and last names?
Schema
Foreign key
Referential integrity
Primary key
What will be the result of the following SQL statement? CREATE VIEW cambridge_data AS SELECT NoControl, FullName FROM cambridge ORDER BY FullName;
A SQL Server Database Error because the same column cannot be used multiple times in the statement.
The creation of a view called cambridge_data with the data ordered by FullName.
A SQL Server Database Error because the ORDER BY clause is not valid in the creation of a view.
A SQL Server Database Error because the CREATE VIEW statement is not within a BEGIN/END block.
