/******************************************************************************
* This file defines the tree menu with it's items and submenus.               *
******************************************************************************/

// User-defined tree menu data.

var treeMenu           = new TreeMenu();  // This is the main menu.
var treeMenuName       = "trialcw9_04.07.03";    // Make this unique for each tree menu.
var treeMenuDays       = 30;             // Number of days to keep the cookie.
var treeMenuFrame      = "menuFrame";     // Name of the menu frame.
var treeMenuImgDir     = "images/";        // Path to graphics directory.
var treeMenuBackground = "";              // Background image for menu frame.   
var treeMenuBgColor    = "#B0D8E8";       // Color for menu frame background.   
var treeMenuFgColor    = "#000000";       // Color for menu item text.
var treeMenuHiBg       = "#3858A0";       // Color for selected item background.
var treeMenuHiFg       = "#ffffff";       // Color for selected item text.
var treeMenuFont       = "Verdana,Arial,Helvetica";    // Text font face.
var treeMenuFontSize   = 2;               // Text font size.
var treeMenuRoot       = "Learning Oracle9i";     // Text for the menu root.
var treeMenuFolders    = 0;               // Sets display of '+' and '-' icons.
var treeMenuAltText    = true;            // Use menu item text for icon image ALT text.

/******************************************************************************/

function Course(title, url) {
  this.title = title;
  this.url = url;
}

