| MUET / Departments / Computer Systems & Software Engineering / Course of SW / DBA |  |
DATABASE ADMINISTRATION Theory (100) Practical (50) OVERVIEW OF ORACLE ARCHITECTURE Recognizing the Components of the Oracle architecture, identifying the purpose of each of the components types. STARTUP AND SHUTDOWN AN INSTANCE Selecting an authentication method, Startup an instance using the appropriate mode, shut down an instance using the appropriate mode, Alter the database mode, Restrict logins. CREATING A DATABASE Discuss the relationship between the logical entity relationship diagram and the associated database, Creating a Database, constructing the data dictionary. ACCESSING AND UPDATING DATA List the steps in SQL statement processing, Identity the benefits of Oracles Shared SQL area, Identify the function and contents of the database buffer cache, Describing how the server reads data into the database buffer cache, Identify the purpose of database writer (DBWR) process, Identify the events that trigger the Database Writer to do its job, Recognize the roles of the Database Writer. MANAGE TRANSACTION CONCURRENCY Recognize the roles of the Log Write (LGWR) in recording committed transaction to the data files, Identify the components and the purpose of the redo log, Identify the purpose check points, Identify how Oracle handles data concurrency and statement level read consistency. MANAGE THE DATABASE STRUCTURE Explain database storage allocation, Customize the database structure, Prepare necessary table-spaces, Describe different types of segments. MANAGE STORAGE ALLOCATION Allocate extents to database objects, Explain database storage allocation parameters, Control space usage, Use space utilization parameter, Display database storage information. MANAGE ROLLBACK SEGMENTS Manage and describe the functions of rollback segments, Create Rollback Segments of appropriate sizes, Describe Storage and Performance Trade-Offs, Determine the number of rollback segments. MANAGE TABLE AND INDEX SEGMENTS Create tables and indexes of appropriate sizes, Understand storage and performance tradeoffs, Review space utilization MANAGE CLUSTER SEGMENTS Describe the advantages and disadvantages of using clusters, Create clusters, Describe hashing, Create hash clusters MANAGE CONSTRAINTS Explain the importance of data integrity and declarative constraints, Describe the types of constraints and their uses, Define various constraints, Locking issue regarding primary and foreign key constraints, Identify constraint violations by accessing the constraints exception table, Use data dictionary views to examine constraints MANAGE USERS Create new database users, Alter and drop existing database users, Monitor information about existing database users, Terminate user sessions MANAGE RESOURCES USAGE Manage user profiles, Understand and control Oracle resource usage, Create and assign user profits to limit Oracle resources usage, Manage the Profiles created for a system MANAGE DATABASE ACCESS Define database privileges, Grant and control system privileges, Grant and control object privileges MANAGE ROLES Create and control roles AUDIT THE DATABASE Determine when auditing is necessary, Track statement and system level accesses to database objects, Monitor auditing options with its data dictionary, View and maintain auditing results NOTE: PRACTICAL WILL BE BASED ON THEORY RECOMMENDED BOOKS [1] Kevin Londy. Marlene L. Theriavlt, “Oracle 8 DBA Handbook” [2] Janathan Levis, “Practical Oracle 8 : Building Efficient Database”, Addison-Wesley Pub company [3] Kevin Loney George K. Koch, “Oracle 8: The complete reference”, Osborne McGraw Hill (Oracle press) [4] Eyal Arnoff, Kevin Lonely, Noorali Sonawall, “Oracle 8 Advanced Tuning and Administration”, Osborne McGraw Hill (Oracle press) [5] Steve Bobrowski,, “Oracle 8 Architecture”.
|
