CIS 331: Database Management Using SQL

Review for Third Test
 
  1. What command is used to save changes made in transactions? What precaution does the text recommend before using this command?

  2. What can you do to undo changes you have made to a database? What must be true for this procedure to work?

  3. 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?

  4. What command is used to make changes to data in your tables? Which clause determines which records will be changed?

  5. What command is used to make changes to columns in a table?

  6. What command is used to add new rows to tables?

  7. What command is used to add new columns to tables?

  8. When copying data from one table to another, what must be true about the tables?

  9. If a column is declared not to allow nulls when a table is created, are you allowed to change that setting later?

  10. What is the purpose of the MODIFY clause?

  11. How do you remove a table from a database? What can you do to merely empty the data from the table?

  12. Why should you use a COMMIT command before beginning a transaction?

  13. How is the ADD clause used with the ALTER TABLE command?

  14. What are some duties of a Database Administrator?

  15. Why does a DBA create views?

  16. What command is used to create a view?

  17. How is a view used after it is created?

  18. What effect does changing the data in a table have on a view that accesses that table?

  19. What effect does changing the structure of a table have on a view that accesses that table?

  20. What is the name for the query that is part of a view?

  21. How can you use different name for each column in a view?

  22. Are new tables created when you create a view?

  23. 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?

  24. Can users update tables through views? How could they affect their ability to see those tables?

  25. How do you remove a view from a database?

  26. How can a view be considered an element of database security?

  27. 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?

  28. What rights does a user need to update data? What rights does a user need in order to give rights to another user?

  29. What happens when you take rights away from a user who has given them to another user?

  30. What is an index? What is the purpose of an index?

  31. What are two disadvantages of indexes?

  32. How do you make an index? How do you remove an index?

  33. What is a unique index? Why would you want to make one?

  34. What is a data dictionary? What is another name for it?

  35. What is an integrity constraint? Why are they useful?

  36. What is the purpose of a CHECK clause?

  37. How does the text suggest that you should save files containing SQL commands?

  38. What is a delimiter? What are two common delimiters in data files?

  39. 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?

  40. What is the syntax for a command to save data into a text file?

  41. What is the purpose of the ANALYZE TABLE command?

  42. How are the uses of CHECK TABLE and REPAIR TABLE related?

  43. What does the EXPLAIN command do?

  44. What is the purpose of PROCEDURE ANALYSE? How is it different from EXPLAIN?

  45. What is the MYSQL Query Browser? What can it do that you can't do from a command line?

  46. What is a CSV file? Where might you use one?