courses = new Array();
courses[0] =  new Course("","");
courses[1] =  new Course("What is Oracle?", "scripts/toc.cgi?../m001/m001.txt");
courses[2] =  new Course("Introduction to Oracle Database Structures", "scripts/toc.cgi?../m002/m002.txt");
courses[3] =  new Course("Introduction to SQL", "scripts/toc.cgi?../m003/m003.txt");
courses[4] =  new Course("Introduction to Oracle Database Storage", "scripts/toc.cgi?../m004/m004.txt");
courses[5] =  new Course("Introduction to Oracle Software Architecture", "scripts/toc.cgi?../m005/m005.txt");
courses[6] =  new Course("Introduction to Databases and SQL*Plus", "scripts/tocn.cgi?../m006/m006.txt");
courses[7] =  new Course("Basic iSQL*Plus Commands", "scripts/tocn.cgi?../m007/m007.txt");
courses[8] =  new Course("Build Basic SELECT Clause Expressions", "scripts/tocn.cgi?../m008/m008.txt");
courses[9] =  new Course("Introduction to the SELECT Statement", "scripts/tocn.cgi?../m009/m009.txt");
courses[10] = new Course("Build SELECT Clause Expressions with SQL Functions", "scripts/tocn.cgi?../m010/m010.txt");
courses[11] = new Course("Build Basic WHERE Clause Conditions", "scripts/tocn.cgi?../m011/m011.txt");
courses[12] = new Course("Organize Query Results with Sorting and Grouping", "scripts/tocn.cgi?../m012/m012.txt");
courses[13] = new Course("Join Related Data", "scripts/tocn.cgi?../m013/m013.txt");
courses[14] = new Course("Manipulate Data with DML Statements and Transactions", "scripts/tocn.cgi?../m014/m014.txt");
courses[15] = new Course("Build Miscellaneous Types of Queries", "scripts/tocn.cgi?../m015/m015.txt");
courses[16] = new Course("Create, Use, and Manage External Tables", "scripts/tocn.cgi?../m016/m016.txt");
courses[17] = new Course("Configure iSQL*Plus for Privileged DBA Connections", "scripts/tocn.cgi?../m017/m017.txt");
courses[18] = new Course("Introduction to Database Creation", "scripts/tocn.cgi?../m018/m018.txt");
//PLSQL Courses
courses[19] = new Course("Introduction to PL/SQL", "scripts/tocn.cgi?../m019/m019.txt");
courses[20] = new Course("Program Variables and Constants", "scripts/tocn.cgi?../m020/m020.txt");
courses[21] = new Course("Flow Control Statements", "scripts/tocn.cgi?../m021/m021.txt");
courses[22] = new Course("Database Access and Record Types", "scripts/tocn.cgi?../m022/m022.txt");
courses[23] = new Course("Subprograms: Procedures and Functions", "scripts/tocn.cgi?../m023/m023.txt");
courses[24] = new Course("Cursors", "scripts/tocn.cgi?../m024/m024.txt");
courses[25] = new Course("Collections", "scripts/tocn.cgi?../m025/m025.txt");
courses[26] = new Course("Exceptions and Exception Handlers ", "scripts/tocn.cgi?../m026/m026.txt");
courses[27] = new Course("Stored Procedures and Functions ", "scripts/tocn.cgi?../m027/m027.txt");
courses[28] = new Course("Packages", "scripts/tocn.cgi?../m028/m028.txt");
courses[29] = new Course("Database Triggers", "scripts/tocn.cgi?../m029/m029.txt");
courses[30] = new Course("PL/SQL Debugging", "scripts/tocn.cgi?../m030/m030.txt");
courses[31] = new Course("Dependency Management", "scripts/tocn.cgi?../m031/m031.txt");
courses[32] = new Course("Miscellaneous PL/SQL Topics", "scripts/tocn.cgi?../m032/m032.txt");
courses[33] = new Course("Work with Datetimes and Intervals", "scripts/tocn.cgi?../m033/m033.txt");
courses[34] = new Course("Work with Subqueries", "scripts/tocn.cgi?../m034/m034.txt");
courses[35] = new Course("Install Oracle9i Enterprise Edition Release 2 (9.2) for Linux", "scripts/tocn.cgi?../m035/m035.txt");
courses[36] = new Course("Install Oracle9i Enterprise Edition Release 1 (9.0)", "scripts/tocn.cgi?../m036/m036.txt");
courses[37] = new Course("Use Oracle9i Enterprise Edition for the First Time", "scripts/tocn.cgi?../m037/m037.txt");
courses[38] = new Course("Prepare to Use Oracle9i Enterprise Edition", "scripts/toc.cgi?../m038/m038.txt");
courses[39] = new Course("Using Oracle8i Personal Edition on Windows 98 for the First Time", "scripts/tocn.cgi?../m039/m039.txt");
courses[40] = new Course("Introduction to Databases and SQL*Plus", "scripts/toc.cgi?../m040/m040.txt");
courses[41] = new Course("Prepare to Use Oracle9i Enterprise Edition", "scripts/toc.cgi?../m041/m041.txt");
courses[42] = new Course("Create and Use Tables", "scripts/tocn.cgi?../m042/m042.txt");
courses[43] = new Course("Introduction to Schemas", "scripts/tocn.cgi?../m043/m043.txt");
courses[44] = new Course("Design Tables", "scripts/tocn.cgi?../m044/m044.txt");
courses[45] = new Course("Manage Tables", "scripts/tocn.cgi?../m045/m045.txt");
courses[46] = new Course("Create and Use Temporary Tables", "scripts/tocn.cgi?../m046/m046.txt");
courses[47] = new Course("Create and Use Views", "scripts/tocn.cgi?../m047/m047.txt");
courses[48] = new Course("Create Updateable Views and INSTEAD OF Triggers", "scripts/tocn.cgi?../m048/m048.txt");
courses[49] = new Course("Manage Views", "scripts/tocn.cgi?../m049/m049.txt");
courses[50] = new Course("Create, Use, and Manage Sequences", "scripts/tocn.cgi?../m050/m050.txt");
courses[51] = new Course("Create, Use, and Manage Synonyms", "scripts/tocn.cgi?../m051/m051.txt");
courses[52] = new Course("Overview of Oracle Database Administration", "scripts/tocn.cgi?../m052/m052.txt");
courses[53] = new Course("Database Administrator Security", "scripts/tocn.cgi?../m053/m053.txt");
courses[54] = new Course("Create Tables with Integrity Constraints", "scripts/tocn.cgi?../m054/m054.txt");
courses[55] = new Course("Create Deferrable Integrity Constraints", "scripts/tocn.cgi?../m055/m055.txt");
courses[56] = new Course("Enable and Disable Constraints", "scripts/tocn.cgi?../m056/m056.txt");
courses[57] = new Course("Query the Data Dictionary", "scripts/tocn.cgi?../m057/m057.txt");
courses[58] = new Course("Introduction to Database Trace Files", "scripts/tocn.cgi?../m058/m058.txt");
courses[59] = new Course("Database Password File Configuration", "scripts/tocn.cgi?../m059/m059.txt");
courses[60] = new Course("Database Initialization Parameter Files", "scripts/tocn.cgi?../m060/m060.txt");
courses[61] = new Course("Create a Database Manually", "scripts/tocn.cgi?../m061/m061.txt");
courses[62] = new Course("Server Startup and Shutdown", "scripts/tocn.cgi?../m062/m062.txt");
courses[63] = new Course("Use SQL*Loader", "scripts/tocn.cgi?../m063/m063.txt");
courses[64] = new Course("Manual Segment Space Management", "scripts/tocn.cgi?../m064/m064.txt");
courses[65] = new Course("Automatic Segment Space Management", "scripts/tocn.cgi?../m065/m065.txt");
courses[66] = new Course("Configure the SGA", "scripts/tocn.cgi?../m066/m066.txt");
courses[67] = new Course("Use Oracle Managed Files", "scripts/tocn.cgi?../m067/m067.txt");
courses[68] = new Course("Configure Recovery Manager", "scripts/tocn.cgi?../m068/m068.txt");
courses[69] = new Course("Introduction to Indexes and Data Clusters", "scripts/tocn.cgi?../m069/m069.txt");
courses[70] = new Course("Create Normal Indexes", "scripts/tocn.cgi?../m070/m070.txt");
courses[71] = new Course("Introduction to the SGA", "scripts/tocn.cgi?../m071/m071.txt");
courses[72] = new Course("open", "open"); // open
courses[73] = new Course("open", "open"); // open
courses[74] = new Course("open", "open"); // open
courses[75] = new Course("open", "open"); // open
courses[76] = new Course("open", "open"); // open
courses[77] = new Course("open", "open"); // open
courses[78] = new Course("Devise a Security Policy", "scripts/tocn.cgi?../m078/m078.txt");
courses[79] = new Course("Create Database Users", "scripts/tocn.cgi?../m079/m079.txt");
courses[80] = new Course("Manage Database Users", "scripts/tocn.cgi?../m080/m080.txt");
courses[81] = new Course("Grant and Revoke System Privileges", "scripts/tocn.cgi?../m081/m081.txt");
courses[82] = new Course("Grant and Revoke Object Privileges", "scripts/tocn.cgi?../m082/m082.txt");
courses[83] = new Course("<font color=gray>Use Fine-Grained Access Controls</font>", "scripts/mainframe.cgi?0"); // open
courses[84] = new Course("Create, Use, and Manage Roles", "scripts/tocn.cgi?../m084/m084.txt");
courses[85] = new Course("Introduction to Data Blocks", "scripts/tocn.cgi?../m085/m085.txt");
courses[86] = new Course("Configure External User and Role Authentication", "scripts/tocn.cgi?../m086/m086.txt");
courses[87] = new Course("Audit Database Access", "scripts/tocn.cgi?../m087/m087.txt");
courses[88] = new Course("Create, Use, and Manage User Profiles", "scripts/tocn.cgi?../m088/m088.txt");
courses[89] = new Course("Manage Row Chaining and Row Migration", "scripts/tocn.cgi?../m089/m089.txt");
courses[90] = new Course("Introduction to PL/SQL", "scripts/toc.cgi?../m090/m090.txt");
courses[91] = new Course("open", "open"); // open
courses[92] = new Course("Introduction to Oracle Enterprise Manager", "scripts/tocn.cgi?../m092/m092.txt");
courses[93] = new Course("Prepare to Use Oracle Enterprise Manager", "scripts/tocn.cgi?../m093/m093.txt");
courses[94] = new Course("Basic Administration with the OEM Console", "scripts/tocn.cgi?../m094/m094.txt");
courses[95] = new Course("open", "scripts/tocn.cgi?../m095/m095.txt");
courses[96] = new Course("open", "open"); // open
courses[97] = new Course("open", "open"); // open
courses[98] = new Course("Create a Database with the Database Configuration Assistant", "scripts/tocn.cgi?../m098/m098.txt");
courses[99] = new Course("Install Oracle9i Enterprise Edition Release 2 (9.2)", "scripts/toc.cgi?../m099/m099.txt");
courses[100] = new Course("Fundamentals of Oracle Database Structure", "scripts/tocn.cgi?../m100/m100.txt");
courses[101] = new Course("Basic Tablespace Management", "scripts/tocn.cgi?../m101/m101.txt");
courses[102] = new Course("Basic Data File Management", "scripts/tocn.cgi?../m102/m102.txt");
courses[103] = new Course("Basic Segment and Extent Management", "scripts/tocn.cgi?../m103/m103.txt");
courses[104] = new Course("Reclaim Unused Space in Segments", "scripts/tocn.cgi?../m104/m104.txt");
courses[105] = new Course("Segment and Extent Management in Dictionary-Managed Tablespaces", "scripts/tocn.cgi?../m105/m105.txt");
courses[106] = new Course("Create, Use, and Manage Undo Tablespaces", "scripts/tocn.cgi?../m106/m106.txt");
courses[107] = new Course("Create, Use, and Manage Temporary Tablespaces", "scripts/tocn.cgi?../m107/m107.txt");
courses[108] = new Course("Create and Manage Rollback Segments", "scripts/tocn.cgi?../m108/m108.txt");
courses[109] = new Course("Introduction to Data Partitioning", "scripts/tocn.cgi?../m109/m109.txt");
courses[110] = new Course("Create Range-Partitioned Tables", "scripts/tocn.cgi?../m110/m110.txt");
courses[111] = new Course("Create Hash-Partitioned Tables", "scripts/tocn.cgi?../m111/m111.txt");
courses[112] = new Course("Create Composite-Partitioned Tables", "scripts/tocn.cgi?../m112/m112.txt");
courses[113] = new Course("Create Partitioned Indexes", "scripts/tocn.cgi?../m113/m113.txt");
courses[114] = new Course("Manage Partitioned Tables and Indexes", "scripts/tocn.cgi?../m114/m114.txt");
courses[115] = new Course("Understand Oracle ROWIDs", "scripts/tocn.cgi?../m115/m115.txt");
courses[116] = new Course("Create and Use Read-Only Tablespaces", "scripts/tocn.cgi?../m116/m116.txt");
courses[117] = new Course("Transport Tablespaces", "scripts/tocn.cgi?../m117/m117.txt");
courses[118] = new Course("Manage Database Instances and Sessions", "scripts/tocn.cgi?../m118/m118.txt");
courses[119] = new Course("Configure and Use Globalization Support", "scripts/tocn.cgi?../m119/m119.txt");
courses[120] = new Course("Overview of Application Tuning", "scripts/tocn.cgi?../m120/m120.txt");
courses[121] = new Course("Introduction to SQL Statement Processing", "scripts/tocn.cgi?../m121/m121.txt");
courses[122] = new Course("Introduction to Oracle's Optimizer", "scripts/tocn.cgi?../m122/m122.txt");
courses[123] = new Course("Gather Optimizer Statistics", "scripts/tocn.cgi?../m123/m123.txt");
courses[124] = new Course("Reveal SQL Statement Execution Plans", "scripts/tocn.cgi?../m124/m124.txt");
courses[125] = new Course("Create, Use, and Manage Normal Indexes", "scripts/tocn.cgi?../m125/m125.txt");
courses[126] = new Course("Create, Use, and Manage Bitmap Indexes", "scripts/tocn.cgi?../m126/m126.txt");
courses[127] = new Course("Create and Use Function-Based Indexes", "scripts/tocn.cgi?../m127/m127.txt");
courses[128] = new Course("Create, Use, and Manage Index-Organized Tables", "scripts/tocn.cgi?../m128/m128.txt");
courses[129] = new Course("Create, Use, and Manage Data Clusters", "scripts/tocn.cgi?../m129/m129.txt");
courses[130] = new Course("Create, Use, and Manage Hash Data Clusters", "scripts/tocn.cgi?../m130/m130.txt");
courses[131] = new Course("Influence Oracle's Optimizer", "scripts/tocn.cgi?../m131/m131.txt");
courses[132] = new Course("Trace Application SQL and the TKPROF Utility", "scripts/tocn.cgi?../m132/m132.txt");
courses[134] = new Course("Design Transactions for Performance", "scripts/tocn.cgi?../m134/m134.txt");
courses[135] = new Course("Tune Concurrent Database Access", "scripts/tocn.cgi?../m135/m135.txt");
courses[140] = new Course("Manage a Database's Control File", "scripts/tocn.cgi?../m140/m140.txt");
courses[141] = new Course("Configure a Database's Online Log", "scripts/tocn.cgi?../m141/m141.txt");
courses[142] = new Course("Configure Database Checkpoints", "scripts/tocn.cgi?../m142/m142.txt");
courses[143] = new Course("Configure a Database's Offline Log", "scripts/tocn.cgi?../m143/m143.txt");
courses[144] = new Course("Create Database and DDL Event Triggers", "scripts/tocn.cgi?../m144/m144.txt");
courses[145] = new Course("Use Export and Import", "scripts/tocn.cgi?../m145/m145.txt");
courses[146] = new Course("Use LogMiner", "scripts/tocn.cgi?../m146/m146.txt");
courses[147] = new Course("Configure and Use Parallel Execution", "scripts/tocn.cgi?../m147/m147.txt");
courses[150] = new Course("Introduction to Recovery Manager", "scripts/tocn.cgi?../m150/m150.txt");
courses[151] = new Course("Get Started with Recovery Manager", "scripts/tocn.cgi?../m151/m151.txt");
courses[152] = new Course("Back Up a Database with Recovery Manager", "scripts/tocn.cgi?../m152/m152.txt");
courses[153] = new Course("Manage Backups with Recovery Manager", "scripts/tocn.cgi?../m153/m153.txt");
courses[154] = new Course("Recover a Database with Recovery Manager", "scripts/tocn.cgi?../m154/m154.txt");
courses[155] = new Course("Use a Recovery Catalog with Recovery Manager", "scripts/tocn.cgi?../m155/m155.txt");
courses[156] = new Course("Advanced Recovery Manager Features", "scripts/tocn.cgi?../m156/m156.txt");
courses[157] = new Course("Introduction to Database Backup and Recovery", "scripts/tocn.cgi?../m157/m157.txt");
courses[158] = new Course("Back Up a Database", "scripts/tocn.cgi?../m158/m158.txt");
courses[159] = new Course("Recover a Database", "scripts/tocn.cgi?../m159/m159.txt");
courses[160] = new Course("Detect and Repair Data Block Corruptions", "scripts/tocn.cgi?../m160/m160.txt");
courses[161] = new Course("Perform Incomplete Database Recovery", "scripts/tocn.cgi?../m161/m161.txt");
courses[162] = new Course("Perform Tablespace Point-In-Time Recovery", "scripts/tocn.cgi?../m162/m162.txt");
courses[163] = new Course("Configure, Manage, and Activate a Standby Database", "scripts/tocn.cgi?../m163/m163.txt");
courses[164] = new Course("Introduction to Performance Tuning", "scripts/tocn.cgi?../m164/m164.txt");
courses[165] = new Course("Control the Optimizer", "scripts/tocn.cgi?../m165/m165.txt");
courses[166] = new Course("Design SQL Statements for Performance", "scripts/tocn.cgi?../m166/m166.txt");
courses[167] = new Course("Monitor and Trace SQL Statements", "scripts/tocn.cgi?../m167/m167.txt");
courses[168] = new Course("Design Transactions", "scripts/tocn.cgi?../m168/m168.txt");
courses[169] = new Course("Control and Monitor Data Locks", "scripts/tocn.cgi?../m169/m169.txt");
courses[170] = new Course("Introduction to Server Performance Tuning", "scripts/tocn.cgi?../m170/m170.txt");
courses[171] = new Course("Introduction to the Database Buffer Cache", "scripts/tocn.cgi?../m171/m171.txt");
courses[172] = new Course("Fundamental Database Buffer Cache Tuning", "scripts/tocn.cgi?../m172/m172.txt");
courses[173] = new Course("Configure Multiple Buffer Pools", "scripts/tocn.cgi?../m173/m173.txt");
courses[174] = new Course("open", "scripts/tocn.cgi?../m174/m174.txt"); // open
courses[175] = new Course("Introduction to the Shared Pool", "scripts/tocn.cgi?../m175/m175.txt");
courses[176] = new Course("Configure the Shared Pool", "scripts/tocn.cgi?../m176/m176.txt");
courses[177] = new Course("Tune Shared Pool Memory Allocation", "scripts/tocn.cgi?../m177/m177.txt");
courses[178] = new Course("Tune the Database Design", "scripts/tocn.cgi?../m178/m178.txt");
courses[179] = new Course("Miscellaneous SGA Tuning Topics", "scripts/tocn.cgi?../m179/m179.txt");
courses[180] = new Course("Tune Database I/O", "scripts/tocn.cgi?../m180/m180.txt");
courses[181] = new Course("Tune PGA Memory Allocation and Minimize Sort I/O", "scripts/tocn.cgi?../m181/m181.txt");
courses[182] = new Course("Use UTLBSTAT/UTLESTAT", "scripts/tocn.cgi?../m182/m182.txt");
courses[183] = new Course("Use OEM Events", "scripts/tocn.cgi?../m183/m183.txt");
courses[184] = new Course("Use Oracle Expert", "scripts/tocn.cgi?../m184/m184.txt");
courses[185] = new Course("Use Statspack", "scripts/tocn.cgi?../m185/m185.txt");
courses[186] = new Course("Create Materialized Views and Dimensions", "scripts/tocn.cgi?../m186/m186.txt");
courses[187] = new Course("Refresh Materialized Views", "scripts/tocn.cgi?../m187/m187.txt");
courses[188] = new Course("Configure and Tune Shared Server Settings", "scripts/tocn.cgi?../m188/m188.txt");
courses[189] = new Course("Use the Database Resource Manager", "scripts/tocn.cgi?../m189/m189.txt");
courses[190] = new Course("Introduction to TCP/IP Networks", "scripts/tocn.cgi?../m190/m190.txt");
courses[191] = new Course("Introduction to Oracle Net", "scripts/tocn.cgi?../m191/m191.txt");
courses[192] = new Course("Use Host Naming", "scripts/tocn.cgi?../m192/m192.txt");
courses[193] = new Course("Use Local Naming", "scripts/tocn.cgi?../m193/m193.txt");
courses[194] = new Course("Introduction to the Listener Process", "scripts/tocn.cgi?../m194/m194.txt");
courses[195] = new Course("Manually Configure a Listener", "scripts/tocn.cgi?../m195/m195.txt");
courses[196] = new Course("Use Multiple Listeners and Connection Load Balancing", "scripts/tocn.cgi?../m196/m196.txt");
courses[197] = new Course("Protect a Listener with a Password", "scripts/tocn.cgi?../m197/m197.txt");
courses[198] = new Course("Use the Default Listener and Dynamic Service Registration", "scripts/tocn.cgi?../m198/m198.txt");
courses[199] = new Course("Use Oracle Names", "scripts/tocn.cgi?../m199/m199.txt");
courses[200] = new Course("Use Connection Manager", "scripts/tocn.cgi?../m200/m200.txt");
courses[201] = new Course("Use Oracle Advanced Security", "scripts/tocn.cgi?../m201/m201.txt");
courses[202] = new Course("Monitor and Troubleshoot Network Connections", "scripts/tocn.cgi?../m202/m202.txt");

