CIS 421b: Database Administration I

Review for Final Quiz
  1. What is the difference between a standard relational table and an index-organized table?

  2. Explain these Oracle structure terms: data block, extent, schema object, segment, tablespace.

  3. What would cause a component of a data block to be categorized as overhead?

  4. What to you call a table row that has been moved to a new data block? What do you call a row that is stored in more than one data block?

  5. What is the significance of PCTFREE? How about PCTUSED? What is the numeric relationship between them?

  6. How many data types (total) are described in the text?

  7. What data types support the storage of Unicode characters?

  8. What are the four data types listed in the discussion of locator objects?

  9. What is the length limit for table names in Oracle? What can you do if you use quotes when naming an object, that you cannot do if you do not use quotes?

  10. Do temporary tables persist after a user closes his/her session? Will the data in the tables persist?

  11. What are the two discussed methods that could both be called storing a table in a table? When is one preferrred over the other?

  12. What is a partition, with respect to the discussion in Chapter 7? What are the three non-composite methods for creating a partition?

  13. What is the difference between an internal and an external LOB?

  14. What is meant by inside storage and outside storage? Which kind of LOB above do these terms relate to?

  15. What is a chunk? How must the chunk size relate numerically to another system quantity?

  16. Why is an index-organized table preferred in some cases?

  17. What is a ROWID?

  18. The text tells us we can change the order of columns in a table. This is almost a lie. What is the truth?

  19. What are two options you have if a column of data in a particular table is identified as obsolete information?

  20. How do you remove a table from a database? How do you remove only the data in a table?

  21. Optimizing table in Oracle can be done two ways. What are they? Which is the preferred method?

  22. What are the two default user IDs in Oracle with system privileges? Which is considered to be the more powerful? Which is meant to be used for routine maintenance?

  23. What are some of the actions made possible by the DBA role?

  24. What is the SQL syntax for creating a user?

  25. When creating a user, what is the significance of the following options:

  26. If a user is not created with their own tablespace, which tablespace will they be assigned?

  27. What does the QUOTA parameter mean when creating a user?

  28. What is a PROFILE? What is the default profile on a system?

  29. What view can be used to check the settings for all profiles on a system?

  30. When using the DROP USER command, why may you need to use the CASCADE option?

  31. How many profiles may a user be assigned to? How many users may be assigned to a profile?

  32. What does the CONNECT_TIME setting mean in a profile?

  33. What is the meaning of each of these settings:

  34. What are the two settings to a user password that can be made with the ALTER USER command?

  35. What is the difference between system privileges and object privileges?

  36. In round numbers, how many system privileges exist?

  37. What is the difference between the privilege CREATE TABLE and CREATE ANY TABLE?

  38. Which two object types in the text are listed as having the most related privileges?

  39. What is the basic syntax to give a privilege to a user? What variation is used to give this privilege to all users?

  40. When giving a user some privileges, what is the difference between WITH ADMIN OPTION and WITH GRANT OPTION?

  41. How do you remove a privilege from a user? How do you remove it from all users?

  42. What is the meaning of WITH HIERARCHY OPTION?

  43. Assume you granted a privilege to a user, who then granted it to six others. You want to remove it from all of them at once. What must be true for you to be able to do so?

  44. What are the three basic types of auditing? What is the difference between them?

  45. What are the four variations listed about how an audit can run?

  46. What view would you use to examine all audit trails?