REVOKE SELECT ON Customer FROM User1

Remove the ORDER BY clause

True

DELETE FROM Volunteer WHERE GivenName = ‘Tia’

LIKE

PhoneNumber, IS NOT NULL, ORDER BY

SELECT * FROM Orders WHERE NOT ship_state = ‘TX’ AND NOT ship_state = ‘AZ’

True

cascade delete

False

CREATE VIEW [dbo].[NorthAmericanMammals_View], AS SELECT a.Id, a.Name, FROM Animal a

SELECT * FROM students WHERE enrollment_date >= ‘2020-06-01’ OR academic_status = ‘Graduated’ AND graduation_date >= ‘2020-01-01’ ORDER BY enrollment_date DESC

4

SELECT ItemName, Price FROM Products WHERE ItemDescription LIKE ‘%chocolate%’;

INTERSECT

cartesian product

A constraint

UPDATE Product SET ProductCategory = 43 WHERE ProductDescription = ‘spoon’

VARCHAR, INT, DECIMAL

Empty

Return large results sets, are accessed randomly

INSERT INTO EmployeeCopy SELECT * FROM Employee

UPDATE Products SET Price = Price * 1.06 WHERE ItemNumber = 1;

CREATE TABLE Employee (EmployeeID INTEGER PRIMARY KEY)

ALTER TABLE

A non-clustered index on the Category column

SELECT COUNT(*) FROM Employee

SUM(Points), WHERE, GROUP BY, PlayerID

AND, >, ORDER BY, ArrivalTime DESC

No rows will be deleted from the table

compositional

A foreign key

PRIMARY KEY, CONSTRAINT

SELECT COUNT(OrderID), Country FROM Orders GROUP BY Country HAVING COUNT(orderID) < 50

ChapterID, LanguageID

A new row in the table

Improve performance

DELETE FROM Customer WHERE CustomerID = 12345

Decimal

DROP VIEW EmployeeView

The plus (+) operator cannot be used to append character data

CREATE VIEW MyGame AS SELECT Name FROM Games ORDER BY Name

CREATE TABLE Order (OrderID INTEGER, OrderItemID INTEGER, PRIMARY KEY (OrderID, OrderItemID))

DELETE FROM Employee WHERE Phone IS NULL

True

ALTER TABLE Customers DROP COLUMN SSN;

SELECT COUNT(ID), AVG(UnitPrice+Quantity), MAX(UnitPrice+Quantity), SUM(UnitPrice+Quantity) FROM ItemsOnOrder GROUP BY ItemNumber, LineItemTotal

Exclude duplicate rows, Exclude repeating groups

CREATE TABLE Student ( ID INT, Name VARCHAR (100), Age INT)

In the order in which the rows were inserted.

False

SELECT EmployeeName FROM Employee WHERE EmployeeName = ‘Jack Smith’;

True

TOP 10, IS NOT NULL, ORDER BY

UPDATE LoanedBooks SET Books = 0 WHERE (NAME = ‘Harry’ AND City = ‘San Francisco’)

False

Full join

You should run the DROP CONSTRAINT query before running the ALTER TABLE query

Foreign key