/******************************************************************************/

function mFrame(title, url) {
  this.title = title;
  this.url = url;
}

mFrames = new Array();
mFrames[0] =  new mFrame("Not Available","scripts/mainframe.cgi?0");
mFrames[1] =  new mFrame("Get Started ...","scripts/mainframe.cgi?1");
mFrames[2] =  new mFrame("... on Microsoft Windows NT/2000/XP","scripts/mainframe.cgi?2");
mFrames[3] =  new mFrame("... on Unix or Linux","scripts/mainframe.cgi?3");
mFrames[4] =  new mFrame("Oracle Fundamentals","scripts/mainframe.cgi?4");
mFrames[5] =  new mFrame("Basic Application Development","scripts/mainframe.cgi?5");
mFrames[6] =  new mFrame("SQL and SQL*Plus","scripts/mainframe.cgi?6");
mFrames[7] =  new mFrame("SQL","scripts/mainframe.cgi?7"); // deprecated
mFrames[8] =  new mFrame("PL/SQL","scripts/mainframe.cgi?8");
mFrames[9] =  new mFrame("Schemas","scripts/mainframe.cgi?9");
mFrames[10] =  new mFrame("Tables and Constraints","scripts/mainframe.cgi?10");
mFrames[11] =  new mFrame("Views","scripts/mainframe.cgi?11");
mFrames[12] =  new mFrame("Basic Database Administration","scripts/mainframe.cgi?12");
mFrames[13] =  new mFrame("DBA Fundamentals","scripts/mainframe.cgi?13");
mFrames[14] =  new mFrame("<font color=gray>Oracle Net Configuration</font>","scripts/mainframe.cgi?14");
mFrames[15] =  new mFrame("<font color=gray>Database Space Management</font>","scripts/mainframe.cgi?15");
mFrames[16] =  new mFrame("Database Security","scripts/mainframe.cgi?16");
mFrames[17] =  new mFrame("<font color=gray>Advanced Application Development</font>","scripts/mainframe.cgi?17");
mFrames[18] =  new mFrame("<font color=gray>Advanced Database Administration</font>","scripts/mainframe.cgi?18");
mFrames[19] =  new mFrame("Get Certified / Learn Oracle9i","scripts/mainframe.cgi?19");
mFrames[20] =  new mFrame("Oracle9i Certified Database Associate (OCA)","scripts/mainframe.cgi?20");
mFrames[21] =  new mFrame("Oracle9i Certified Professional Database Administrator (OCP)","scripts/mainframe.cgi?21");
mFrames[22] =  new mFrame("Database Creation","scripts/mainframe.cgi?22");
mFrames[23] =  new mFrame("Additional Database Configuration Topics","scripts/mainframe.cgi?23");
mFrames[24] =  new mFrame("Oracle Certified Internet Application Developer","scripts/mainframe.cgi?24");
mFrames[25] =  new mFrame("Oracle Certified Application Developer &#150; Release 2","scripts/mainframe.cgi?25");
mFrames[26] =  new mFrame("Exam 1 (1Z0-007) &#150; Introduction to Oracle9i: SQL","scripts/mainframe.cgi?26");
mFrames[27] =  new mFrame("Basic Application Administration","scripts/mainframe.cgi?27");
mFrames[28] =  new mFrame("Data Partitioning","scripts/mainframe.cgi?28");
mFrames[29] =  new mFrame("Database Backup and Recovery","scripts/mainframe.cgi?29");
mFrames[30] =  new mFrame("open","scripts/mainframe.cgi?30");
mFrames[31] =  new mFrame("Exam 2 (1Z0-031) &#150; Oracle9i Database: Fundamentals I","scripts/mainframe.cgi?31");
mFrames[32] =  new mFrame("Exam 3 (1Z0-032) &#150; Oracle9i Database: Fundamentals II","scripts/mainframe.cgi?32");
mFrames[33] =  new mFrame("Exam 4 (1Z0-033 )&#150; Oracle9i: Performance Tuning","scripts/mainframe.cgi?33");
mFrames[34] =  new mFrame("open","scripts/mainframe.cgi?34");
mFrames[35] =  new mFrame("Exam 2 &#150; Develop PL/SQL Program Units","scripts/mainframe.cgi?35");
mFrames[36] =  new mFrame("Indexes and Clusters","scripts/mainframe.cgi?36");
mFrames[37] =  new mFrame("Migration Information","scripts/mainframe.cgi?37");
mFrames[38] =  new mFrame("Migration Information","scripts/mainframe.cgi?38");
mFrames[39] =  new mFrame("Migration Information","scripts/mainframe.cgi?39");
mFrames[40] =  new mFrame("Migration Information","scripts/mainframe.cgi?40");
mFrames[41] =  new mFrame("Migration Information","scripts/mainframe.cgi?41");
mFrames[42] =  new mFrame("Migration Information","scripts/mainframe.cgi?42");
mFrames[43] =  new mFrame("Migration Information","scripts/mainframe.cgi?43");
mFrames[44] =  new mFrame("Migration Information","scripts/mainframe.cgi?44");
mFrames[45] =  new mFrame("Migration Information","scripts/mainframe.cgi?45");
mFrames[46] =  new mFrame("Migration Information","scripts/mainframe.cgi?46");
mFrames[47] =  new mFrame("Migration Information","scripts/mainframe.cgi?47");
mFrames[48] =  new mFrame("Oracle Enterprise Manager","scripts/mainframe.cgi?48");
mFrames[49] =  new mFrame("Database Storage","scripts/mainframe.cgi?49");
mFrames[50] =  new mFrame("Migration Information","scripts/mainframe.cgi?50");
mFrames[51] =  new mFrame("In Development","scripts/mainframe.cgi?51");
mFrames[52] =  new mFrame("Application Tuning","scripts/mainframe.cgi?52");
mFrames[53] =  new mFrame("DBA Utilities","scripts/mainframe.cgi?53");
mFrames[54] =  new mFrame("Redo Log and Control File Configuration","scripts/mainframe.cgi?54");
mFrames[55] =  new mFrame("Migration Information","scripts/mainframe.cgi?55");
mFrames[56] =  new mFrame("Not Available on this CD","scripts/mainframe.cgi?56");
mFrames[57] =  new mFrame("Transaction Log and Control File Configuration","scripts/mainframe.cgi?57");
mFrames[58] =  new mFrame("User-Managed Database Backup and Recovery","scripts/mainframe.cgi?58");
mFrames[59] =  new mFrame("Recovery Manager","scripts/mainframe.cgi?59");
mFrames[60] =  new mFrame("Miscellaneous Topics","scripts/mainframe.cgi?60");
mFrames[61] =  new mFrame("Migration Information","scripts/mainframe.cgi?61");
mFrames[62] =  new mFrame("Application Tuning","scripts/mainframe.cgi?62");
mFrames[63] =  new mFrame("Server Tuning","scripts/mainframe.cgi?63");
mFrames[64] =  new mFrame("Optimize SQL Statements","scripts/mainframe.cgi?64");
mFrames[65] =  new mFrame("Minimize Disk I/O","scripts/mainframe.cgi?65");
mFrames[66] =  new mFrame("OCP Survey&nbsp;<img src=images/new.gif border=0>","scripts/mainframe.cgi?66");
mFrames[67] =  new mFrame("OCP Survey Thanks","scripts/mainframe.cgi?67");
mFrames[68] =  new mFrame("Tune Server Memory","scripts/mainframe.cgi?68");
mFrames[69] =  new mFrame("open","scripts/mainframe.cgi?69");
mFrames[70] =  new mFrame("Tune Server I/O","scripts/mainframe.cgi?70");
mFrames[71] =  new mFrame("Use Server Tuning Utilities","scripts/mainframe.cgi?71");
mFrames[72] =  new mFrame("Basic Oracle Net Configuration","scripts/mainframe.cgi?72");
mFrames[73] =  new mFrame("Advanced Oracle Net Configuration","scripts/mainframe.cgi?73");
mFrames[74] =  new mFrame("Listener Configuration","scripts/mainframe.cgi?74");
mFrames[75] =  new mFrame("Network Configuration","scripts/mainframe.cgi?75");

