Busy. Please wait.
Log in with Clever
or

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever
or

Username is available taken
show password

Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
SQL Ch5 Review Matching
A ____ can be viewed as a sequence of steps that accomplishes a single task.
transaction
You can use the ___ command to remove rows from a table.
DELETE
A ___ is a logical unit of work.
transaction
During your current work session, you can ___ (save) your changes immediately by executing the ___ command.
commit, COMMIT
You can use the ___ command to change rows on which a specific condition is true.
UPDATE
You can change a table's structure by using the __ ___ command.
ALTER TABLE
To add a new column, use the ___ clause of the ALTER TABLE command.
ADD
The ROLLBACK command reverses only changes made to the data; it does not reverse the changes made to a _____ ____.
table's structure
8.You can change the characteristics of existing columns by using the ___ clause of the ALTER TABLE command.
MODIFY
You can use the ____ clause of the ALTER TABLE command to change a column that currently rejects nulls values so that it will accept null values.
MODIFY
0:00

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how
Created by: kat1350
Popular Computers sets