CIS 331: Database Management Using SQL
Review for Third Test
- What command is used to save changes made in transactions? What precaution
does the text recommend before using this command?
- What can you do to undo changes you have made to a database? What
must be true for this procedure to work?
- What can you do that will automatically save changes made to your
database? What might be a drawback to relying on this as your sole method
for saving changes?
- What command is used to make changes to data in your tables? Which
clause determines which records will be changed?
- What command is used to make changes to columns in a table?
- What command is used to add new rows to tables?
- What command is used to add new columns to tables?
- When copying data from one table to another, what must be true about
- If a column is declared not to allow nulls when a table is created,
are you allowed to change that setting later?
- What is the purpose of the MODIFY clause?
- How do you remove a table from a database? What can you do to merely empty the data from the table?
- Why should you use a COMMIT command before beginning a transaction?
- How is the ADD clause used with the ALTER TABLE command?
- What are some duties of a Database Administrator?
- Why does a DBA create views?
- What command is used to create a view?
- How is a view used after it is created?
- What effect does changing the data in a table have on a view that
accesses that table?
- What effect does changing the structure of a table have on a view
that accesses that table?
- What is the name for the query that is part of a view?
- How can you use different name for each column in a view?
- Are new tables created when you create a view?
- What changes can be made to tables that will not affect the views
that use those tables? What changes would require the view to be recreated?
- Can users update tables through views? How could they affect their
ability to see those tables?
- How do you remove a view from a database?
- How can a view be considered an element of database security?
- What command is used by a DBA to give a user the right to use a table?
What command is used to remove that right from a user?
- What rights does a user need to update data? What rights does a user
need in order to give rights to another user?
- What happens when you take rights away from a user who has given them
to another user?
- What is an index? What is the purpose of an index?
- What are two disadvantages of indexes?
- How do you make an index? How do you remove an index?
- What is a unique index? Why would you want to make one?
- What is a data dictionary? What is another name for it?
- What is an integrity constraint? Why are they useful?
- What is the purpose of a CHECK clause?
- How does the text suggest that you should save files containing SQL
- What is a delimiter? What are two common delimiters in data files?
- What is the syntax to load data into a table from a text file? Why might you have to use some "optional" clauses to the command?
- What is the syntax for a command to save data into a text file?
- What is the purpose of the ANALYZE TABLE command?
- How are the uses of CHECK TABLE and REPAIR TABLE related?
- What does the EXPLAIN command do?
- What is the purpose of PROCEDURE ANALYSE? How is it different from EXPLAIN?
- What is the MYSQL Query Browser? What can it do that you can't do from a command line?
- What is a CSV file? Where might you use one?