/******************************************************************************/

function examInfo(title, url) {
  this.title = title;
  this.url = url;
}

examInfos = new Array();
examInfos[0] =  new mFrame("Not Available","scripts/examinfo.cgi?0");
examInfos[1] =  new mFrame("Introduction to Oracle9i: SQL<br>Exam 1Z0-007","scripts/examinfo.cgi?1");
examInfos[2] =  new mFrame("Develop PL/SQL Program Units","scripts/examinfo.cgi?2");
examInfos[3] =  new mFrame("Oracle9i Database: Fundamentals I<br>Exam 1Z0-037","scripts/examinfo.cgi?3");
examInfos[4] =  new mFrame("Oracle8: Database Administration","scripts/examinfo.cgi?4");
examInfos[5] =  new mFrame("Oracle9i Database: Fundamentals II<br>Exam 1Z0-032","scripts/examinfo.cgi?5");
examInfos[6] =  new mFrame("Oracle8: Backup and Recovery Workshop","scripts/examinfo.cgi?6");
examInfos[7] =  new mFrame("Oracle9i: Performance Tuning","scripts/examinfo.cgi?7");
examInfos[8] =  new mFrame("V$ View Reference Sheet","scripts/examinfo.cgi?8");
examInfos[9] =  new mFrame("Oracle8i: Network Administration","scripts/examinfo.cgi?9");
examInfos[10] =  new mFrame("Oracle8: Network Administration","scripts/examinfo.cgi?10");

/******************************************************************************/

// Top level menu

treeMenu.addItem(new TreeMenuItem("How to Use This Courseware", "howto.htm", "mainFrame"));
treeMenu.addItem(new TreeMenuItem(mFrames[1].title, mFrames[1].url, "mainFrame")); // Get Started
treeMenu.addItem(new TreeMenuItem(mFrames[19].title, mFrames[19].url, "mainFrame", "menu_folder_closed.gif")); // Get Certified
treeMenu.addItem(new TreeMenuItem("Search", mFrames[0].url, "mainFrame"));
//treeMenu.addItem(new TreeMenuItem("Oracle8i Specific", "scripts/search8i.cgi", "mainFrame"));
treeMenu.addItem(new TreeMenuItem("My Test Scores", mFrames[0].url, "mainFrame"));
//treeMenu.addItem(new TreeMenuItem("Release Notes (<font color=red>April-7-2003</font>)", "release.htm", "mainFrame"));
treeMenu.addItem(new TreeMenuItem("Oracle9i Error Messages", "http:\/\/www.dbdomain.com\/cwredirect.php?120", "_blank"));
treeMenu.addItem(new TreeMenuItem("Oracle9i Server Parameters", "http:\/\/www.dbdomain.com\/cwredirect.php?121", "_blank"));
treeMenu.addItem(new TreeMenuItem("Oracle9i Data Dictionary Views", "http:\/\/www.dbdomain.com\/cwredirect.php?122", "_blank"));
treeMenu.addItem(new TreeMenuItem("Oracle9i Glossary", "http:\/\/www.dbdomain.com\/cwredirect.php?123", "_blank"));

/******************************************************************************/

// Get Started submenu

var gs = new TreeMenu();
gs.addItem(new TreeMenuItem("Checklist", "checklist.htm", "mainFrame")); // checklist
gs.addItem(new TreeMenuItem(mFrames[2].title, mFrames[2].url, "mainFrame")); // Windows folder
gs.addItem(new TreeMenuItem(mFrames[3].title, mFrames[3].url, "mainFrame")); // Unix or Linux folder
treeMenu.items[1].makeSubmenu(gs);

// Get Started - Windows 2K/XP submenu

var gs_win = new TreeMenu();
gs_win.addItem(new TreeMenuItem(courses[1].title, courses[1].url, "mainFrame", "menu_link_ref.gif")); // What is Oracle?
//gs_win.addItem(new TreeMenuItem(courses[36].title, courses[36].url, "mainFrame", "menu_link_ref.gif")); // Install 9.0
gs_win.addItem(new TreeMenuItem(courses[99].title, courses[99].url, "mainFrame", "menu_link_ref.gif")); // Install 9.2
gs_win.addItem(new TreeMenuItem(courses[38].title, courses[38].url, "mainFrame", "menu_link_ref.gif")); // First Time
gs_win.addItem(new TreeMenuItem(courses[40].title, courses[40].url, "mainFrame", "menu_link_ref.gif")); // Introduction to Databases, SQL, and SQL*Plus
gs_win.addItem(new TreeMenuItem(courses[2].title, courses[2].url, "mainFrame", "menu_link_ref.gif")); // Intro to DB Structures
gs_win.addItem(new TreeMenuItem(courses[3].title, courses[3].url, "mainFrame", "menu_link_ref.gif")); // Intro to SQL
gs_win.addItem(new TreeMenuItem(courses[90].title, courses[90].url, "mainFrame", "menu_link_ref.gif")); // Intro to PL/SQL
gs_win.addItem(new TreeMenuItem(courses[4].title, courses[4].url, "mainFrame", "menu_link_ref.gif")); // Intro to DB Storage
gs_win.addItem(new TreeMenuItem(courses[5].title, courses[5].url, "mainFrame", "menu_link_ref.gif")); // Intro to Software Arch
gs.items[1].makeSubmenu(gs_win);

// Get Started - Linux submenu

var gs_lin = new TreeMenu();
gs_lin.addItem(new TreeMenuItem(courses[1].title, courses[1].url, "mainFrame", "menu_link_ref.gif")); // What is Oracle?
gs_lin.addItem(new TreeMenuItem("Install Oracle9i on Unix or Linux", "linux.htm", "mainFrame")); // Install Links
gs_lin.addItem(new TreeMenuItem(courses[41].title, courses[41].url, "mainFrame", "menu_link_ref.gif")); // First Time
gs_lin.addItem(new TreeMenuItem(courses[40].title, courses[40].url, "mainFrame", "menu_link_ref.gif")); // Introduction to Databases, SQL, and SQL*Plus
gs_lin.addItem(new TreeMenuItem(courses[2].title, courses[2].url, "mainFrame", "menu_link_ref.gif")); // Intro to DB Structures
gs_lin.addItem(new TreeMenuItem(courses[3].title, courses[3].url, "mainFrame", "menu_link_ref.gif")); // Intro to SQL
gs_lin.addItem(new TreeMenuItem(courses[90].title, courses[90].url, "mainFrame", "menu_link_ref.gif")); // Intro to PL/SQL
gs_lin.addItem(new TreeMenuItem(courses[4].title, courses[4].url, "mainFrame", "menu_link_ref.gif")); // Intro to DB Storage
gs_lin.addItem(new TreeMenuItem(courses[5].title, courses[5].url, "mainFrame", "menu_link_ref.gif")); // Intro to Software Arch
gs.items[2].makeSubmenu(gs_lin);


/******************************************************************************/

// Get Certified submenu

var getcertified = new TreeMenu();
getcertified.addItem(new TreeMenuItem(mFrames[20].title, mFrames[20].url, "mainFrame")); // Oracle9i OCA
getcertified.addItem(new TreeMenuItem(mFrames[21].title, mFrames[21].url, "mainFrame")); // Oracle9i OCP
treeMenu.items[2].makeSubmenu(getcertified);

/******************************************************************************/

// Get Certified - 9.0 Associate submenus

var oca = new TreeMenu();
oca.addItem(new TreeMenuItem(mFrames[26].title, mFrames[26].url, "mainFrame")); // Exam 1
oca.addItem(new TreeMenuItem(mFrames[31].title, mFrames[31].url, "mainFrame")); // Exam 2
getcertified.items[0].makeSubmenu(oca);

// Get Certified - 9.0 Professional submenus

var ocp = new TreeMenu();
ocp.addItem(new TreeMenuItem(mFrames[26].title, mFrames[26].url, "mainFrame")); // Exam 1
ocp.addItem(new TreeMenuItem(mFrames[31].title, mFrames[31].url, "mainFrame")); // Exam 2
ocp.addItem(new TreeMenuItem(mFrames[32].title, mFrames[32].url, "mainFrame")); // Exam 3
ocp.addItem(new TreeMenuItem(mFrames[33].title, mFrames[33].url, "mainFrame")); // Exam 4
getcertified.items[1].makeSubmenu(ocp);

