/****************************************************************************** * 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 = "10_007"; // 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 = "Oracle Database 10g CertPLUS"; // 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?", "cgi-bin/toc.cgi?../001/001.txt"); courses[2] = new Course("Introduction to Oracle Database Structures", "cgi-bin/toc.cgi?../002/002.txt"); courses[3] = new Course("Introduction to SQL", "cgi-bin/toc.cgi?../003/003.txt"); courses[4] = new Course("Introduction to Oracle Database Storage", "cgi-bin/toc.cgi?../004/004.txt"); courses[5] = new Course("Introduction to Oracle Software Architecture", "cgi-bin/toc.cgi?../005/005.txt"); courses[6] = new Course("Introduction to Databases and SQL*Plus", "cgi-bin/toc.cgi?../006/006.txt"); courses[7] = new Course("Basic iSQL*Plus Commands", "cgi-bin/toc.cgi?../007/007.txt"); courses[8] = new Course("Build Basic SELECT Clause Expressions", "cgi-bin/toc.cgi?../008/008.txt"); courses[9] = new Course("Introduction to the SELECT Statement", "cgi-bin/toc.cgi?../009/009.txt"); courses[10] = new Course("Build SELECT Clause Expressions with SQL Functions", "cgi-bin/toc.cgi?../010/010.txt"); courses[11] = new Course("Build Basic WHERE Clause Conditions", "cgi-bin/toc.cgi?../011/011.txt"); courses[12] = new Course("Organize Query Results with Sorting and Grouping", "cgi-bin/toc.cgi?../012/012.txt"); courses[13] = new Course("Join Related Data", "cgi-bin/toc.cgi?../013/013.txt"); courses[14] = new Course("Manipulate Data with DML Statements and Transactions", "cgi-bin/toc.cgi?../014/014.txt"); courses[15] = new Course("Build Miscellaneous Types of Queries", "cgi-bin/toc.cgi?../015/015.txt"); courses[16] = new Course("Create, Use, and Manage External Tables", "cgi-bin/toc.cgi?../016/016.txt"); courses[17] = new Course("Configure iSQL*Plus for Privileged DBA Connections", "cgi-bin/toc.cgi?../017/017.txt"); courses[18] = new Course("Introduction to Database Creation", "cgi-bin/toc.cgi?../018/018.txt"); //PLSQL Courses courses[19] = new Course("Introduction to PL/SQL", "cgi-bin/toc.cgi?../019/019.txt"); courses[20] = new Course("Program Variables and Constants", "cgi-bin/toc.cgi?../020/020.txt"); courses[21] = new Course("Flow Control Statements", "cgi-bin/toc.cgi?../021/021.txt"); courses[22] = new Course("Database Access and Record Types", "cgi-bin/toc.cgi?../022/022.txt"); courses[23] = new Course("Subprograms: Procedures and Functions", "cgi-bin/toc.cgi?../023/023.txt"); courses[24] = new Course("Cursors", "cgi-bin/toc.cgi?../024/024.txt"); courses[25] = new Course("Collections", "cgi-bin/toc.cgi?../025/025.txt"); courses[26] = new Course("Exceptions and Exception Handlers ", "cgi-bin/toc.cgi?../026/026.txt"); courses[27] = new Course("Stored Procedures and Functions ", "cgi-bin/toc.cgi?../027/027.txt"); courses[28] = new Course("Packages", "cgi-bin/toc.cgi?../028/028.txt"); courses[29] = new Course("Database Triggers", "cgi-bin/toc.cgi?../029/029.txt"); courses[30] = new Course("PL/SQL Debugging", "cgi-bin/toc.cgi?../030/030.txt"); courses[31] = new Course("Dependency Management", "cgi-bin/toc.cgi?../031/031.txt"); courses[32] = new Course("Miscellaneous PL/SQL Topics", "cgi-bin/toc.cgi?../032/032.txt"); courses[33] = new Course("Work with Datetimes and Intervals", "cgi-bin/toc.cgi?../033/033.txt"); courses[34] = new Course("Work with Subqueries", "cgi-bin/toc.cgi?../034/034.txt"); courses[35] = new Course("Configure Database Control Administrator Settings", "cgi-bin/toc.cgi?../035/035.txt"); courses[36] = new Course("Install Oracle Database 10g Release 2 Enterprise Edition on Microsoft Windows", "cgi-bin/toc.cgi?../036/036.txt"); courses[37] = new Course("Manage Schema Objects with Database Control", "cgi-bin/toc.cgi?../037/037.txt"); courses[38] = new Course("Prepare to Use Oracle Database 10g Enterprise Edition on Microsoft Windows", "cgi-bin/toc.cgi?../038/038.txt"); courses[39] = new Course("open", "cgi-bin/toc.cgi?../039/039.txt"); courses[40] = new Course("Introduction to Databases and SQL*Plus", "cgi-bin/toc.cgi?../040/040.txt"); courses[41] = new Course("Prepare to Use Oracle Database 10g Enterprise Edition on Unix or Linux", "cgi-bin/toc.cgi?../041/041.txt"); courses[42] = new Course("Create and Use Tables", "cgi-bin/toc.cgi?../042/042.txt"); courses[43] = new Course("Introduction to Schemas", "cgi-bin/toc.cgi?../043/043.txt"); courses[44] = new Course("Design Tables", "cgi-bin/toc.cgi?../044/044.txt"); courses[45] = new Course("Manage Tables", "cgi-bin/toc.cgi?../045/045.txt"); courses[46] = new Course("Create and Use Temporary Tables", "cgi-bin/toc.cgi?../046/046.txt"); courses[47] = new Course("Create and Use Views", "cgi-bin/toc.cgi?../047/047.txt"); courses[48] = new Course("Create Updateable Views and INSTEAD OF Triggers", "cgi-bin/toc.cgi?../048/048.txt"); courses[49] = new Course("Manage Views", "cgi-bin/toc.cgi?../049/049.txt"); courses[50] = new Course("Create, Use, and Manage Sequences", "cgi-bin/toc.cgi?../050/050.txt"); courses[51] = new Course("Create, Use, and Manage Synonyms", "cgi-bin/toc.cgi?../051/051.txt"); courses[52] = new Course("Overview of Oracle Database Administration", "cgi-bin/toc.cgi?../052/052.txt"); courses[53] = new Course("Maintain Database Administrator Security", "cgi-bin/toc.cgi?../053/053.txt"); courses[54] = new Course("Create Tables with Integrity Constraints", "cgi-bin/toc.cgi?../054/054.txt"); courses[55] = new Course("Create Deferrable Integrity Constraints", "cgi-bin/toc.cgi?../055/055.txt"); courses[56] = new Course("Enable and Disable Constraints", "cgi-bin/toc.cgi?../056/056.txt"); courses[57] = new Course("Query the Data Dictionary", "cgi-bin/toc.cgi?../057/057.txt"); courses[58] = new Course("Monitor Database Trace Files", "cgi-bin/toc.cgi?../058/058.txt"); courses[59] = new Course("Configure a Database Password File", "cgi-bin/toc.cgi?../059/059.txt"); courses[60] = new Course("Manage Database Initialization Parameter Files", "cgi-bin/toc.cgi?../060/060.txt"); courses[61] = new Course("Create a Database Manually", "cgi-bin/toc.cgi?../061/061.txt"); courses[62] = new Course("Start Up and Shut Down Oracle", "cgi-bin/toc.cgi?../062/062.txt"); courses[63] = new Course("Use SQL*Loader", "cgi-bin/toc.cgi?../063/063.txt"); courses[64] = new Course("Use Manual Segment Space Management", "cgi-bin/toc.cgi?../064/064.txt"); courses[65] = new Course("Use Automatic Segment Space Management", "cgi-bin/toc.cgi?../065/065.txt"); courses[66] = new Course("Configure the SGA", "cgi-bin/toc.cgi?../066/066.txt"); courses[67] = new Course("Use Oracle Managed Files", "cgi-bin/toc.cgi?../067/067.txt"); courses[68] = new Course("Configure Recovery Manager", "cgi-bin/toc.cgi?../068/068.txt"); courses[69] = new Course("Introduction to Indexes and Data Clusters", "cgi-bin/toc.cgi?../069/069.txt"); courses[70] = new Course("Create Normal Indexes", "cgi-bin/toc.cgi?../070/070.txt"); courses[71] = new Course("Introduction to the SGA", "cgi-bin/toc.cgi?../071/071.txt"); courses[72] = new Course("open", "cgi-bin/toc.cgi?../072/072.txt"); courses[73] = new Course("Introduction to the Oracle Database 10g Sample Schemas", "cgi-bin/toc.cgi?../073/073.txt"); // upgrade courses[74] = new Course("Basic Query Enhancements", "cgi-bin/toc.cgi?../074/074.txt"); // upgrade courses[75] = new Course("Grouping Sets, Composite Columns, and Concatenated Groupings", "cgi-bin/toc.cgi?../075/075.txt"); // upgrade courses[76] = new Course("SQL:99 Join Syntax", "cgi-bin/toc.cgi?../076/076.txt"); // upgrade courses[77] = new Course("SQL DML Enhancements", "cgi-bin/toc.cgi?../077/077.txt"); // upgrade courses[78] = new Course("Devise a Security Policy", "cgi-bin/toc.cgi?../078/078.txt"); courses[79] = new Course("Create Database Users", "cgi-bin/toc.cgi?../079/079.txt"); courses[80] = new Course("Manage Database Users", "cgi-bin/toc.cgi?../080/080.txt"); courses[81] = new Course("Grant and Revoke System Privileges", "cgi-bin/toc.cgi?../081/081.txt"); courses[82] = new Course("Grant and Revoke Object Privileges", "cgi-bin/toc.cgi?../082/082.txt"); courses[83] = new Course("Enforce an Application Security Policy with Fine-Grained Access Controls", "cgi-bin/toc.cgi?../083/083.txt"); //upgrade courses[84] = new Course("Create, Use, and Manage Roles", "cgi-bin/toc.cgi?../084/084.txt"); courses[85] = new Course("Introduction to Data Blocks", "cgi-bin/toc.cgi?../085/085.txt"); courses[86] = new Course("Configure External User and Role Authentication", "cgi-bin/toc.cgi?../086/086.txt"); courses[87] = new Course("Audit Database Access", "cgi-bin/toc.cgi?../087/087.txt"); courses[88] = new Course("Create, Use, and Manage User Profiles", "cgi-bin/toc.cgi?../088/088.txt"); courses[89] = new Course("Manage Row Chaining and Row Migration", "cgi-bin/toc.cgi?../089/089.txt"); courses[90] = new Course("Introduction to PL/SQL", "cgi-bin/toc.cgi?../090/090.txt"); courses[91] = new Course("Integrity Constraint Enhancements", "cgi-bin/toc.cgi?../091/091.txt"); // upgrade courses[92] = new Course("Introduction to the Oracle Enterprise Manager Framework", "cgi-bin/toc.cgi?../092/092.txt"); courses[93] = new Course("Manage PL/SQL with Database Control", "cgi-bin/toc.cgi?../093/093.txt"); courses[94] = new Course("Configure Administrator Accounts with Database Control", "cgi-bin/toc.cgi?../094/094.txt"); courses[95] = new Course("Configure iSQL*Plus for Privileged DBA Connections", "cgi-bin/toc.cgi?../095/095.txt"); // upgrade courses[96] = new Course("Use SPFILEs", "cgi-bin/toc.cgi?../096/096.txt"); // upgrade courses[97] = new Course("Use Oracle Managed Files", "cgi-bin/toc.cgi?../097/097.txt"); // upgrade 67 courses[98] = new Course("Create a Database with the Database Configuration Assistant", "cgi-bin/toc.cgi?../098/098.txt"); courses[99] = new Course("Install Oracle Database 10g Release 1 Enterprise Edition on Microsoft Windows", "cgi-bin/toc.cgi?../099/099.txt"); courses[100] = new Course("Fundamentals of Oracle Database Structure", "cgi-bin/toc.cgi?../100/100.txt"); courses[101] = new Course("Manage Tablespaces", "cgi-bin/toc.cgi?../101/101.txt"); courses[102] = new Course("Manage Data Files", "cgi-bin/toc.cgi?../102/102.txt"); courses[103] = new Course("Manage Segments and Extents", "cgi-bin/toc.cgi?../103/103.txt"); courses[104] = new Course("Manage Segment Space", "cgi-bin/toc.cgi?../104/104.txt"); courses[105] = new Course("Manage Segments and Extents in Dictionary-Managed Tablespaces", "cgi-bin/toc.cgi?../105/105.txt"); courses[106] = new Course("Create, Use, and Manage Undo Tablespaces", "cgi-bin/toc.cgi?../106/106.txt"); courses[107] = new Course("Create, Use, and Manage Temporary Tablespaces", "cgi-bin/toc.cgi?../107/107.txt"); courses[108] = new Course("Create and Manage Rollback Segments", "cgi-bin/toc.cgi?../108/108.txt"); courses[109] = new Course("Introduction to Data Partitioning", "cgi-bin/toc.cgi?../109/109.txt"); courses[110] = new Course("Create Range-Partitioned Tables", "cgi-bin/toc.cgi?../110/110.txt"); courses[111] = new Course("Create Hash-Partitioned Tables", "cgi-bin/toc.cgi?../111/111.txt"); courses[112] = new Course("Create Composite-Partitioned Tables", "cgi-bin/toc.cgi?../112/112.txt"); courses[113] = new Course("Create Partitioned Indexes", "cgi-bin/toc.cgi?../113/113.txt"); courses[114] = new Course("Manage Partitioned Tables and Indexes", "cgi-bin/toc.cgi?../114/114.txt"); courses[115] = new Course("Understand Oracle ROWIDs", "cgi-bin/toc.cgi?../115/115.txt"); courses[116] = new Course("Create and Use Read-Only Tablespaces", "cgi-bin/toc.cgi?../116/116.txt"); courses[117] = new Course("Transport Tablespaces", "cgi-bin/toc.cgi?../117/117.txt"); courses[118] = new Course("Manage Database Instances and Sessions", "cgi-bin/toc.cgi?../118/118.txt"); courses[119] = new Course("Configure and Use Globalization Support", "cgi-bin/toc.cgi?../119/119.txt"); courses[120] = new Course("Overview of Application Tuning", "cgi-bin/toc.cgi?../120/120.txt"); courses[121] = new Course("Introduction to SQL Statement Processing", "cgi-bin/toc.cgi?../121/121.txt"); courses[122] = new Course("Introduction to Oracle's Optimizer", "cgi-bin/toc.cgi?../122/122.txt"); courses[123] = new Course("Manage Optimizer Statistics", "cgi-bin/toc.cgi?../123/123.txt"); courses[124] = new Course("Reveal SQL Statement Execution Plans", "cgi-bin/toc.cgi?../124/124.txt"); courses[125] = new Course("Create, Use, and Manage Normal Indexes", "cgi-bin/toc.cgi?../125/125.txt"); courses[126] = new Course("Create, Use, and Manage Bitmap Indexes", "cgi-bin/toc.cgi?../126/126.txt"); courses[127] = new Course("Create and Use Function-Based Indexes", "cgi-bin/toc.cgi?../127/127.txt"); courses[128] = new Course("Create, Use, and Manage Index-Organized Tables", "cgi-bin/toc.cgi?../128/128.txt"); courses[129] = new Course("Create, Use, and Manage Data Clusters", "cgi-bin/toc.cgi?../129/129.txt"); courses[130] = new Course("Create, Use, and Manage Hash Data Clusters", "cgi-bin/toc.cgi?../130/130.txt"); courses[131] = new Course("Dynamic SQL", "cgi-bin/toc.cgi?../131/131.txt"); courses[132] = new Course("Manage LOBs", "cgi-bin/toc.cgi?../132/132.txt"); courses[133] = new Course("open", "cgi-bin/toc.cgi?../133/133.txt"); // open courses[134] = new Course("open", "cgi-bin/toc.cgi?../134/134.txt"); // open courses[135] = new Course("open", "cgi-bin/toc.cgi?../135/135.txt"); // open courses[136] = new Course("open", "cgi-bin/toc.cgi?../136/136.txt"); // open courses[137] = new Course("open", "cgi-bin/toc.cgi?../137/137.txt"); // open courses[138] = new Course("open", "cgi-bin/toc.cgi?../138/138.txt"); // open courses[139] = new Course("open", "cgi-bin/toc.cgi?../139/139.txt"); // open courses[140] = new Course("Manage a Database's Control File", "cgi-bin/toc.cgi?../140/140.txt"); courses[141] = new Course("Configure a Database's Online Log", "cgi-bin/toc.cgi?../141/141.txt"); courses[142] = new Course("Configure Database Checkpoints", "cgi-bin/toc.cgi?../142/142.txt"); courses[143] = new Course("Configure a Database's Offline Log", "cgi-bin/toc.cgi?../143/143.txt"); courses[144] = new Course("Create Database and DDL Event Triggers", "cgi-bin/toc.cgi?../144/144.txt"); courses[145] = new Course("Use Export and Import", "cgi-bin/toc.cgi?../145/145.txt"); courses[146] = new Course("Use LogMiner", "cgi-bin/toc.cgi?../146/146.txt"); courses[147] = new Course("Configure and Use Parallel Execution", "cgi-bin/toc.cgi?../147/147.txt"); courses[148] = new Course("open", "cgi-bin/toc.cgi?../148/148.txt"); courses[149] = new Course("open", "cgi-bin/toc.cgi?../149/149.txt"); courses[150] = new Course("Introduction to Recovery Manager", "cgi-bin/toc.cgi?../150/150.txt"); courses[151] = new Course("Get Started with Recovery Manager", "cgi-bin/toc.cgi?../151/151.txt"); courses[152] = new Course("Back Up a Database with Recovery Manager", "cgi-bin/toc.cgi?../152/152.txt"); courses[153] = new Course("Manage Backups with Recovery Manager", "cgi-bin/toc.cgi?../153/153.txt"); courses[154] = new Course("Recover a Database with Recovery Manager", "cgi-bin/toc.cgi?../154/154.txt"); courses[155] = new Course("Use a Recovery Catalog with Recovery Manager", "cgi-bin/toc.cgi?../155/155.txt"); courses[156] = new Course("Advanced Recovery Manager Features", "cgi-bin/toc.cgi?../156/156.txt"); courses[157] = new Course("Introduction to Database Backup and Recovery", "cgi-bin/toc.cgi?../157/157.txt"); courses[158] = new Course("Back Up a Database", "cgi-bin/toc.cgi?../158/158.txt"); courses[159] = new Course("Recover a Database", "cgi-bin/toc.cgi?../159/159.txt"); courses[160] = new Course("Detect and Repair Data Block Corruptions", "cgi-bin/toc.cgi?../160/160.txt"); courses[161] = new Course("Perform Incomplete Database Recovery", "cgi-bin/toc.cgi?../161/161.txt"); courses[162] = new Course("Perform Tablespace Point-In-Time Recovery", "cgi-bin/toc.cgi?../162/162.txt"); // needs upgrade courses[163] = new Course("Manually Configure, Manage, and Activate a Standby Database", "cgi-bin/toc.cgi?../163/163.txt"); courses[164] = new Course("Introduction to Performance Tuning", "cgi-bin/toc.cgi?../164/164.txt"); courses[165] = new Course("Control the Optimizer", "cgi-bin/toc.cgi?../165/165.txt"); courses[166] = new Course("Design SQL Statements for Performance", "cgi-bin/toc.cgi?../166/166.txt"); courses[167] = new Course("Monitor and Trace SQL Statements", "cgi-bin/toc.cgi?../167/167.txt"); courses[168] = new Course("Design Transactions", "cgi-bin/toc.cgi?../168/168.txt"); courses[169] = new Course("Control and Monitor Data Locks", "cgi-bin/toc.cgi?../169/169.txt"); courses[170] = new Course("Introduction to Server Performance Tuning", "cgi-bin/toc.cgi?../170/170.txt"); courses[171] = new Course("Introduction to the Database Buffer Cache", "cgi-bin/toc.cgi?../171/171.txt"); courses[172] = new Course("Fundamental Database Buffer Cache Tuning", "cgi-bin/toc.cgi?../172/172.txt"); courses[173] = new Course("Configure Multiple Buffer Pools", "cgi-bin/toc.cgi?../173/173.txt"); courses[174] = new Course("open", "cgi-bin/toc.cgi?../174/174.txt"); // open courses[175] = new Course("Introduction to the Shared Pool", "cgi-bin/toc.cgi?../175/175.txt"); courses[176] = new Course("Configure the Shared Pool", "cgi-bin/toc.cgi?../176/176.txt"); courses[177] = new Course("Tune Shared Pool Memory Allocation", "cgi-bin/toc.cgi?../177/177.txt"); courses[178] = new Course("Tune the Database Design", "cgi-bin/toc.cgi?../178/178.txt"); courses[179] = new Course("Miscellaneous SGA Tuning Topics", "cgi-bin/toc.cgi?../179/179.txt"); courses[180] = new Course("Tune Database I/O", "cgi-bin/toc.cgi?../180/180.txt"); courses[181] = new Course("Tune PGA Memory Allocation and Minimize Sort I/O", "cgi-bin/toc.cgi?../181/181.txt"); courses[182] = new Course("Use UTLBSTAT/UTLESTAT", "cgi-bin/toc.cgi?../182/182.txt"); courses[183] = new Course("Use OEM Events", "cgi-bin/toc.cgi?../183/183.txt"); courses[184] = new Course("Use Oracle Expert", "cgi-bin/toc.cgi?../184/184.txt"); courses[185] = new Course("Use Statspack", "cgi-bin/toc.cgi?../185/185.txt"); courses[186] = new Course("Create Materialized Views and Dimensions", "cgi-bin/toc.cgi?../186/186.txt"); courses[187] = new Course("Refresh Materialized Views", "cgi-bin/toc.cgi?../187/187.txt"); courses[188] = new Course("Configure and Tune Shared Server Settings", "cgi-bin/toc.cgi?../188/188.txt"); courses[189] = new Course("Use the Database Resource Manager", "cgi-bin/toc.cgi?../189/189.txt"); courses[190] = new Course("Introduction to TCP/IP Networks", "cgi-bin/toc.cgi?../190/190.txt"); courses[191] = new Course("Introduction to Oracle Net", "cgi-bin/toc.cgi?../191/191.txt"); courses[192] = new Course("Use Easy Connect Naming", "cgi-bin/toc.cgi?../192/192.txt"); courses[193] = new Course("Use Local Naming", "cgi-bin/toc.cgi?../193/193.txt"); courses[194] = new Course("Introduction to the Listener Process", "cgi-bin/toc.cgi?../194/194.txt"); courses[195] = new Course("Manually Configure a Listener", "cgi-bin/toc.cgi?../195/195.txt"); courses[196] = new Course("Use Multiple Listeners and Connection Load Balancing", "cgi-bin/toc.cgi?../196/196.txt"); courses[197] = new Course("Protect a Listener with a Password", "cgi-bin/toc.cgi?../197/197.txt"); courses[198] = new Course("Use the Default Listener and Dynamic Service Registration", "cgi-bin/toc.cgi?../198/198.txt"); courses[199] = new Course("Use Oracle Names", "cgi-bin/toc.cgi?../199/199.txt"); // not to be upgraded courses[200] = new Course("Use Connection Manager", "cgi-bin/toc.cgi?../200/200.txt"); // needs upgrade courses[201] = new Course("Use Oracle Advanced Security", "cgi-bin/toc.cgi?../201/201.txt"); // needs upgrade courses[202] = new Course("Monitor and Troubleshoot Network Connections", "cgi-bin/toc.cgi?../202/202.txt"); // upgrade courses courses[203] = new Course("Automatic Segment Space Management", "cgi-bin/toc.cgi?../203/203.txt"); // 65 courses[204] = new Course("Miscellaneous Topics – Tuning", "cgi-bin/toc.cgi?../204/204.txt"); // new courses[205] = new Course("Use Oracle Flashback", "cgi-bin/toc.cgi?../205/205.txt"); // new courses[206] = new Course("Use Resumable Space Allocation", "cgi-bin/toc.cgi?../206/206.txt"); // new courses[207] = new Course("Troubleshoot Media Recovery Problems", "cgi-bin/toc.cgi?../207/207.txt"); courses[208] = new Course("Use Oracle Data Guard Manager", "cgi-bin/toc.cgi?../208/208.txt"); //new courses[209] = new Course("Miscellaneous Topics – Availability", "cgi-bin/toc.cgi?../209/209.txt"); //new courses[210] = new Course("Create and Manage List-Partitioned Tables", "cgi-bin/toc.cgi?../210/210.txt"); //new courses[211] = new Course("Miscellaneous Topics – Storage", "cgi-bin/toc.cgi?../211/211.txt"); //new courses[212] = new Course("Create a Tablespace with a Non-Standard Block Size", "cgi-bin/toc.cgi?../212/212.txt"); //new courses[213] = new Course("Oracle Enterprise Manager Enhancements", "cgi-bin/toc.cgi?../213/213.txt"); //new courses[214] = new Course("Oracle Networking Enhancements", "cgi-bin/toc.cgi?../214/214.txt"); //new courses[215] = new Course("Miscellaneous Topics – Security", "cgi-bin/toc.cgi?../215/215.txt"); // new courses[216] = new Course("Use Oracle Real Application Clusters", "cgi-bin/toc.cgi?../216/216.txt"); // new courses[217] = new Course("Manage Table Versions With Workspaces", "cgi-bin/toc.cgi?../217/217.txt"); // new courses[218] = new Course("Introduction to Distributed Databases", "cgi-bin/toc.cgi?../218/218.txt"); // new courses[219] = new Course("Configure a Distributed Database", "cgi-bin/toc.cgi?../219/219.txt"); // new /******************************************************************************/ function mFrame(title, url) { this.title = title; this.url = url; } mFrames = new Array(); mFrames[0] = new mFrame("Not Available","cgi-bin/mainframe.cgi?0"); mFrames[1] = new mFrame("Get Started ...","cgi-bin/mainframe.cgi?1"); mFrames[2] = new mFrame("... on Microsoft Windows NT/2000/XP","cgi-bin/mainframe.cgi?2"); mFrames[3] = new mFrame("... on Unix or Linux","cgi-bin/mainframe.cgi?3"); mFrames[4] = new mFrame("Oracle Fundamentals","cgi-bin/mainframe.cgi?4"); mFrames[5] = new mFrame("Basic Application Development","cgi-bin/mainframe.cgi?5"); mFrames[6] = new mFrame("Use SQL and SQL*Plus","cgi-bin/mainframe.cgi?6"); mFrames[7] = new mFrame("Manage Data","cgi-bin/mainframe.cgi?7"); mFrames[8] = new mFrame("Use PL/SQL","cgi-bin/mainframe.cgi?8"); mFrames[9] = new mFrame("Design Schema Objects","cgi-bin/mainframe.cgi?9"); mFrames[10] = new mFrame("Tables and Constraints","cgi-bin/mainframe.cgi?10"); mFrames[11] = new mFrame("Views","cgi-bin/mainframe.cgi?11"); mFrames[12] = new mFrame("Basic Database Administration","cgi-bin/mainframe.cgi?12"); mFrames[13] = new mFrame("Manage a Database: Fundamentals","cgi-bin/mainframe.cgi?13"); mFrames[14] = new mFrame("SQL and PL/SQL","cgi-bin/mainframe.cgi?14"); // updates mFrames[15] = new mFrame("Database Storage","cgi-bin/mainframe.cgi?15"); // updates mFrames[16] = new mFrame("Manage Database Security","cgi-bin/mainframe.cgi?16"); mFrames[17] = new mFrame("Advanced Application Development","cgi-bin/mainframe.cgi?17"); mFrames[18] = new mFrame("Advanced Database Administration","cgi-bin/mainframe.cgi?18"); mFrames[19] = new mFrame("Get Certified / Learn Oracle","cgi-bin/mainframe.cgi?19"); mFrames[20] = new mFrame("Oracle Database 10g Administrator Certified Associate (OCA)","cgi-bin/mainframe.cgi?20"); mFrames[21] = new mFrame("Oracle Database 10g Administrator Certified Professional (OCP)","cgi-bin/mainframe.cgi?21"); mFrames[22] = new mFrame("Create a Database","cgi-bin/mainframe.cgi?22"); mFrames[23] = new mFrame("Additional Database Configuration Topics","cgi-bin/mainframe.cgi?23"); mFrames[24] = new mFrame("Manage Schemas","cgi-bin/mainframe.cgi?24"); mFrames[25] = new mFrame("Oracle Certified Application Developer – Release 2","cgi-bin/mainframe.cgi?25"); mFrames[26] = new mFrame("Exam 1Z0-042 – Oracle Database 10g: Administration I","cgi-bin/mainframe.cgi?26"); // Exam 1 Oracle 10g DBA mFrames[27] = new mFrame("open","cgi-bin/mainframe.cgi?27"); // open mFrames[28] = new mFrame("Data Partitioning","cgi-bin/mainframe.cgi?28"); mFrames[29] = new mFrame("Database Backup and Recovery","cgi-bin/mainframe.cgi?29"); mFrames[30] = new mFrame("Oracle9i to Oracle 10g DBA Upgrade Exam (1Z0-040) – Oracle Database 10g: New Features for Administrators","cgi-bin/mainframe.cgi?30"); mFrames[31] = new mFrame("Exam 1Z0-043 – Oracle Database 10g: Administration II","cgi-bin/mainframe.cgi?31"); // Exam 2 Oracle 10g DBA mFrames[32] = new mFrame("Exam 3 (1Z0-032) – Oracle Database 10g: Administration II","cgi-bin/mainframe.cgi?32"); mFrames[33] = new mFrame("Exam 4 (1Z0-033) – Oracle10g: Performance Tuning","cgi-bin/mainframe.cgi?33"); mFrames[34] = new mFrame("Database Configuration","cgi-bin/mainframe.cgi?34"); mFrames[35] = new mFrame("Exam 2 (1Z0-147) – Oracle10g: Program with PL/SQL","cgi-bin/mainframe.cgi?35"); mFrames[36] = new mFrame("Indexes and Clusters","cgi-bin/mainframe.cgi?36"); mFrames[37] = new mFrame("Tuning","cgi-bin/mainframe.cgi?37"); mFrames[38] = new mFrame("Miscellaneous Enhancements","cgi-bin/mainframe.cgi?38"); mFrames[39] = new mFrame("Backup and Recovery","cgi-bin/mainframe.cgi?39"); mFrames[40] = new mFrame("Standby Databases and Oracle Data Guard","cgi-bin/mainframe.cgi?40"); mFrames[41] = new mFrame("Database Availability","cgi-bin/mainframe.cgi?41"); mFrames[42] = new mFrame("Database Security","cgi-bin/mainframe.cgi?42"); mFrames[43] = new mFrame("Distributed Databases and Data Replication","cgi-bin/mainframe.cgi?43"); mFrames[44] = new mFrame("Oracle Database 10g DBA Upgrade Exams","cgi-bin/mainframe.cgi?44"); mFrames[45] = new mFrame("Oracle10g PL/SQL Developer Certified Associate","cgi-bin/mainframe.cgi?45"); mFrames[46] = new mFrame("Migration Information","cgi-bin/mainframe.cgi?46"); mFrames[47] = new mFrame("Migration Information","cgi-bin/mainframe.cgi?47"); mFrames[48] = new mFrame("Oracle Enterprise Manager","cgi-bin/mainframe.cgi?48"); mFrames[49] = new mFrame("Manage Database Storage","cgi-bin/mainframe.cgi?49"); mFrames[50] = new mFrame("Migration Information","cgi-bin/mainframe.cgi?50"); mFrames[51] = new mFrame("In Development","cgi-bin/mainframe.cgi?51"); mFrames[52] = new mFrame("Tune Schema Access","cgi-bin/mainframe.cgi?52"); mFrames[53] = new mFrame("DBA Utilities","cgi-bin/mainframe.cgi?53"); mFrames[54] = new mFrame("Redo Log and Control File Configuration","cgi-bin/mainframe.cgi?54"); mFrames[55] = new mFrame("Migration Information","cgi-bin/mainframe.cgi?55"); mFrames[56] = new mFrame("Not Available on this CD","cgi-bin/mainframe.cgi?56"); mFrames[57] = new mFrame("Transaction Log and Control File Configuration","cgi-bin/mainframe.cgi?57"); mFrames[58] = new mFrame("User-Managed Database Backup and Recovery","cgi-bin/mainframe.cgi?58"); mFrames[59] = new mFrame("Recovery Manager","cgi-bin/mainframe.cgi?59"); mFrames[60] = new mFrame("Miscellaneous Topics","cgi-bin/mainframe.cgi?60"); mFrames[61] = new mFrame("Recovery Manager Enhancements","cgi-bin/mainframe.cgi?61"); mFrames[62] = new mFrame("Application Tuning","cgi-bin/mainframe.cgi?62"); mFrames[63] = new mFrame("Server Tuning","cgi-bin/mainframe.cgi?63"); mFrames[64] = new mFrame("Optimize SQL Statements","cgi-bin/mainframe.cgi?64"); mFrames[65] = new mFrame("Minimize Disk I/O","cgi-bin/mainframe.cgi?65"); mFrames[66] = new mFrame("OCP Survey ","cgi-bin/mainframe.cgi?66"); mFrames[67] = new mFrame("OCP Survey Thanks","cgi-bin/mainframe.cgi?67"); mFrames[68] = new mFrame("Tune Server Memory","cgi-bin/mainframe.cgi?68"); mFrames[69] = new mFrame("open","cgi-bin/mainframe.cgi?69"); mFrames[70] = new mFrame("Tune Server I/O","cgi-bin/mainframe.cgi?70"); mFrames[71] = new mFrame("Use Server Tuning Utilities","cgi-bin/mainframe.cgi?71"); mFrames[72] = new mFrame("Basic Oracle Net Configuration","cgi-bin/mainframe.cgi?72"); mFrames[73] = new mFrame("Advanced Oracle Net Configuration","cgi-bin/mainframe.cgi?73"); mFrames[74] = new mFrame("Listener Configuration","cgi-bin/mainframe.cgi?74"); mFrames[75] = new mFrame("Configure Oracle Net","cgi-bin/mainframe.cgi?75"); /******************************************************************************/ function examInfo(title, url) { this.title = title; this.url = url; } examInfos = new Array(); examInfos[0] = new mFrame("Not Available","cgi-bin/examinfo.cgi?0"); examInfos[1] = new mFrame("Introduction to Oracle Database 10g: SQL
Exam 1Z0-007","cgi-bin/examinfo.cgi?1"); examInfos[2] = new mFrame("Develop PL/SQL Program Units","cgi-bin/examinfo.cgi?2"); examInfos[3] = new mFrame("Oracle Database 10g: Administration I
Exam 1Z0-037","cgi-bin/examinfo.cgi?3"); examInfos[4] = new mFrame("Oracle Database 10g: New Features for Administrators","cgi-bin/examinfo.cgi?4"); examInfos[5] = new mFrame("Oracle10g Database: Administration II
Exam 1Z0-032","cgi-bin/examinfo.cgi?5"); examInfos[6] = new mFrame("Oracle8: Backup and Recovery Workshop","cgi-bin/examinfo.cgi?6"); examInfos[7] = new mFrame("Oracle Database 10g: Performance Tuning","cgi-bin/examinfo.cgi?7"); examInfos[8] = new mFrame("V$ View Reference Sheet","cgi-bin/examinfo.cgi?8"); examInfos[9] = new mFrame("Oracle8i: Network Administration","cgi-bin/examinfo.cgi?9"); examInfos[10] = new mFrame("Oracle8: Network Administration","cgi-bin/examinfo.cgi?10"); /******************************************************************************/ // Top level menu treeMenu.addItem(new TreeMenuItem("How to Use This Courseware", "howto.htm", "mainFrame")); // Get Started treeMenu.addItem(new TreeMenuItem(mFrames[1].title, mFrames[1].url, "mainFrame")); // Get Certified treeMenu.addItem(new TreeMenuItem(mFrames[19].title, mFrames[19].url, "mainFrame", "menu_folder_closed.gif")); // variable links treeMenu.addItem(new TreeMenuItem("Search", mFrames[0].url, "mainFrame")); // search trial treeMenu.addItem(new TreeMenuItem("My Test Scores", mFrames[0].url, "mainFrame")); // tests trial treeMenu.addItem(new TreeMenuItem("Release Notes (October-03-2005)", "release.htm", "mainFrame")); treeMenu.addItem(new TreeMenuItem("Oracle Database 10g Error Messages", "http:\/\/www.dbdomain.com\/cwredirect10g.php?120", "_blank")); treeMenu.addItem(new TreeMenuItem("Oracle Database 10g Parameters", "http:\/\/www.dbdomain.com\/cwredirect10g.php?121", "_blank")); treeMenu.addItem(new TreeMenuItem("Oracle Database 10g Data Dictionary Views", "http:\/\/www.dbdomain.com\/cwredirect10g.php?122", "_blank")); treeMenu.addItem(new TreeMenuItem("Oracle Database 10g Glossary", "http:\/\/www.dbdomain.com\/cwredirect10g.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/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 10g R2 gs_win.addItem(new TreeMenuItem(courses[99].title, courses[99].url, "mainFrame", "menu_link_ref.gif")); // Install 10g R1 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_win.addItem(new TreeMenuItem(courses[92].title, courses[92].url, "mainFrame", "menu_link_ref.gif")); // Intro to OEM gs.items[0].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 Oracle Database 10g 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_lin.addItem(new TreeMenuItem(courses[92].title, courses[92].url, "mainFrame", "menu_link_ref.gif")); // Intro to OEM gs.items[1].makeSubmenu(gs_lin); /******************************************************************************/ // Get Certified submenu var getcertified = new TreeMenu(); getcertified.addItem(new TreeMenuItem(mFrames[20].title, mFrames[20].url, "mainFrame")); // Oracle10g OCA getcertified.addItem(new TreeMenuItem(mFrames[21].title, mFrames[21].url, "mainFrame")); // Oracle10g OCP treeMenu.items[2].makeSubmenu(getcertified); /******************************************************************************/ // Get Certified - Associate submenus var oca = new TreeMenu(); oca.addItem(new TreeMenuItem(mFrames[26].title, mFrames[26].url, "mainFrame")); // Exam 1 getcertified.items[0].makeSubmenu(oca); // Get Certified - 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[31].title, mFrames[51].url, "mainFrame", "menu_folder_closed.gif")); // 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[7].title, mFrames[7].url, "mainFrame")); // Manage Data exam1.addItem(new TreeMenuItem(mFrames[24].title, mFrames[24].url, "mainFrame")); // Manage Schemas exam1.addItem(new TreeMenuItem(mFrames[13].title, mFrames[13].url, "mainFrame")); // Manage a Database: Fundamentals exam1.addItem(new TreeMenuItem(mFrames[22].title, mFrames[22].url, "mainFrame")); // Create a Database exam1.addItem(new TreeMenuItem(mFrames[16].title, mFrames[16].url, "mainFrame")); // Security exam1.addItem(new TreeMenuItem(mFrames[75].title, mFrames[75].url, "mainFrame")); // Networking exam1.addItem(new TreeMenuItem(mFrames[49].title, mFrames[49].url, "mainFrame")); // Storage 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[36].title, courses[36].url, "mainFrame", "menu_link_ref.gif")); // Install 10g R1 fundamentals.addItem(new TreeMenuItem(courses[38].title, courses[38].url, "mainFrame", "menu_link_ref.gif")); // First Time fundamentals.addItem(new TreeMenuItem("Install Oracle Database 10g on Unix or Linux", "linux.htm", "mainFrame")); // Install Links fundamentals.addItem(new TreeMenuItem(courses[41].title, courses[41].url, "mainFrame", "menu_link_ref.gif")); // First Time 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 fundamentals.addItem(new TreeMenuItem(courses[92].title, courses[92].url, "mainFrame", "menu_link_ref.gif")); // Intro to OEM exam1.items[0].makeSubmenu(fundamentals); // Exam 1 - Manage Data submenu var managedata = new TreeMenu(); managedata.addItem(new TreeMenuItem(mFrames[6].title, mFrames[6].url, "mainFrame")); // SQL managedata.addItem(new TreeMenuItem(mFrames[8].title, mFrames[8].url, "mainFrame")); // PL/SQL exam1.items[1].makeSubmenu(managedata); // Exam 1 - Manage Data - 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:\/\/www.dbdomain.com\/cwredirect10g.php?101", "_blank")); // Conditions sql.addItem(new TreeMenuItem("Datatypes", "http:\/\/www.dbdomain.com\/cwredirect10g.php?102", "_blank")); // Datatypes sql.addItem(new TreeMenuItem("Expressions", "http:\/\/www.dbdomain.com\/cwredirect10g.php?103", "_blank")); // Expressions sql.addItem(new TreeMenuItem("Format Models", "http:\/\/www.dbdomain.com\/cwredirect10g.php?104", "_blank")); // Format Models sql.addItem(new TreeMenuItem("Functions", "http:\/\/www.dbdomain.com\/cwredirect10g.php?105", "_blank")); // Functions sql.addItem(new TreeMenuItem("Literals", "http:\/\/www.dbdomain.com\/cwredirect10g.php?106", "_blank")); // Literals sql.addItem(new TreeMenuItem("Namespaces and Naming", "http:\/\/www.dbdomain.com\/cwredirect10g.php?125", "_blank")); // Namespace, Naming sql.addItem(new TreeMenuItem("Operators", "http:\/\/www.dbdomain.com\/cwredirect10g.php?107", "_blank")); // Operators sql.addItem(new TreeMenuItem("Pseusocolumns", "http:\/\/www.dbdomain.com\/cwredirect10g.php?108", "_blank")); // Pseudocolumns sql.addItem(new TreeMenuItem("Reserved Words", "http:\/\/www.dbdomain.com\/cwredirect10g.php?109", "_blank")); // Reserved Words sql.addItem(new TreeMenuItem("Database Limits", "http:\/\/www.dbdomain.com\/cwredirect10g.php?110", "_blank")); // Database Limits managedata.items[0].makeSubmenu(sql); // Exam 1 - Manage Data - 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[131].title, courses[131].url, "mainFrame", "menu_link_ref.gif")); plsql.addItem(new TreeMenuItem(courses[132].title, courses[132].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(courses[93].title, courses[93].url, "mainFrame", "menu_link_ref.gif")); plsql.addItem(new TreeMenuItem("PL/SQL Datatypes", "http:\/\/www.dbdomain.com\/cwredirect10g.php?111", "_blank")); plsql.addItem(new TreeMenuItem("PL/SQL Expressions", "http:\/\/www.dbdomain.com\/cwredirect10g.php?112", "_blank")); plsql.addItem(new TreeMenuItem("PL/SQL Functions", "http:\/\/www.dbdomain.com\/cwredirect10g.php?113", "_blank")); plsql.addItem(new TreeMenuItem("PL/SQL Literals", "http:\/\/www.dbdomain.com\/cwredirect10g.php?114", "_blank")); plsql.addItem(new TreeMenuItem("PL/SQL Operators", "http:\/\/www.dbdomain.com\/cwredirect10g.php?115", "_blank")); managedata.items[1].makeSubmenu(plsql); // Exam 1 - Manage Schemas submenu var manageschemas = new TreeMenu(); manageschemas.addItem(new TreeMenuItem(mFrames[9].title, mFrames[9].url, "mainFrame")); // Schema Design manageschemas.addItem(new TreeMenuItem(mFrames[52].title, mFrames[52].url, "mainFrame")); // Schema Tuning exam1.items[2].makeSubmenu(manageschemas); // Exam 1 - Basic Application Administration -- Application Schemas submenu var app_schemas = new TreeMenu(); app_schemas.addItem(new TreeMenuItem(courses[42].title, courses[42].url, "mainFrame", "menu_link_ref.gif")); app_schemas.addItem(new TreeMenuItem(courses[54].title, courses[54].url, "mainFrame", "menu_link_ref.gif")); app_schemas.addItem(new TreeMenuItem(courses[44].title, courses[44].url, "mainFrame", "menu_link_ref.gif")); app_schemas.addItem(new TreeMenuItem(courses[45].title, courses[45].url, "mainFrame", "menu_link_ref.gif")); app_schemas.addItem(new TreeMenuItem(courses[55].title, courses[55].url, "mainFrame", "menu_link_ref.gif")); app_schemas.addItem(new TreeMenuItem(courses[56].title, courses[56].url, "mainFrame", "menu_link_ref.gif")); app_schemas.addItem(new TreeMenuItem(courses[47].title, courses[47].url, "mainFrame", "menu_link_ref.gif")); app_schemas.addItem(new TreeMenuItem(courses[48].title, courses[48].url, "mainFrame", "menu_link_ref.gif")); app_schemas.addItem(new TreeMenuItem(courses[49].title, courses[49].url, "mainFrame", "menu_link_ref.gif")); 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_schemas.addItem(new TreeMenuItem(courses[37].title, courses[37].url, "mainFrame", "menu_link_ref.gif")); manageschemas.items[0].makeSubmenu(app_schemas); // Exam 1 - 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")); manageschemas.items[1].makeSubmenu(app_tune); // Exam 1 - 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[118].title, courses[118].url, "mainFrame", "menu_link_ref.gif")); //dbafun.addItem(new TreeMenuItem(courses[94].title, courses[94].url, "mainFrame", "menu_link_ref.gif")); exam1.items[3].makeSubmenu(dbafun); // Exam 1 - 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 exam1.items[4].makeSubmenu(dbcreate); // Exam 1 - Database Security submenu 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")); sec.addItem(new TreeMenuItem(courses[86].title, courses[86].url, "mainFrame", "menu_link_ref.gif")); sec.addItem(new TreeMenuItem(courses[83].title, courses[83].url, "mainFrame", "menu_link_ref.gif")); sec.addItem(new TreeMenuItem(courses[88].title, courses[88].url, "mainFrame", "menu_link_ref.gif")); sec.addItem(new TreeMenuItem(courses[189].title, courses[189].url, "mainFrame", "menu_link_ref.gif")); sec.addItem(new TreeMenuItem(courses[87].title, courses[87].url, "mainFrame", "menu_link_ref.gif")); exam1.items[5].makeSubmenu(sec); // Exam 1 - Networking submenu 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(courses[192].title, courses[192].url, "mainFrame", "menu_link_ref.gif")); // Host Naming net.addItem(new TreeMenuItem(courses[193].title, courses[193].url, "mainFrame", "menu_link_ref.gif")); // Local Naming net.addItem(new TreeMenuItem(courses[188].title, courses[188].url, "mainFrame", "menu_link_ref.gif")); // MTS net.addItem(new TreeMenuItem(courses[194].title, courses[194].url, "mainFrame", "menu_link_ref.gif")); // Intro net.addItem(new TreeMenuItem(courses[198].title, courses[198].url, "mainFrame", "menu_link_ref.gif")); // Default net.addItem(new TreeMenuItem(courses[195].title, courses[195].url, "mainFrame", "menu_link_ref.gif")); // Manual net.addItem(new TreeMenuItem(courses[196].title, courses[196].url, "mainFrame", "menu_link_ref.gif")); // Two Listeners net.addItem(new TreeMenuItem(courses[197].title, courses[197].url, "mainFrame", "menu_link_ref.gif")); // Password net.addItem(new TreeMenuItem(courses[202].title, courses[202].url, "mainFrame", "menu_link_ref.gif")); // Troubleshoot exam1.items[6].makeSubmenu(net); //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 1 - 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[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[85].title, courses[85].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[89].title, courses[89].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[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")); exam1.items[7].makeSubmenu(dbastor); // Exam 1 - 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")); partition.addItem(new TreeMenuItem(courses[210].title, courses[210].url, "mainFrame", "menu_link_ref.gif")); //dbastor.items[14].makeSubmenu(partition); /******************************************************************************/ // Exam 2 DEV var exam2dev = new TreeMenu(); exam2dev.addItem(new TreeMenuItem("Exam Tips", examInfos[2].url, "mainFrame")); exam2dev.addItem(new TreeMenuItem(courses[19].title, courses[19].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[20].title, courses[20].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[21].title, courses[21].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[22].title, courses[22].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[23].title, courses[23].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[24].title, courses[24].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[25].title, courses[25].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[26].title, courses[26].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[27].title, courses[27].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[28].title, courses[28].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[29].title, courses[29].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[144].title, courses[144].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[30].title, courses[30].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[31].title, courses[31].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[131].title, courses[131].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[132].title, courses[132].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem(courses[32].title, courses[32].url, "mainFrame", "menu_link_ref.gif")); exam2dev.addItem(new TreeMenuItem("PL/SQL Datatypes", "http:\/\/www.dbdomain.com\/cwredirect10g.php?111", "_blank")); exam2dev.addItem(new TreeMenuItem("PL/SQL Expressions", "http:\/\/www.dbdomain.com\/cwredirect10g.php?112", "_blank")); exam2dev.addItem(new TreeMenuItem("PL/SQL Functions", "http:\/\/www.dbdomain.com\/cwredirect10g.php?113", "_blank")); exam2dev.addItem(new TreeMenuItem("PL/SQL Literals", "http:\/\/www.dbdomain.com\/cwredirect10g.php?114", "_blank")); exam2dev.addItem(new TreeMenuItem("PL/SQL Operators", "http:\/\/www.dbdomain.com\/cwredirect10g.php?115", "_blank")); ocadev.items[1].makeSubmenu(exam2dev); /******************************************************************************/ // Exam 2 DBA 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 - 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 - 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 - 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[206].title, courses[206].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")); exam2misc.addItem(new TreeMenuItem(courses[205].title, courses[205].url, "mainFrame", "menu_link_ref.gif")); exam2misc.addItem(new TreeMenuItem(courses[217].title, courses[217].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); // 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 userbackup.addItem(new TreeMenuItem(courses[207].title, courses[207].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); /******************************************************************************/ // Upgrade Exam var upgrade = new TreeMenu(); upgrade.addItem(new TreeMenuItem(mFrames[30].title, mFrames[30].url, "mainFrame")); // 8i -> 9i OCP getcertified.items[2].makeSubmenu(upgrade); var upexam = new TreeMenu(); upexam.addItem(new TreeMenuItem("Exam Tips", examInfos[4].url, "mainFrame")); upexam.addItem(new TreeMenuItem(mFrames[34].title, mFrames[34].url, "mainFrame")); // Configuration upexam.addItem(new TreeMenuItem(mFrames[14].title, mFrames[14].url, "mainFrame")); // SQL upexam.addItem(new TreeMenuItem(mFrames[42].title, mFrames[42].url, "mainFrame")); // Security upexam.addItem(new TreeMenuItem(mFrames[15].title, mFrames[15].url, "mainFrame")); // Storage upexam.addItem(new TreeMenuItem(mFrames[41].title, mFrames[41].url, "mainFrame")); // Availability upexam.addItem(new TreeMenuItem(mFrames[39].title, mFrames[39].url, "mainFrame")); // Backup and Recovery upexam.addItem(new TreeMenuItem(mFrames[37].title, mFrames[37].url, "mainFrame")); // Tuning upexam.addItem(new TreeMenuItem(mFrames[38].title, mFrames[38].url, "mainFrame")); // Miscellaneous upgrade.items[0].makeSubmenu(upexam); // Upgrade Exam - Configuration var upconfig = new TreeMenu(); upconfig.addItem(new TreeMenuItem(courses[95].title, courses[95].url, "mainFrame", "menu_link_ref.gif")); // isqlplus upconfig.addItem(new TreeMenuItem(courses[96].title, courses[96].url, "mainFrame", "menu_link_ref.gif")); // spfiles upconfig.addItem(new TreeMenuItem(courses[142].title, courses[142].url, "mainFrame", "menu_link_ref.gif")); // checkpoints //upconfig.addItem(new TreeMenuItem(courses[33].title, courses[33].url, "mainFrame", "menu_link_ref.gif")); // datetimes upexam.items[1].makeSubmenu(upconfig); // Upgrade Exam - SQL and PL/SQL var upsql = new TreeMenu(); upsql.addItem(new TreeMenuItem(courses[73].title, courses[73].url, "mainFrame", "menu_link_ref.gif")); // 9i Schemas upsql.addItem(new TreeMenuItem(courses[74].title, courses[74].url, "mainFrame", "menu_link_ref.gif")); // queries upsql.addItem(new TreeMenuItem(courses[33].title, courses[33].url, "mainFrame", "menu_link_ref.gif")); // datetimes upsql.addItem(new TreeMenuItem(courses[75].title, courses[75].url, "mainFrame", "menu_link_ref.gif")); // grouping upsql.addItem(new TreeMenuItem(courses[76].title, courses[76].url, "mainFrame", "menu_link_ref.gif")); // joins upsql.addItem(new TreeMenuItem(courses[77].title, courses[77].url, "mainFrame", "menu_link_ref.gif")); // DML upsql.addItem(new TreeMenuItem(courses[91].title, courses[91].url, "mainFrame", "menu_link_ref.gif")); // constraints upexam.items[2].makeSubmenu(upsql); // Upgrade Exam - Security var upsecurity = new TreeMenu(); upsecurity.addItem(new TreeMenuItem(courses[83].title, courses[83].url, "mainFrame", "menu_link_ref.gif")); // FGAC upsecurity.addItem(new TreeMenuItem(courses[215].title, courses[215].url, "mainFrame", "menu_link_ref.gif")); // Misc upexam.items[3].makeSubmenu(upsecurity); // Upgrade Exam - Storage var upstore = new TreeMenu(); upstore.addItem(new TreeMenuItem(courses[97].title, courses[97].url, "mainFrame", "menu_link_ref.gif")); // OMF upstore.addItem(new TreeMenuItem(courses[107].title, courses[107].url, "mainFrame", "menu_link_ref.gif")); // tempts upstore.addItem(new TreeMenuItem(courses[106].title, courses[106].url, "mainFrame", "menu_link_ref.gif")); // undots upstore.addItem(new TreeMenuItem(courses[212].title, courses[212].url, "mainFrame", "menu_link_ref.gif")); // multi block size upstore.addItem(new TreeMenuItem(courses[203].title, courses[203].url, "mainFrame", "menu_link_ref.gif")); // assm upstore.addItem(new TreeMenuItem(courses[16].title, courses[16].url, "mainFrame", "menu_link_ref.gif")); // external tables upstore.addItem(new TreeMenuItem(courses[210].title, courses[210].url, "mainFrame", "menu_link_ref.gif")); // list part tables upstore.addItem(new TreeMenuItem(courses[206].title, courses[206].url, "mainFrame", "menu_link_ref.gif")); // resumable space alloc upstore.addItem(new TreeMenuItem(courses[211].title, courses[211].url, "mainFrame", "menu_link_ref.gif")); // misc upexam.items[4].makeSubmenu(upstore); // Upgrade Exam - Availability var upavailable = new TreeMenu(); upavailable.addItem(new TreeMenuItem(courses[205].title, courses[205].url, "mainFrame", "menu_link_ref.gif")); // Flashback upavailable.addItem(new TreeMenuItem(courses[216].title, courses[216].url, "mainFrame", "menu_link_ref.gif")); // RAC upavailable.addItem(new TreeMenuItem(courses[209].title, courses[209].url, "mainFrame", "menu_link_ref.gif")); // Misc upavailable.addItem(new TreeMenuItem(mFrames[40].title, mFrames[40].url, "mainFrame")); // Data Guard upexam.items[5].makeSubmenu(upavailable); // Upgrade Exam - Availability - Data Guard var upguard = new TreeMenu(); upguard.addItem(new TreeMenuItem(courses[163].title, courses[163].url, "mainFrame", "menu_link_ref.gif")); // manual upguard.addItem(new TreeMenuItem(courses[208].title, courses[208].url, "mainFrame", "menu_link_ref.gif")); // DGMgr upavailable.items[3].makeSubmenu(upguard); // Upgrade Exam - Backup and Recovery var upbackup = new TreeMenu(); upbackup.addItem(new TreeMenuItem(courses[146].title, courses[146].url, "mainFrame", "menu_link_ref.gif")); upbackup.addItem(new TreeMenuItem(courses[207].title, courses[207].url, "mainFrame", "menu_link_ref.gif")); // Trouble upbackup.addItem(new TreeMenuItem(mFrames[61].title, mFrames[61].url, "mainFrame")); // RMAN upexam.items[6].makeSubmenu(upbackup); // Upgrade Exam - Backup and Recovery - RMAN upbackup.items[2].makeSubmenu(rman); // Upgrade Exam - Tuning var uptune = new TreeMenu(); uptune.addItem(new TreeMenuItem(courses[71].title, courses[71].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[175].title, courses[175].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[176].title, courses[176].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[177].title, courses[177].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[171].title, courses[171].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[172].title, courses[172].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[173].title, courses[173].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[179].title, courses[179].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[181].title, courses[181].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[189].title, courses[189].url, "mainFrame", "menu_link_ref.gif")); uptune.addItem(new TreeMenuItem(courses[204].title, courses[204].url, "mainFrame", "menu_link_ref.gif")); // misc updates upexam.items[7].makeSubmenu(uptune); // Upgrade Exam - Miscellaneous var upmisc = new TreeMenu(); upmisc.addItem(new TreeMenuItem(courses[213].title, courses[213].url, "mainFrame", "menu_link_ref.gif")); // OEM upmisc.addItem(new TreeMenuItem(courses[145].title, courses[145].url, "mainFrame", "menu_link_ref.gif")); // Imp/Exp upmisc.addItem(new TreeMenuItem(courses[214].title, courses[214].url, "mainFrame", "menu_link_ref.gif")); // Net upmisc.addItem(new TreeMenuItem(courses[217].title, courses[217].url, "mainFrame", "menu_link_ref.gif")); // Workspaces upmisc.addItem(new TreeMenuItem(courses[119].title, courses[119].url, "mainFrame", "menu_link_ref.gif")); // NLS //upmisc.addItem(new TreeMenuItem(mFrames[43].title, mFrames[43].url, "mainFrame")); // Dist Db upexam.items[8].makeSubmenu(upmisc); // Upgrade Exam - Miscellaneous - Distributed Databases and Replication //var upddb = new TreeMenu(); //upddb.addItem(new TreeMenuItem(courses[218].title, courses[218].url, "mainFrame", "menu_link_ref.gif")); // Intro //upddb.addItem(new TreeMenuItem(courses[219].title, courses[219].url, "mainFrame", "menu_link_ref.gif")); // Config //upmisc.items[3].makeSubmenu(upddb);