CIS 421b: Database Administration I

Review for First Quiz

 

1. What are the basic components of an Oracle 9i database?
   
   
2. Which component is used for communication with the database on a standard network?
   
   
3. Which component provides a communication path to the database over an Internet connection?
   
   
4. Which component is the console that provides access to most management tools?
   
   
5. Which component contains wizards to help manage the database?
   
   
6. What is an instance? Explain the three variations of Oracle servers in terms of instances.
   
   
7. What is a user process?
   
   
8. What is a server process?
   
   
9. What is the difference between a dedicated server and a multi-threaded server?
   
   
10. What are the two kinds of client installations for Oracle 9i?
    
    
11. What are the three kinds of server installations available for Oracle 9i?
    
    
12. What is the meaning of the label ORACLE_BASE?
    
    
13. What is the meaning of hte label ORACLE_HOME?
    
    
14. What is Optimal Flexible Architecture? Why does Oracle recommend it?
    
    
15. What are the three file extensions defined in OFA, and what kinds of files use them?
    
    
16. What are the two main methods of opening an using an Oracle management tool?
    
    
17. What is the command line syntax for changing a user's password?
    
    
18. What is the name of the standard Oracle control file?
    
    
19. What is an Oracle Listener?
    
    
20. If you do not need to provide a service name when logging on to a database service, what must be true about the location of the database? What protocol is used by default for such a connection?
    
    
21. What editor is recommended to manually edit a control file on Windows 2000 server?
    
    
22. What Oracle process will exist in shared server environment that does not exist in a dedicated server environment?
    
    
23. What is an SGA? What is a PGA? How many of each might you have on a server?
    
    
24. What process writes data to redo log files?
    
    
25. What process writes data to data files?
    
    
26. What process writes data to archive files?
    
    
27. What are the four main features of Oracle Enterprise Manager, and what is each good for?
    
    
28. What does Oracle state as the minimum amount of RAM to run its software?
    
    
29. What are the two variations of storage space associated with ORACLE_HOME?
    
    
30. In Oracle 9i, what are the default login IDs with rights to manage the database?
    
    
31. What are the two kinds of security that might be used to allow DBAs to connect to the Oracle database?
    
    
32. What is the major difference between implementing User Managed Files and Oracle Managed Files?
    
    
33. What is the likely name of an Oracle initialization file? How many parameters does the text suggest will be in it?
    
    
34. Parameters in an initialization file come in five types. What are they?
    
    
35. What parameter holds the name of your database? What is the character limit on this name?
    
    
36. When you manually shut down a database, you can use three different modifiers to the command. What are they, and what is the difference between them?
    
    
37. Data dictionary views come in two types. What are the three static types? What do they allow you to see? What are the two dynamic types? What is the main difference between them?
    
    
38. Why should control files be multiplexed? How to you enable multiplexing?