/******************************************************************************/

// Exam 1

var exam1 = new TreeMenu();
exam1.addItem(new TreeMenuItem("Exam Tips", examInfos[1].url, "mainFrame"));
exam1.addItem(new TreeMenuItem(mFrames[4].title, mFrames[4].url, "mainFrame"));   // Fundamentals
exam1.addItem(new TreeMenuItem(mFrames[6].title, mFrames[6].url, "mainFrame"));   // Sql and SqlPlus
exam1.addItem(new TreeMenuItem(mFrames[8].title, mFrames[8].url, "mainFrame"));   //plsql
exam1.addItem(new TreeMenuItem(mFrames[9].title, mFrames[9].url, "mainFrame"));  // Schemas
exam1.addItem(new TreeMenuItem(mFrames[16].title, mFrames[16].url, "mainFrame")); // Security
oca.items[0].makeSubmenu(exam1);
ocp.items[0].makeSubmenu(exam1);

// Exam 1 - Oracle Fundamentals submenu

var fundamentals = new TreeMenu();
fundamentals.addItem(new TreeMenuItem(courses[1].title, courses[1].url, "mainFrame", "menu_link_ref.gif")); // What is Oracle?
fundamentals.addItem(new TreeMenuItem(courses[40].title, courses[40].url, "mainFrame", "menu_link_ref.gif")); // Introduction to Databases, SQL, and SQL*Plus
fundamentals.addItem(new TreeMenuItem(courses[2].title, courses[2].url, "mainFrame", "menu_link_ref.gif")); // Intro to DB Structures
fundamentals.addItem(new TreeMenuItem(courses[3].title, courses[3].url, "mainFrame", "menu_link_ref.gif")); // Intro to SQL
fundamentals.addItem(new TreeMenuItem(courses[90].title, courses[90].url, "mainFrame", "menu_link_ref.gif")); // Intro to PL/SQL
fundamentals.addItem(new TreeMenuItem(courses[4].title, courses[4].url, "mainFrame", "menu_link_ref.gif")); // Intro to DB Storage
fundamentals.addItem(new TreeMenuItem(courses[5].title, courses[5].url, "mainFrame", "menu_link_ref.gif")); // Intro to Software Arch
exam1.items[1].makeSubmenu(fundamentals);

// Exam 1 - SQL and SQL*Plus submenu

