Which data manipulation language (DML) command should you use?
You are writing an SQL statement to retrieve rows from a table.
Which data manipulation language (DML) command should you use?
Which constraint ensures a unique value in the ID column for each customer?
Which constraint ensures a unique value in the ID column for each customer?
The component that holds information for a single entry in a table is called a:
The component that holds information for a single entry in a table is called a:
You execute the following statement: SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department Th
You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department This type of
operation is called a/an:
Which command should you use to add a column to an existing table?
Which command should you use to add a column to an existing table?
How many rows are returned?
Which keyword should you use in your where clause?
You are writing a select statement to find every product whose name contains a specific character.
Which keyword should you use in your where clause?
What is the result?
A database contains two tables named Customer and Order. You execute the following statement:
DELETE FROM Order
WHERE CustomerID = 209 What is the result?
Which statement should you use?
Which SQL keyword should you use to change a student’s first name in the table?
You have a table that contains information about all students in your school.
Which SQL keyword should you use to change a student’s first name in the table?