var sql = new TreeMenu();
sql.addItem(new TreeMenuItem(courses[43].title, courses[43].url, "mainFrame", "menu_link_ref.gif")); // Schema Intro
sql.addItem(new TreeMenuItem(courses[9].title,  courses[9].url,  "mainFrame", "menu_link_ref.gif")); // SELECT Intro
sql.addItem(new TreeMenuItem(courses[8].title,  courses[8].url,  "mainFrame", "menu_link_ref.gif")); // Basic Expressions
sql.addItem(new TreeMenuItem(courses[10].title, courses[10].url, "mainFrame", "menu_link_ref.gif")); // SQL Functions
sql.addItem(new TreeMenuItem(courses[33].title, courses[33].url, "mainFrame", "menu_link_ref.gif")); // Datetimes
sql.addItem(new TreeMenuItem(courses[11].title, courses[11].url, "mainFrame", "menu_link_ref.gif")); // Basic WHERE
sql.addItem(new TreeMenuItem(courses[34].title, courses[34].url, "mainFrame", "menu_link_ref.gif")); // Subqueries
sql.addItem(new TreeMenuItem(courses[12].title, courses[12].url, "mainFrame", "menu_link_ref.gif")); // Sort and Group
sql.addItem(new TreeMenuItem(courses[13].title, courses[13].url, "mainFrame", "menu_link_ref.gif")); // Joins
sql.addItem(new TreeMenuItem(courses[15].title, courses[15].url, "mainFrame", "menu_link_ref.gif")); // Misc Queries
sql.addItem(new TreeMenuItem(courses[14].title, courses[14].url, "mainFrame", "menu_link_ref.gif")); // DML
sql.addItem(new TreeMenuItem(courses[7].title, courses[7].url, "mainFrame", "menu_link_ref.gif")); // iSQL*Plus
sql.addItem(new TreeMenuItem(courses[57].title, courses[57].url, "mainFrame", "menu_link_ref.gif"));
// SQL Reference Pages
sql.addItem(new TreeMenuItem("Conditions", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/conditions.htm#1046093", "_blank")); // Conditions
sql.addItem(new TreeMenuItem("Datatypes", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/sql_elements2a.htm#45443", "_blank")); // Datatypes
sql.addItem(new TreeMenuItem("Expressions", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/expressions.htm#1037302", "_blank")); // Expressions
sql.addItem(new TreeMenuItem("Format Models", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/sql_elements4a.htm#34512", "_blank")); // Format Models
sql.addItem(new TreeMenuItem("Functions", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/functions.htm#1105837", "_blank")); // Functions
sql.addItem(new TreeMenuItem("Literals", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/sql_elements3a.htm#3305", "_blank")); // Literals
sql.addItem(new TreeMenuItem("Operators", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/operators.htm#1032225", "_blank")); // Operators
sql.addItem(new TreeMenuItem("Pseusocolumns", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/sql_elements6a.htm#27457", "_blank")); // Pseudocolumns
sql.addItem(new TreeMenuItem("Reserved Words", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96540\/ap_keywd.htm#617080", "_blank")); // Reserved Words
sql.addItem(new TreeMenuItem("Database Limits", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/server.920\/a96536\/ch4.htm#287874", "_blank")); // Database Limits
exam1.items[2].makeSubmenu(sql);

// Introduction to SQL and PL/SQL - PL/SQL submenu

var plsql = new TreeMenu();
plsql.addItem(new TreeMenuItem(courses[19].title, courses[19].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[20].title, courses[20].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[21].title, courses[21].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[22].title, courses[22].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[23].title, courses[23].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[24].title, courses[24].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[25].title, courses[25].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[26].title, courses[26].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[27].title, courses[27].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[28].title, courses[28].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[29].title, courses[29].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[30].title, courses[30].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[31].title, courses[31].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem(courses[32].title, courses[32].url, "mainFrame", "menu_link_ref.gif"));
plsql.addItem(new TreeMenuItem("PL/SQL Datatypes", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/appdev.920\/a96624\/03_types.htm#10519", "_blank"));
plsql.addItem(new TreeMenuItem("PL/SQL Expressions", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/appdev.920\/a96624\/02_funds.htm#3840", "_blank"));
plsql.addItem(new TreeMenuItem("PL/SQL Functions", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/appdev.920\/a96624\/02_funds.htm#4189", "_blank"));
plsql.addItem(new TreeMenuItem("PL/SQL Literals", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/appdev.920\/a96624\/02_funds.htm#2840", "_blank"));
plsql.addItem(new TreeMenuItem("PL/SQL Operators", "http:\/\/otn.oracle.com\/docs\/products\/oracle9i\/doc_library\/release2\/appdev.920\/a96624\/02_funds.htm#3840", "_blank"));
exam1.items[3].makeSubmenu(plsql);

// Exam 1 - Schemas submenu

var schemas = new TreeMenu();
//schemas.addItem(new TreeMenuItem(courses[43].title, courses[43].url, "mainFrame", "menu_link_ref.gif"));
schemas.addItem(new TreeMenuItem(mFrames[10].title, mFrames[10].url, "mainFrame")); //tables
schemas.addItem(new TreeMenuItem(mFrames[11].title, mFrames[11].url, "mainFrame")); //views
schemas.addItem(new TreeMenuItem(courses[50].title, courses[50].url, "mainFrame", "menu_link_ref.gif"));
schemas.addItem(new TreeMenuItem(courses[51].title, courses[51].url, "mainFrame", "menu_link_ref.gif"));
schemas.addItem(new TreeMenuItem(mFrames[36].title, mFrames[36].url, "mainFrame")); //indexes
exam1.items[4].makeSubmenu(schemas);

// Exam 1 - Schemas - Tables submenu

var schemas_tables = new TreeMenu();
schemas_tables.addItem(new TreeMenuItem(courses[42].title, courses[42].url, "mainFrame", "menu_link_ref.gif"));
schemas_tables.addItem(new TreeMenuItem(courses[54].title, courses[54].url, "mainFrame", "menu_link_ref.gif"));
schemas_tables.addItem(new TreeMenuItem(courses[44].title, courses[44].url, "mainFrame", "menu_link_ref.gif"));
schemas_tables.addItem(new TreeMenuItem(courses[45].title, courses[45].url, "mainFrame", "menu_link_ref.gif"));
schemas_tables.addItem(new TreeMenuItem(courses[55].title, courses[55].url, "mainFrame", "menu_link_ref.gif"));
schemas_tables.addItem(new TreeMenuItem(courses[56].title, courses[56].url, "mainFrame", "menu_link_ref.gif"));
schemas_tables.addItem(new TreeMenuItem(courses[16].title, courses[16].url, "mainFrame", "menu_link_ref.gif"));
schemas.items[0].makeSubmenu(schemas_tables);

// Exam 1 - Schemas - Views submenu

var schemas_views = new TreeMenu();
schemas_views.addItem(new TreeMenuItem(courses[47].title, courses[47].url, "mainFrame", "menu_link_ref.gif"));
schemas_views.addItem(new TreeMenuItem(courses[48].title, courses[48].url, "mainFrame", "menu_link_ref.gif"));
schemas_views.addItem(new TreeMenuItem(courses[49].title, courses[49].url, "mainFrame", "menu_link_ref.gif"));
schemas.items[1].makeSubmenu(schemas_views);

// Exam 1 - Schemas - Indexes submenu

var schemas_indexes = new TreeMenu();
schemas_indexes.addItem(new TreeMenuItem(courses[69].title, courses[69].url, "mainFrame", "menu_link_ref.gif"));
schemas_indexes.addItem(new TreeMenuItem(courses[70].title, courses[70].url, "mainFrame", "menu_link_ref.gif"));
schemas.items[4].makeSubmenu(schemas_indexes);

// Exam 1 - Database Security

var sec = new TreeMenu();
sec.addItem(new TreeMenuItem(courses[78].title, courses[78].url, "mainFrame", "menu_link_ref.gif"));
sec.addItem(new TreeMenuItem(courses[79].title, courses[79].url, "mainFrame", "menu_link_ref.gif"));
sec.addItem(new TreeMenuItem(courses[80].title, courses[80].url, "mainFrame", "menu_link_ref.gif"));
sec.addItem(new TreeMenuItem(courses[81].title, courses[81].url, "mainFrame", "menu_link_ref.gif"));
sec.addItem(new TreeMenuItem(courses[82].title, courses[82].url, "mainFrame", "menu_link_ref.gif"));
sec.addItem(new TreeMenuItem(courses[84].title, courses[84].url, "mainFrame", "menu_link_ref.gif"));
exam1.items[5].makeSubmenu(sec);

/******************************************************************************/

// Exam 2

var exam2 = new TreeMenu();
exam2.addItem(new TreeMenuItem("Exam Tips", examInfos[3].url, "mainFrame"));
exam2.addItem(new TreeMenuItem(mFrames[4].title, mFrames[4].url, "mainFrame"));   // Fundamentals
exam2.addItem(new TreeMenuItem(mFrames[13].title, mFrames[13].url, "mainFrame")); // DBA Fundamentals
exam2.addItem(new TreeMenuItem(mFrames[22].title, mFrames[22].url, "mainFrame")); // Database Creation
exam2.addItem(new TreeMenuItem(mFrames[54].title, mFrames[54].url, "mainFrame")); // Redo Log and Control File Configuration
exam2.addItem(new TreeMenuItem(mFrames[27].title, mFrames[27].url, "mainFrame")); // Basic Application Administration
exam2.addItem(new TreeMenuItem(mFrames[16].title, mFrames[16].url, "mainFrame")); // Database Security
exam2.addItem(new TreeMenuItem(mFrames[53].title, mFrames[53].url, "mainFrame")); // DBA Utilities
exam2.addItem(new TreeMenuItem(mFrames[49].title, mFrames[49].url, "mainFrame")); // Database Storage
exam2.addItem(new TreeMenuItem(mFrames[48].title, mFrames[48].url, "mainFrame")); // OEM
exam2.addItem(new TreeMenuItem(mFrames[23].title, mFrames[23].url, "mainFrame")); // Misc Database Configuration
oca.items[1].makeSubmenu(exam2);
ocp.items[1].makeSubmenu(exam2);

// Exam 2 - Oracle Fundamentals subment

exam2.items[1].makeSubmenu(fundamentals);

// Exam 2 - DBA Fundamentals submenu

var dbafun = new TreeMenu();
dbafun.addItem(new TreeMenuItem(courses[52].title, courses[52].url, "mainFrame", "menu_link_ref.gif"));
dbafun.addItem(new TreeMenuItem(courses[53].title, courses[53].url, "mainFrame", "menu_link_ref.gif"));
dbafun.addItem(new TreeMenuItem(courses[17].title, courses[17].url, "mainFrame", "menu_link_ref.gif"));
dbafun.addItem(new TreeMenuItem(courses[60].title, courses[60].url, "mainFrame", "menu_link_ref.gif"));
dbafun.addItem(new TreeMenuItem(courses[62].title, courses[62].url, "mainFrame", "menu_link_ref.gif"));
dbafun.addItem(new TreeMenuItem(courses[58].title, courses[58].url, "mainFrame", "menu_link_ref.gif"));
dbafun.addItem(new TreeMenuItem(courses[57].title, courses[57].url, "mainFrame", "menu_link_ref.gif"));
dbafun.addItem(new TreeMenuItem(courses[118].title, courses[118].url, "mainFrame", "menu_link_ref.gif"));
exam2.items[2].makeSubmenu(dbafun);

// Exam 2 - Database Creation submenu

var dbcreate = new TreeMenu();
dbcreate.addItem(new TreeMenuItem(courses[18].title, courses[18].url, "mainFrame", "menu_link_ref.gif")); // Intro
dbcreate.addItem(new TreeMenuItem(courses[98].title, courses[98].url, "mainFrame", "menu_link_ref.gif")); // DBCA
dbcreate.addItem(new TreeMenuItem(courses[61].title, courses[61].url, "mainFrame", "menu_link_ref.gif")); // Manual
dbcreate.addItem(new TreeMenuItem(courses[59].title, courses[59].url, "mainFrame", "menu_link_ref.gif")); // orapwd
exam2.items[3].makeSubmenu(dbcreate);

// Exam 2 - Redo Log and Control File Configuration submenu

var dbconfig = new TreeMenu();
dbconfig.addItem(new TreeMenuItem(courses[141].title, courses[141].url, "mainFrame", "menu_link_ref.gif"));
dbconfig.addItem(new TreeMenuItem(courses[142].title, courses[142].url, "mainFrame", "menu_link_ref.gif"));
dbconfig.addItem(new TreeMenuItem(courses[143].title, courses[143].url, "mainFrame", "menu_link_ref.gif"));
dbconfig.addItem(new TreeMenuItem(courses[140].title, courses[140].url, "mainFrame", "menu_link_ref.gif"));
exam2.items[4].makeSubmenu(dbconfig);

// Exam 2 - Basic Application Administration submenu

var app_admin = new TreeMenu();
app_admin.addItem(new TreeMenuItem(mFrames[9].title, mFrames[9].url, "mainFrame")); // schemas
app_admin.addItem(new TreeMenuItem(mFrames[52].title, mFrames[52].url, "mainFrame")); // tuning
exam2.items[5].makeSubmenu(app_admin);

// Exam 2 - Basic Application Administration -- Schemas submenu

var app_schemas = new TreeMenu();
app_schemas.addItem(new TreeMenuItem(mFrames[10].title, mFrames[10].url, "mainFrame")); //tables
app_schemas.addItem(new TreeMenuItem(mFrames[11].title, mFrames[11].url, "mainFrame")); //views
app_schemas.addItem(new TreeMenuItem(courses[50].title, courses[50].url, "mainFrame", "menu_link_ref.gif"));
app_schemas.addItem(new TreeMenuItem(courses[51].title, courses[51].url, "mainFrame", "menu_link_ref.gif"));
app_admin.items[0].makeSubmenu(app_schemas);

// Exam 2 - Basic Application Administration -- Schemas - Tables submenu

app_schemas.items[0].makeSubmenu(schemas_tables);

// Exam 2 - Basic Application Administration -- Schemas - Views submenu

app_schemas.items[1].makeSubmenu(schemas_views);

// Exam 2 - Basic Application Administration -- Tuning submenu

var app_tune = new TreeMenu();
app_tune.addItem(new TreeMenuItem(courses[120].title, courses[120].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[121].title, courses[121].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[122].title, courses[122].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[123].title, courses[123].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[124].title, courses[124].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[125].title, courses[125].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[126].title, courses[126].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[127].title, courses[127].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[128].title, courses[128].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[129].title, courses[129].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[130].title, courses[130].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[46].title, courses[46].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[168].title, courses[168].url, "mainFrame", "menu_link_ref.gif"));
app_tune.addItem(new TreeMenuItem(courses[169].title, courses[169].url, "mainFrame", "menu_link_ref.gif"));
app_admin.items[1].makeSubmenu(app_tune);

// Exam 2 - Database Security submenu

var sec2 = new TreeMenu();
sec2.addItem(new TreeMenuItem(courses[78].title, courses[78].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[79].title, courses[79].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[80].title, courses[80].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[81].title, courses[81].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[82].title, courses[82].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[84].title, courses[84].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[86].title, courses[86].url, "mainFrame", "menu_link_ref.gif"));
//sec.addItem(new TreeMenuItem(courses[83].title, mFrames[0].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[88].title, courses[88].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[189].title, courses[189].url, "mainFrame", "menu_link_ref.gif"));
sec2.addItem(new TreeMenuItem(courses[87].title, courses[87].url, "mainFrame", "menu_link_ref.gif"));
exam2.items[6].makeSubmenu(sec2);

// Exam 2 - DBA Utilities submenu

var dbautil = new TreeMenu();
dbautil.addItem(new TreeMenuItem(courses[63].title, courses[63].url, "mainFrame", "menu_link_ref.gif"));
dbautil.addItem(new TreeMenuItem(courses[145].title, courses[145].url, "mainFrame", "menu_link_ref.gif"));
dbautil.addItem(new TreeMenuItem(courses[146].title, courses[146].url, "mainFrame", "menu_link_ref.gif"));
exam2.items[7].makeSubmenu(dbautil);

// Exam 2 - Database Storage submenu

var dbastor = new TreeMenu();
dbastor.addItem(new TreeMenuItem(courses[100].title, courses[100].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[101].title, courses[101].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[102].title, courses[102].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[103].title, courses[103].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[105].title, courses[105].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[104].title, courses[104].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[107].title, courses[107].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[106].title, courses[106].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[108].title, courses[108].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[85].title, courses[85].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[64].title, courses[64].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[65].title, courses[65].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[89].title, courses[89].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[116].title, courses[116].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(mFrames[28].title, mFrames[28].url, "mainFrame")); // partitioning
dbastor.addItem(new TreeMenuItem(courses[115].title, courses[115].url, "mainFrame", "menu_link_ref.gif"));
dbastor.addItem(new TreeMenuItem(courses[117].title, courses[117].url, "mainFrame", "menu_link_ref.gif"));
exam2.items[8].makeSubmenu(dbastor);

// Exam 2 - Database Storage - Data Partitioning submenu

var partition = new TreeMenu();
partition.addItem(new TreeMenuItem(courses[109].title, courses[109].url, "mainFrame", "menu_link_ref.gif"));
partition.addItem(new TreeMenuItem(courses[110].title, courses[110].url, "mainFrame", "menu_link_ref.gif"));
partition.addItem(new TreeMenuItem(courses[111].title, courses[111].url, "mainFrame", "menu_link_ref.gif"));
partition.addItem(new TreeMenuItem(courses[112].title, courses[112].url, "mainFrame", "menu_link_ref.gif"));
partition.addItem(new TreeMenuItem(courses[113].title, courses[113].url, "mainFrame", "menu_link_ref.gif"));
partition.addItem(new TreeMenuItem(courses[114].title, courses[114].url, "mainFrame", "menu_link_ref.gif"));
dbastor.items[14].makeSubmenu(partition);

// Exam 2 - OEM submenu

var oem = new TreeMenu();
oem.addItem(new TreeMenuItem(courses[92].title, courses[92].url, "mainFrame", "menu_link_ref.gif"));
oem.addItem(new TreeMenuItem(courses[93].title, courses[93].url, "mainFrame", "menu_link_ref.gif"));
oem.addItem(new TreeMenuItem(courses[94].title, courses[94].url, "mainFrame", "menu_link_ref.gif"));
exam2.items[9].makeSubmenu(oem);

// Exam 2 - Miscellaneous Topics submenu

var exam2misc = new TreeMenu();
exam2misc.addItem(new TreeMenuItem(courses[144].title, courses[144].url, "mainFrame", "menu_link_ref.gif"));
exam2misc.addItem(new TreeMenuItem(courses[119].title, courses[119].url, "mainFrame", "menu_link_ref.gif"));
exam2misc.addItem(new TreeMenuItem(courses[147].title, courses[147].url, "mainFrame", "menu_link_ref.gif"));
exam2misc.addItem(new TreeMenuItem(courses[188].title, courses[188].url, "mainFrame", "menu_link_ref.gif"));
exam2misc.addItem(new TreeMenuItem(courses[66].title, courses[66].url, "mainFrame", "menu_link_ref.gif"));
exam2misc.addItem(new TreeMenuItem(courses[67].title, courses[67].url, "mainFrame", "menu_link_ref.gif"));
exam2.items[10].makeSubmenu(exam2misc);

/******************************************************************************/

// Exam 3 

var exam3 = new TreeMenu();
exam3.addItem(new TreeMenuItem("Exam Tips", examInfos[5].url, "mainFrame"));
exam3.addItem(new TreeMenuItem(mFrames[75].title, mFrames[75].url, "mainFrame")); // Network Configuration
exam3.addItem(new TreeMenuItem(mFrames[29].title, mFrames[29].url, "mainFrame")); // Database Backup and Recovery
ocp.items[2].makeSubmenu(exam3);

// Get Certified - DBA - Exam 3 Networking submenus

var net = new TreeMenu();
net.addItem(new TreeMenuItem(courses[190].title, courses[190].url, "mainFrame", "menu_link_ref.gif")); // TCP/IP Networks
net.addItem(new TreeMenuItem(courses[191].title, courses[191].url, "mainFrame", "menu_link_ref.gif")); // Intro to Net
net.addItem(new TreeMenuItem(mFrames[72].title, mFrames[72].url, "mainFrame")); // Basic Net Config
net.addItem(new TreeMenuItem(mFrames[74].title, mFrames[74].url, "mainFrame")); // Listener Config
//net.addItem(new TreeMenuItem(mFrames[73].title, mFrames[73].url, "mainFrame")); // Advanced Net Config
net.addItem(new TreeMenuItem(courses[202].title, courses[202].url, "mainFrame", "menu_link_ref.gif")); // Troubleshoot
exam3.items[1].makeSubmenu(net);

// Get Certified - DBA - Exam 3 Networking - Basic Configuration submenu

var basicnet = new TreeMenu();
basicnet.addItem(new TreeMenuItem(courses[192].title, courses[192].url, "mainFrame", "menu_link_ref.gif")); // Host Naming
basicnet.addItem(new TreeMenuItem(courses[193].title, courses[193].url, "mainFrame", "menu_link_ref.gif")); // Local Naming
basicnet.addItem(new TreeMenuItem(courses[188].title, courses[188].url, "mainFrame", "menu_link_ref.gif")); // MTS
net.items[2].makeSubmenu(basicnet);

// Get Certified - DBA - Exam 3 Networking - Listener submenu

var listener = new TreeMenu();
listener.addItem(new TreeMenuItem(courses[194].title, courses[194].url, "mainFrame", "menu_link_ref.gif")); // Intro
listener.addItem(new TreeMenuItem(courses[198].title, courses[198].url, "mainFrame", "menu_link_ref.gif")); // Default
listener.addItem(new TreeMenuItem(courses[195].title, courses[195].url, "mainFrame", "menu_link_ref.gif")); // Manual
listener.addItem(new TreeMenuItem(courses[196].title, courses[196].url, "mainFrame", "menu_link_ref.gif")); // Two Listeners
listener.addItem(new TreeMenuItem(courses[197].title, courses[197].url, "mainFrame", "menu_link_ref.gif")); // Password
net.items[3].makeSubmenu(listener);

// Get Certified - DBA - Exam 3 Networking - Advanced Configuration submenu

//var advnet = new TreeMenu();
//advnet.addItem(new TreeMenuItem(courses[199].title, courses[199].url, "mainFrame", "menu_link_ref.gif")); // Names
//advnet.addItem(new TreeMenuItem(courses[200].title, courses[200].url, "mainFrame", "menu_link_ref.gif")); // CMAN
//advnet.addItem(new TreeMenuItem(courses[201].title, courses[201].url, "mainFrame", "menu_link_ref.gif")); // ASO
//net.items[4].makeSubmenu(advnet);

// Exam 3 - Database Backup and Recovery submenu

var protect = new TreeMenu();
protect.addItem(new TreeMenuItem(courses[157].title, courses[157].url, "mainFrame", "menu_link_ref.gif")); // Introduction
protect.addItem(new TreeMenuItem(mFrames[54].title, mFrames[54].url, "mainFrame")); // Transaction Log Configuration
protect.addItem(new TreeMenuItem(mFrames[58].title, mFrames[58].url, "mainFrame")); // Backup and Recovery without Recovery Manager
protect.addItem(new TreeMenuItem(mFrames[59].title, mFrames[59].url, "mainFrame")); // Backup and Recovery with Recovery Manager
protect.addItem(new TreeMenuItem(mFrames[60].title, mFrames[60].url, "mainFrame")); // Miscellaneous Topics
exam3.items[2].makeSubmenu(protect);
//exam3.addItem(new TreeMenuItem(courses[163].title, courses[163].url, "mainFrame", "menu_link_ref.gif")); // Standby Database

// Exam 3 - Redo Log and Control File Configuration submenu

protect.items[1].makeSubmenu(dbconfig);

// Exam 3 - Physical Backup and Recovery submenu

var userbackup = new TreeMenu();
userbackup.addItem(new TreeMenuItem(courses[158].title, courses[158].url, "mainFrame", "menu_link_ref.gif")); // Physical Backup
userbackup.addItem(new TreeMenuItem(courses[160].title, courses[160].url, "mainFrame", "menu_link_ref.gif")); // Block Corruption
userbackup.addItem(new TreeMenuItem(courses[159].title, courses[159].url, "mainFrame", "menu_link_ref.gif")); // Physical Recovery
userbackup.addItem(new TreeMenuItem(courses[161].title, courses[161].url, "mainFrame", "menu_link_ref.gif")); // Advanced Recovery
protect.items[2].makeSubmenu(userbackup);

// Exam 3 - Recovery Manager submenu

var rman = new TreeMenu();
rman.addItem(new TreeMenuItem(courses[150].title, courses[150].url, "mainFrame", "menu_link_ref.gif"));
rman.addItem(new TreeMenuItem(courses[151].title, courses[151].url, "mainFrame", "menu_link_ref.gif"));
rman.addItem(new TreeMenuItem(courses[152].title, courses[152].url, "mainFrame", "menu_link_ref.gif"));
rman.addItem(new TreeMenuItem(courses[153].title, courses[153].url, "mainFrame", "menu_link_ref.gif"));
rman.addItem(new TreeMenuItem(courses[68].title, courses[68].url, "mainFrame", "menu_link_ref.gif"));
rman.addItem(new TreeMenuItem(courses[154].title, courses[154].url, "mainFrame", "menu_link_ref.gif"));
rman.addItem(new TreeMenuItem(courses[155].title, courses[155].url, "mainFrame", "menu_link_ref.gif"));
rman.addItem(new TreeMenuItem(courses[156].title, courses[156].url, "mainFrame", "menu_link_ref.gif"));
protect.items[3].makeSubmenu(rman);

// Exam 3 - Miscellaneous Topics submenu

var recovermisc = new TreeMenu();
recovermisc.addItem(new TreeMenuItem(courses[63].title, courses[63].url, "mainFrame", "menu_link_ref.gif")); // Loader
recovermisc.addItem(new TreeMenuItem(courses[145].title, courses[145].url, "mainFrame", "menu_link_ref.gif")); // Exp and Imp
recovermisc.addItem(new TreeMenuItem(courses[146].title, courses[146].url, "mainFrame", "menu_link_ref.gif")); // Log Miner
//recovermisc.addItem(new TreeMenuItem(courses[162].title, courses[162].url, "mainFrame", "menu_link_ref.gif")); // TSPITR
protect.items[4].makeSubmenu(recovermisc);

/******************************************************************************/

// Exam 4 

var exam4 = new TreeMenu();
exam4.addItem(new TreeMenuItem("Exam Tips", examInfos[7].url, "mainFrame"));
exam4.addItem(new TreeMenuItem(courses[164].title, courses[164].url, "mainFrame", "menu_link_ref.gif")); // Introduction
exam4.addItem(new TreeMenuItem(mFrames[62].title, mFrames[62].url, "mainFrame")); // Application Tuning
exam4.addItem(new TreeMenuItem(mFrames[63].title, mFrames[63].url, "mainFrame")); // Server Tuning
exam4.addItem(new TreeMenuItem(examInfos[8].title, examInfos[8].url, "mainFrame")); // V$ Views
ocp.items[3].makeSubmenu(exam4);

// Exam 4 - Application Tuning submenu

var app_tune9i2 = new TreeMenu();
app_tune9i2.addItem(new TreeMenuItem(courses[120].title, courses[120].url, "mainFrame", "menu_link_ref.gif")); // Intro
app_tune9i2.addItem(new TreeMenuItem(courses[121].title, courses[121].url, "mainFrame", "menu_link_ref.gif")); // SQL processing
app_tune9i2.addItem(new TreeMenuItem(courses[166].title, courses[166].url, "mainFrame", "menu_link_ref.gif")); // Design SQL
app_tune9i2.addItem(new TreeMenuItem(mFrames[64].title, mFrames[64].url, "mainFrame")); // Optimize menu
app_tune9i2.addItem(new TreeMenuItem(courses[167].title, courses[167].url, "mainFrame", "menu_link_ref.gif")); // Monitor SQL
app_tune9i2.addItem(new TreeMenuItem(courses[168].title, courses[168].url, "mainFrame", "menu_link_ref.gif")); // Transactions
app_tune9i2.addItem(new TreeMenuItem(courses[169].title, courses[169].url, "mainFrame", "menu_link_ref.gif")); // Locking
app_tune9i2.addItem(new TreeMenuItem(mFrames[65].title, mFrames[65].url, "mainFrame")); // Disk I/O menu
exam4.items[2].makeSubmenu(app_tune9i2);

// Exam 4 - Application Tuning - Optimize submenu

var optimize9i = new TreeMenu();
optimize9i.addItem(new TreeMenuItem(courses[122].title, courses[122].url, "mainFrame", "menu_link_ref.gif"));
optimize9i.addItem(new TreeMenuItem(courses[123].title, courses[123].url, "mainFrame", "menu_link_ref.gif"));
optimize9i.addItem(new TreeMenuItem(courses[124].title, courses[124].url, "mainFrame", "menu_link_ref.gif"));
optimize9i.addItem(new TreeMenuItem(courses[165].title, courses[165].url, "mainFrame", "menu_link_ref.gif"));
app_tune9i2.items[3].makeSubmenu(optimize9i);

// Exam 4 - Application Tuning - Disk I/O submenu

var diskio9i = new TreeMenu();
diskio9i.addItem(new TreeMenuItem(courses[125].title, courses[125].url, "mainFrame", "menu_link_ref.gif"));
diskio9i.addItem(new TreeMenuItem(courses[126].title, courses[126].url, "mainFrame", "menu_link_ref.gif"));
diskio9i.addItem(new TreeMenuItem(courses[127].title, courses[127].url, "mainFrame", "menu_link_ref.gif"));
diskio9i.addItem(new TreeMenuItem(courses[128].title, courses[128].url, "mainFrame", "menu_link_ref.gif"));
diskio9i.addItem(new TreeMenuItem(courses[129].title, courses[129].url, "mainFrame", "menu_link_ref.gif"));
diskio9i.addItem(new TreeMenuItem(courses[130].title, courses[130].url, "mainFrame", "menu_link_ref.gif"));
diskio9i.addItem(new TreeMenuItem(courses[186].title, courses[186].url, "mainFrame", "menu_link_ref.gif"));
diskio9i.addItem(new TreeMenuItem(courses[187].title, courses[187].url, "mainFrame", "menu_link_ref.gif"));
app_tune9i2.items[7].makeSubmenu(diskio9i);

// Exam 4 - Server Tuning submenu

var server_tune9i = new TreeMenu();
server_tune9i.addItem(new TreeMenuItem(courses[170].title, courses[170].url, "mainFrame", "menu_link_ref.gif")); // OS Tuning
server_tune9i.addItem(new TreeMenuItem(mFrames[68].title, mFrames[68].url, "mainFrame")); // Memory
server_tune9i.addItem(new TreeMenuItem(mFrames[70].title, mFrames[70].url, "mainFrame")); // Database I/O
server_tune9i.addItem(new TreeMenuItem(mFrames[71].title, mFrames[71].url, "mainFrame")); // Utilities
server_tune9i.addItem(new TreeMenuItem(courses[188].title, courses[188].url, "mainFrame", "menu_link_ref.gif")); // MTS
exam4.items[3].makeSubmenu(server_tune9i);

// Exam 4 - Server Tuning - Memory submenu

var dbmem_tune9i = new TreeMenu();
dbmem_tune9i.addItem(new TreeMenuItem(courses[71].title, courses[71].url, "mainFrame", "menu_link_ref.gif")); // SGA Intro
dbmem_tune9i.addItem(new TreeMenuItem(courses[175].title, courses[175].url, "mainFrame", "menu_link_ref.gif")); // SP Intro
dbmem_tune9i.addItem(new TreeMenuItem(courses[176].title, courses[176].url, "mainFrame", "menu_link_ref.gif")); // SP Basic
dbmem_tune9i.addItem(new TreeMenuItem(courses[177].title, courses[177].url, "mainFrame", "menu_link_ref.gif")); // SP Advanced
dbmem_tune9i.addItem(new TreeMenuItem(courses[171].title, courses[171].url, "mainFrame", "menu_link_ref.gif")); // DB Intro
dbmem_tune9i.addItem(new TreeMenuItem(courses[172].title, courses[172].url, "mainFrame", "menu_link_ref.gif")); // DB Tune
dbmem_tune9i.addItem(new TreeMenuItem(courses[173].title, courses[173].url, "mainFrame", "menu_link_ref.gif")); // DB Multiple Pools
dbmem_tune9i.addItem(new TreeMenuItem(courses[179].title, courses[179].url, "mainFrame", "menu_link_ref.gif")); // Misc Topics
server_tune9i.items[1].makeSubmenu(dbmem_tune9i);

// Exam 4 - Server Tuning - I/O submenu

var dbio_tune9i = new TreeMenu();
dbio_tune9i.addItem(new TreeMenuItem(courses[178].title, courses[178].url, "mainFrame", "menu_link_ref.gif")); // Design
dbio_tune9i.addItem(new TreeMenuItem(courses[180].title, courses[180].url, "mainFrame", "menu_link_ref.gif")); // I/O
dbio_tune9i.addItem(new TreeMenuItem(courses[142].title, courses[142].url, "mainFrame", "menu_link_ref.gif")); // Checkpoints
dbio_tune9i.addItem(new TreeMenuItem(courses[103].title, courses[103].url, "mainFrame", "menu_link_ref.gif")); // Basic Seg
dbio_tune9i.addItem(new TreeMenuItem(courses[104].title, courses[104].url, "mainFrame", "menu_link_ref.gif")); // Reclaim Unused Seg Space
dbio_tune9i.addItem(new TreeMenuItem(courses[107].title, courses[107].url, "mainFrame", "menu_link_ref.gif")); // Temp TS
dbio_tune9i.addItem(new TreeMenuItem(courses[181].title, courses[181].url, "mainFrame", "menu_link_ref.gif")); // Sorting
dbio_tune9i.addItem(new TreeMenuItem(courses[106].title, courses[106].url, "mainFrame", "menu_link_ref.gif")); // Undo TS
dbio_tune9i.addItem(new TreeMenuItem(courses[108].title, courses[108].url, "mainFrame", "menu_link_ref.gif")); // Rollback Seg
dbio_tune9i.addItem(new TreeMenuItem(courses[85].title, courses[85].url, "mainFrame", "menu_link_ref.gif")); // Blocks
dbio_tune9i.addItem(new TreeMenuItem(courses[64].title, courses[64].url, "mainFrame", "menu_link_ref.gif")); // Manual Seg
dbio_tune9i.addItem(new TreeMenuItem(courses[65].title, courses[65].url, "mainFrame", "menu_link_ref.gif")); // Auto Seg
dbio_tune9i.addItem(new TreeMenuItem(courses[89].title, courses[89].url, "mainFrame", "menu_link_ref.gif")); // Chaining
dbio_tune9i.addItem(new TreeMenuItem(courses[109].title, courses[109].url, "mainFrame", "menu_link_ref.gif")); // Intro to Partitioning
dbio_tune9i.addItem(new TreeMenuItem(courses[110].title, courses[110].url, "mainFrame", "menu_link_ref.gif")); // Range Partitioning
dbio_tune9i.addItem(new TreeMenuItem(courses[111].title, courses[111].url, "mainFrame", "menu_link_ref.gif")); // Hash Partitioning
dbio_tune9i.addItem(new TreeMenuItem(courses[112].title, courses[112].url, "mainFrame", "menu_link_ref.gif")); // Composite Partitioning
dbio_tune9i.addItem(new TreeMenuItem(courses[113].title, courses[113].url, "mainFrame", "menu_link_ref.gif")); // Index Partitioning
dbio_tune9i.addItem(new TreeMenuItem(courses[114].title, courses[114].url, "mainFrame", "menu_link_ref.gif")); // Manage Partitioning
server_tune9i.items[2].makeSubmenu(dbio_tune9i);

// Exam 4 - Server Tuning - Utilities submenu

var utils_tune9i = new TreeMenu();
utils_tune9i.addItem(new TreeMenuItem(courses[58].title, courses[58].url, "mainFrame", "menu_link_ref.gif")); // trace and alert
utils_tune9i.addItem(new TreeMenuItem(courses[182].title, courses[182].url, "mainFrame", "menu_link_ref.gif")); // UTLBSTAT
utils_tune9i.addItem(new TreeMenuItem(courses[185].title, courses[185].url, "mainFrame", "menu_link_ref.gif")); // Statspack
utils_tune9i.addItem(new TreeMenuItem(courses[184].title, courses[184].url, "mainFrame", "menu_link_ref.gif")); // Expert
utils_tune9i.addItem(new TreeMenuItem(courses[183].title, courses[183].url, "mainFrame", "menu_link_ref.gif")); // OEM
utils_tune9i.addItem(new TreeMenuItem(courses[189].title, courses[189].url, "mainFrame", "menu_link_ref.gif")); // Resource Manager
server_tune9i.items[3].makeSubmenu(utils_tune9i);

/******************************************************************************/