{"product_id":"oca-oracle-database-12c-administrator-certified-associate-study-guide-exams-1z0-061-and-1z0-062-paperback-softback-9781118643952","title":"OCA: Oracle Database 12c Administrator Certified Associate Study Guide; Exams 1Z0-061 and 1Z0-062 (Paperback \/ softback) 9781118643952","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eOCA: Oracle Database 12c Administrator Certified Associate Study Guide\u003c\/font\u003e\u003cbr\u003e\r\n\u003cfont size=\"5\"\u003eExams 1Z0-061 and 1Z0-062\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\u003cp\u003e\u003cfont size=\"4\"\u003eBiju Thomas (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781118643952, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 17 June 2014\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e1232 pages\u003cbr\u003e23.4 x 18.5 x 6.1 cm, 1.565 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003eAn all-in-one study guide prepares you for the updated Oracle Certified Associate certification\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIt's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eProvides you with a solid understanding of restricting and sorting data\u003c\/li\u003e \u003cli\u003eWalks you through using conversion functions and conditional expressions\u003c\/li\u003e \u003cli\u003eAddresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery\u003c\/li\u003e \u003cli\u003eExplores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance\u003c\/li\u003e \u003cli\u003eFocuses on administering and implementing user security\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eThis must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003eIntroduction  xx\u003c\/p\u003e \u003cp\u003eAssessment Test xxxv\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I Oracle Database 12c: SQL Fundamentals 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Introducing Oracle Database 12c RDBMS 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRelational Database Management Systems 4\u003c\/p\u003e \u003cp\u003eCharacteristics of a Relational Database 5\u003c\/p\u003e \u003cp\u003eOracle’s Implementation of RDBMS and ORDBMS 8\u003c\/p\u003e \u003cp\u003eThe Oracle Database 12c 9\u003c\/p\u003e \u003cp\u003eOracle Database 12c Implementations 9\u003c\/p\u003e \u003cp\u003eConnecting to Oracle Database 13\u003c\/p\u003e \u003cp\u003eDatabase Management Tools 14\u003c\/p\u003e \u003cp\u003eOracle Database 12c in the Cloud 19\u003c\/p\u003e \u003cp\u003eFamiliarizing SQL*Plus 19\u003c\/p\u003e \u003cp\u003eSummary 30\u003c\/p\u003e \u003cp\u003eExam Essentials 31\u003c\/p\u003e \u003cp\u003eReview Questions 32\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Introducing SQL 35\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSQL Fundamentals 36\u003c\/p\u003e \u003cp\u003eOracle Datatypes 38\u003c\/p\u003e \u003cp\u003eOperators and Literals 42\u003c\/p\u003e \u003cp\u003eWriting Simple Queries 46\u003c\/p\u003e \u003cp\u003eUsing the SELECT Statement 46\u003c\/p\u003e \u003cp\u003eFiltering Rows 51\u003c\/p\u003e \u003cp\u003eSorting Rows 62\u003c\/p\u003e \u003cp\u003eSorting NULLs 64\u003c\/p\u003e \u003cp\u003eLimiting Rows 67\u003c\/p\u003e \u003cp\u003eUsing Expressions 68\u003c\/p\u003e \u003cp\u003eAccepting Values at Runtime 72\u003c\/p\u003e \u003cp\u003eUsing Ampersand Substitution Variables 73\u003c\/p\u003e \u003cp\u003eSaving a Variable for a Session 75\u003c\/p\u003e \u003cp\u003eUsing Positional Notation for Variables 77\u003c\/p\u003e \u003cp\u003eSummary 78\u003c\/p\u003e \u003cp\u003eExam Essentials 78\u003c\/p\u003e \u003cp\u003eReview Questions 80\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Using Single-Row Functions 89\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSingle-Row Function Fundamentals 90\u003c\/p\u003e \u003cp\u003eFunctions for NULL Handling 91\u003c\/p\u003e \u003cp\u003eUsing Single-Row Character Functions 95\u003c\/p\u003e \u003cp\u003eCharacter Function Overview 95\u003c\/p\u003e \u003cp\u003eCharacter Function Descriptions 96\u003c\/p\u003e \u003cp\u003eUsing Single-Row Numeric Functions 108\u003c\/p\u003e \u003cp\u003eNumeric Function Overview 108\u003c\/p\u003e \u003cp\u003eNumeric Function Descriptions 109\u003c\/p\u003e \u003cp\u003eUsing Single-Row Date Functions 119\u003c\/p\u003e \u003cp\u003eDate Format Conversion 119\u003c\/p\u003e \u003cp\u003eDate Function Overview 120\u003c\/p\u003e \u003cp\u003eDate Function Descriptions 121\u003c\/p\u003e \u003cp\u003eUsing Single-Row Conversion Functions 131\u003c\/p\u003e \u003cp\u003eConversion Function Overview 131\u003c\/p\u003e \u003cp\u003eConversion Function Descriptions 133\u003c\/p\u003e \u003cp\u003eUsing Other Single-Row Functions 154\u003c\/p\u003e \u003cp\u003eMiscellaneous Function Overview 154\u003c\/p\u003e \u003cp\u003eMiscellaneous Function Descriptions 155\u003c\/p\u003e \u003cp\u003eSummary 167\u003c\/p\u003e \u003cp\u003eExam Essentials 168\u003c\/p\u003e \u003cp\u003eReview Questions 169\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Using Group Functions 175\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGroup Function Fundamentals 176\u003c\/p\u003e \u003cp\u003eUtilizing Aggregate Functions 177\u003c\/p\u003e \u003cp\u003eGrouping Data with GROUP BY 178\u003c\/p\u003e \u003cp\u003eGroup Function Overview 182\u003c\/p\u003e \u003cp\u003eGroup Function Descriptions: Part 1 184\u003c\/p\u003e \u003cp\u003eGroup Function Descriptions: Part 2 194\u003c\/p\u003e \u003cp\u003eLimiting Grouped Data with HAVING 207\u003c\/p\u003e \u003cp\u003eCreating Superaggregates with CUBE and ROLLUP 208\u003c\/p\u003e \u003cp\u003eNesting Functions 215\u003c\/p\u003e \u003cp\u003eSummary 218\u003c\/p\u003e \u003cp\u003eExam Essentials 218\u003c\/p\u003e \u003cp\u003eReview Questions 219\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Using Joins and Subqueries 227\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWriting Multiple-Table Queries 228\u003c\/p\u003e \u003cp\u003eInner Joins 229\u003c\/p\u003e \u003cp\u003eCartesian Joins 239\u003c\/p\u003e \u003cp\u003eOuter Joins 240\u003c\/p\u003e \u003cp\u003eOther Multiple-Table Queries 245\u003c\/p\u003e \u003cp\u003eUsing Set Operators 247\u003c\/p\u003e \u003cp\u003eThe UNION Operator 248\u003c\/p\u003e \u003cp\u003eThe UNION ALL Operator 249\u003c\/p\u003e \u003cp\u003eThe INTERSECT Operator 250\u003c\/p\u003e \u003cp\u003eThe MINUS Operator 250\u003c\/p\u003e \u003cp\u003ePutting It All Together 250\u003c\/p\u003e \u003cp\u003eUsing Subqueries 252\u003c\/p\u003e \u003cp\u003eSingle-Row Subqueries 253\u003c\/p\u003e \u003cp\u003eMultiple-Row Subqueries 254\u003c\/p\u003e \u003cp\u003eSubquery Returns No Rows 256\u003c\/p\u003e \u003cp\u003eCorrelated Subqueries 258\u003c\/p\u003e \u003cp\u003eScalar Subqueries 259\u003c\/p\u003e \u003cp\u003eMultiple-Column Subqueries 267\u003c\/p\u003e \u003cp\u003eSubqueries in Other DML Statements 268\u003c\/p\u003e \u003cp\u003eSummary 269\u003c\/p\u003e \u003cp\u003eExam Essentials 270\u003c\/p\u003e \u003cp\u003eReview Questions 271\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Manipulating Data 281\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing DML Statements 282\u003c\/p\u003e \u003cp\u003eInserting Rows into a Table 283\u003c\/p\u003e \u003cp\u003eUpdating Rows in a Table 289\u003c\/p\u003e \u003cp\u003eDeleting Rows from a Table 294\u003c\/p\u003e \u003cp\u003eMerging Rows 297\u003c\/p\u003e \u003cp\u003eUnderstanding Transaction Control 299\u003c\/p\u003e \u003cp\u003eSavepoints and Partial Rollbacks 302\u003c\/p\u003e \u003cp\u003eData Visibility 304\u003c\/p\u003e \u003cp\u003eSummary 306\u003c\/p\u003e \u003cp\u003eExam Essentials 307\u003c\/p\u003e \u003cp\u003eReview Questions 308\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Creating Tables and Constraints 319\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDatabase Objects Overview 320\u003c\/p\u003e \u003cp\u003eSchema Objects 322\u003c\/p\u003e \u003cp\u003eUsing Sequences 324\u003c\/p\u003e \u003cp\u003eBuilt-in Datatypes 325\u003c\/p\u003e \u003cp\u003eCharacter Datatypes 325\u003c\/p\u003e \u003cp\u003eNumeric Datatypes 329\u003c\/p\u003e \u003cp\u003eDate and Time Datatypes 330\u003c\/p\u003e \u003cp\u003eDate Arithmetic 334\u003c\/p\u003e \u003cp\u003eBinary Datatypes 336\u003c\/p\u003e \u003cp\u003eRow ID Datatypes 337\u003c\/p\u003e \u003cp\u003eCreating Tables 338\u003c\/p\u003e \u003cp\u003eNaming Tables and Columns 339\u003c\/p\u003e \u003cp\u003eSpecifying Default Values for Columns 341\u003c\/p\u003e \u003cp\u003eAdding Comments 348\u003c\/p\u003e \u003cp\u003eCreating a Table from Another Table 348\u003c\/p\u003e \u003cp\u003eModifying Tables 350\u003c\/p\u003e \u003cp\u003eAdding Columns 350\u003c\/p\u003e \u003cp\u003eModifying Columns 353\u003c\/p\u003e \u003cp\u003eRenaming Columns 354\u003c\/p\u003e \u003cp\u003eDropping Columns 354\u003c\/p\u003e \u003cp\u003eHiding Columns from Table 356\u003c\/p\u003e \u003cp\u003eDropping Tables 357\u003c\/p\u003e \u003cp\u003eRenaming Tables 357\u003c\/p\u003e \u003cp\u003eMaking Tables Read-Only 358\u003c\/p\u003e \u003cp\u003eManaging Constraints 361\u003c\/p\u003e \u003cp\u003eCreating Constraints 362\u003c\/p\u003e \u003cp\u003eDropping Constraints 367\u003c\/p\u003e \u003cp\u003eEnabling and Disabling Constraints 367\u003c\/p\u003e \u003cp\u003eDeferring Constraint Checks 369\u003c\/p\u003e \u003cp\u003eSummary 373\u003c\/p\u003e \u003cp\u003eExam Essentials 374\u003c\/p\u003e \u003cp\u003eReview Questions 375\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II Oracle Database 12c: Installation and Administration 381\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Introducing Oracle Database 12c Components and Architecture 383\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOracle Database Fundamentals 385\u003c\/p\u003e \u003cp\u003eRelational Databases 385\u003c\/p\u003e \u003cp\u003eOracle Database 12c Objects 386\u003c\/p\u003e \u003cp\u003eInteracting with Oracle Database 12c 388\u003c\/p\u003e \u003cp\u003eOracle Database 12c Architecture 391\u003c\/p\u003e \u003cp\u003eUser and Server Processes 394\u003c\/p\u003e \u003cp\u003eThe Oracle Instance 396\u003c\/p\u003e \u003cp\u003eOracle Storage Structures 410\u003c\/p\u003e \u003cp\u003eSummary 424\u003c\/p\u003e \u003cp\u003eExam Essentials 425\u003c\/p\u003e \u003cp\u003eReview Questions 426\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Creating and Operating Oracle Database 12c 431\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOracle Database 12c Software Installation 432\u003c\/p\u003e \u003cp\u003ePlanning the Oracle Database 12c Software Install 433\u003c\/p\u003e \u003cp\u003eUsing the Oracle Universal Installer 440\u003c\/p\u003e \u003cp\u003eUsing DBCA to Create an Oracle 12c Database 447\u003c\/p\u003e \u003cp\u003eInvoking the Database Configuration Assistant 447\u003c\/p\u003e \u003cp\u003eConfiguring an Oracle Database Using the DBCA 472\u003c\/p\u003e \u003cp\u003eDeleting an Oracle Database Using the DBCA 472\u003c\/p\u003e \u003cp\u003eManaging Database Templates Using the DBCA 473\u003c\/p\u003e \u003cp\u003eWorking with Oracle Database Metadata 475\u003c\/p\u003e \u003cp\u003eData Dictionary Views 476\u003c\/p\u003e \u003cp\u003eDynamic Performance Views 477\u003c\/p\u003e \u003cp\u003eManaging Initialization-Parameter Files 479\u003c\/p\u003e \u003cp\u003eLocating the Default Parameter File 484\u003c\/p\u003e \u003cp\u003eModifying Initialization-Parameter Values 485\u003c\/p\u003e \u003cp\u003eStarting Up and Shutting Down an Oracle Instance 490\u003c\/p\u003e \u003cp\u003eStarting Up an Oracle Database 12c Instance 491\u003c\/p\u003e \u003cp\u003eShutting Down an Oracle Database 12c Instance 495\u003c\/p\u003e \u003cp\u003eMonitoring the Database Alert Log 497\u003c\/p\u003e \u003cp\u003eSummary 503\u003c\/p\u003e \u003cp\u003eExam Essentials 504\u003c\/p\u003e \u003cp\u003eReview Questions 506\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Understanding Storage and Space Management 511\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Physical and Logical Storage 512\u003c\/p\u003e \u003cp\u003eContents of a Data Block 514\u003c\/p\u003e \u003cp\u003eManaging Tablespaces 516\u003c\/p\u003e \u003cp\u003eIdentifying Default Tablespaces 516\u003c\/p\u003e \u003cp\u003eCreating and Maintaining Tablespaces 516\u003c\/p\u003e \u003cp\u003eObtaining Tablespace Information 531\u003c\/p\u003e \u003cp\u003eManaging Data Files 534\u003c\/p\u003e \u003cp\u003ePerforming Operations on Data Files 535\u003c\/p\u003e \u003cp\u003eUsing the Oracle Managed Files Feature 539\u003c\/p\u003e \u003cp\u003eQuerying Data File Information 544\u003c\/p\u003e \u003cp\u003eManaging Space 547\u003c\/p\u003e \u003cp\u003eAutomatic Space Management Features 547\u003c\/p\u003e \u003cp\u003eMonitoring Tablespace Free Space 551\u003c\/p\u003e \u003cp\u003eUsing Segment Advisor 554\u003c\/p\u003e \u003cp\u003eAvoiding Out-of-Space Errors 559\u003c\/p\u003e \u003cp\u003eSummary 562\u003c\/p\u003e \u003cp\u003eExam Essentials 563\u003c\/p\u003e \u003cp\u003eReview Questions 565\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Managing Data Concurrency and Undo 569\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eManaging Data Changes Using DML 570\u003c\/p\u003e \u003cp\u003eUnderstanding “Change” 571\u003c\/p\u003e \u003cp\u003eDifferentiating Undo and Redo 572\u003c\/p\u003e \u003cp\u003eConfiguring and Monitoring Undo 576\u003c\/p\u003e \u003cp\u003eManaging Data Concurrency 584\u003c\/p\u003e \u003cp\u003eUnderstanding Locks and Transactions 585\u003c\/p\u003e \u003cp\u003eMaximizing Data Concurrency 587\u003c\/p\u003e \u003cp\u003eDetecting and Resolving Lock Conflicts 590\u003c\/p\u003e \u003cp\u003eSummary 595\u003c\/p\u003e \u003cp\u003eExam Essentials 595\u003c\/p\u003e \u003cp\u003eReview Questions 597\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Understanding Oracle Network Architecture 603\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing Network Configurations 604\u003c\/p\u003e \u003cp\u003eSingle-Tier Architecture 605\u003c\/p\u003e \u003cp\u003eTwo-Tier Architecture 605\u003c\/p\u003e \u003cp\u003en-Tier Architecture 606\u003c\/p\u003e \u003cp\u003eAn Overview of Oracle Net Features 607\u003c\/p\u003e \u003cp\u003eConnectivity 608\u003c\/p\u003e \u003cp\u003eManageability 608\u003c\/p\u003e \u003cp\u003eScalability 609\u003c\/p\u003e \u003cp\u003eSecurity 611\u003c\/p\u003e \u003cp\u003eAccessibility 613\u003c\/p\u003e \u003cp\u003eConfiguring Oracle Net on the Server 613\u003c\/p\u003e \u003cp\u003eUnderstanding the Oracle Listener 614\u003c\/p\u003e \u003cp\u003eManaging Oracle Listeners 618\u003c\/p\u003e \u003cp\u003eDynamically Registering Services 634\u003c\/p\u003e \u003cp\u003eOracle Net Logging and Tracing on the Server 635\u003c\/p\u003e \u003cp\u003eConfiguring Oracle Net for the Client 637\u003c\/p\u003e \u003cp\u003eClient-Side Names Resolution Options 637\u003c\/p\u003e \u003cp\u003eThe Host Naming Method 638\u003c\/p\u003e \u003cp\u003eThe Oracle Easy Connect Method 639\u003c\/p\u003e \u003cp\u003eThe Local Naming Method 641\u003c\/p\u003e \u003cp\u003eTroubleshooting Client-Side Connection Problems 646\u003c\/p\u003e \u003cp\u003eAn Overview of Oracle Shared Server 648\u003c\/p\u003e \u003cp\u003eDedicated Server vs. Shared Server 648\u003c\/p\u003e \u003cp\u003eAdvantages and Disadvantages of Shared Server 650\u003c\/p\u003e \u003cp\u003eOracle Shared Server Infrastructure 651\u003c\/p\u003e \u003cp\u003eConfiguring the Oracle Shared Server 653\u003c\/p\u003e \u003cp\u003eManaging a Shared Server 658\u003c\/p\u003e \u003cp\u003eUnderstanding Database Resident Connection Pooling 661\u003c\/p\u003e \u003cp\u003eConfiguring DRCP 662\u003c\/p\u003e \u003cp\u003eComparing Connection Architectures 663\u003c\/p\u003e \u003cp\u003eCommunicating Between Databases 666\u003c\/p\u003e \u003cp\u003eIntroduction to Database Links 666\u003c\/p\u003e \u003cp\u003eCreating Database Links 667\u003c\/p\u003e \u003cp\u003eSummary 669\u003c\/p\u003e \u003cp\u003eExam Essentials 670\u003c\/p\u003e \u003cp\u003eReview Questions 672\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Implementing Security and Auditing 677\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCreating and Managing User Accounts 678\u003c\/p\u003e \u003cp\u003eConfiguring Authentication 679\u003c\/p\u003e \u003cp\u003eAssigning Tablespaces and Quotas 681\u003c\/p\u003e \u003cp\u003eAssigning a Profile and Account Settings 684\u003c\/p\u003e \u003cp\u003eRemoving a User from the Database 686\u003c\/p\u003e \u003cp\u003eManaging Default User Accounts 687\u003c\/p\u003e \u003cp\u003eGranting and Revoking Privileges 687\u003c\/p\u003e \u003cp\u003eGranting Object Privileges 688\u003c\/p\u003e \u003cp\u003eGranting System Privileges 692\u003c\/p\u003e \u003cp\u003eRole Privileges 701\u003c\/p\u003e \u003cp\u003eApplying the Principle of Least Privilege 705\u003c\/p\u003e \u003cp\u003eControlling Resource Usage by Users 711\u003c\/p\u003e \u003cp\u003eImplementing Password Security Features 714\u003c\/p\u003e \u003cp\u003eAuditing Database Activity 718\u003c\/p\u003e \u003cp\u003eManaging Statement Auditing 720\u003c\/p\u003e \u003cp\u003eManaging Privilege Auditing 724\u003c\/p\u003e \u003cp\u003eManaging Object Auditing 725\u003c\/p\u003e \u003cp\u003eUsing SQL Developer for Audit Management 727\u003c\/p\u003e \u003cp\u003ePurging the Audit Trail 729\u003c\/p\u003e \u003cp\u003eManaging Fine-Grained Auditing 732\u003c\/p\u003e \u003cp\u003eImplementing Unified Auditing 735\u003c\/p\u003e \u003cp\u003eSummary 745\u003c\/p\u003e \u003cp\u003eExam Essentials 746\u003c\/p\u003e \u003cp\u003eReview Questions 747\u003c\/p\u003e \u003cp\u003eChapter 14 Maintaining the Database and Managing Performance 753\u003c\/p\u003e \u003cp\u003eProactive Database Maintenance 754\u003c\/p\u003e \u003cp\u003eManaging Optimizer Statistics 755\u003c\/p\u003e \u003cp\u003eGathering Performance Statistics 775\u003c\/p\u003e \u003cp\u003eAutomatic Database Diagnostic Monitoring 782\u003c\/p\u003e \u003cp\u003eThe Advisory Framework 793\u003c\/p\u003e \u003cp\u003eMonitoring Server-Generated Alerts 798\u003c\/p\u003e \u003cp\u003eUnderstanding Automatic Diagnostic Repository 801\u003c\/p\u003e \u003cp\u003eManaging Performance 806\u003c\/p\u003e \u003cp\u003eSources of Tuning Information 807\u003c\/p\u003e \u003cp\u003eTuning Memory 812\u003c\/p\u003e \u003cp\u003eAutomatic Shared Memory Management 813\u003c\/p\u003e \u003cp\u003eAutomatic SQL Execution Memory Management 815\u003c\/p\u003e \u003cp\u003eManaging Memory Using EM Cloud Control 817\u003c\/p\u003e \u003cp\u003eSummary 819\u003c\/p\u003e \u003cp\u003eExam Essentials 820\u003c\/p\u003e \u003cp\u003eReview Questions 821\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15 Using Backup and Recovery 825\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding and Configuring Recovery Components 827\u003c\/p\u003e \u003cp\u003eUnderstanding Control Files 827\u003c\/p\u003e \u003cp\u003eUnderstanding Checkpoints 831\u003c\/p\u003e \u003cp\u003eUnderstanding Redo Log Files 832\u003c\/p\u003e \u003cp\u003eUnderstanding Archived Redo Log (ARCHIVELOG) Files 839\u003c\/p\u003e \u003cp\u003eUnderstanding the Fast Recovery Area 844\u003c\/p\u003e \u003cp\u003ePerforming Backups 848\u003c\/p\u003e \u003cp\u003eUnderstanding Backup Terminology 848\u003c\/p\u003e \u003cp\u003eBacking Up the Control File 850\u003c\/p\u003e \u003cp\u003eBacking Up the Database 851\u003c\/p\u003e \u003cp\u003eUsing RMAN to Perform Backups 852\u003c\/p\u003e \u003cp\u003eManaging Backups 861\u003c\/p\u003e \u003cp\u003eUnderstanding Types of Database Failures 864\u003c\/p\u003e \u003cp\u003eStatement Failures 865\u003c\/p\u003e \u003cp\u003eUser-Process Failures 865\u003c\/p\u003e \u003cp\u003eNetwork Failures 866\u003c\/p\u003e \u003cp\u003eUser-Error Failures 866\u003c\/p\u003e \u003cp\u003eInstance Failures 867\u003c\/p\u003e \u003cp\u003eMedia Failures 868\u003c\/p\u003e \u003cp\u003ePerforming Recovery Operations 868\u003c\/p\u003e \u003cp\u003eUnderstanding Instance Startup 868\u003c\/p\u003e \u003cp\u003eKeeping an Instance from Failing 870\u003c\/p\u003e \u003cp\u003eRecovering from Instance Failure 870\u003c\/p\u003e \u003cp\u003eTuning Instance Recovery 871\u003c\/p\u003e \u003cp\u003eRecovering from User Errors 873\u003c\/p\u003e \u003cp\u003eRecovering from the Loss of a Control File 881\u003c\/p\u003e \u003cp\u003eUsing the Data Recovery Advisor 883\u003c\/p\u003e \u003cp\u003eRecovering from the Loss of a Redo Log File 884\u003c\/p\u003e \u003cp\u003eRecovering from the Loss of a Non-System-Critical Data File 886\u003c\/p\u003e \u003cp\u003eRecovering from the Loss of a System-Critical Data File 892\u003c\/p\u003e \u003cp\u003eTable Recovery Using RMAN 893\u003c\/p\u003e \u003cp\u003eSummary 894\u003c\/p\u003e \u003cp\u003eExam Essentials 895\u003c\/p\u003e \u003cp\u003eReview Questions 897\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16 Controlling Resources and Jobs 903\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eResource Management with the Resource Manager 904\u003c\/p\u003e \u003cp\u003eFunctions of the Resource Manager 904\u003c\/p\u003e \u003cp\u003eUnderstanding Resource Manager Components 905\u003c\/p\u003e \u003cp\u003eConfiguring the Database Resource Manager 911\u003c\/p\u003e \u003cp\u003eAccessing and Creating Resource Plans 916\u003c\/p\u003e \u003cp\u003eUpdating and Deleting Resources 924\u003c\/p\u003e \u003cp\u003eMonitoring the Resource Manager 927\u003c\/p\u003e \u003cp\u003eTask Automation with Oracle Scheduler 930\u003c\/p\u003e \u003cp\u003eScheduler Architecture 930\u003c\/p\u003e \u003cp\u003eUsing Oracle Scheduler 934\u003c\/p\u003e \u003cp\u003eRelating Tasks with Job Chains 943\u003c\/p\u003e \u003cp\u003eScheduling Jobs on Remote Systems 947\u003c\/p\u003e \u003cp\u003ePrioritizing Jobs with Oracle Scheduler 948\u003c\/p\u003e \u003cp\u003eSummary 951\u003c\/p\u003e \u003cp\u003eExam Essentials 951\u003c\/p\u003e \u003cp\u003eReview Questions 952\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17 Upgrading to Oracle Database 12c 957\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDetermining the Database Upgrade Method 958\u003c\/p\u003e \u003cp\u003eUsing Direct Upgrade 959\u003c\/p\u003e \u003cp\u003eMigrating to Oracle Database 12c 961\u003c\/p\u003e \u003cp\u003ePreparing for a Database Upgrade 963\u003c\/p\u003e \u003cp\u003eRunning the Pre-Upgrade Information Tool 964\u003c\/p\u003e \u003cp\u003ePreparing the Oracle Home 974\u003c\/p\u003e \u003cp\u003eReducing Upgrade Downtime 975\u003c\/p\u003e \u003cp\u003eUpgrading the Database 976\u003c\/p\u003e \u003cp\u003eUsing Database Upgrade Assistant 976\u003c\/p\u003e \u003cp\u003ePerforming a Manual Upgrade 987\u003c\/p\u003e \u003cp\u003eCompleting the Post-Upgrade Tasks 991\u003c\/p\u003e \u003cp\u003eMigrating to Unified Auditing 994\u003c\/p\u003e \u003cp\u003eDowngrading to an Earlier Release 995\u003c\/p\u003e \u003cp\u003eSummary 997\u003c\/p\u003e \u003cp\u003eExam Essentials 997\u003c\/p\u003e \u003cp\u003eReview Questions 999\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18 Using Grid Infrastructure and Data Movement Tools 1005\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTools for Moving Data 1006\u003c\/p\u003e \u003cp\u003eMigrating Data Using Data Pump 1008\u003c\/p\u003e \u003cp\u003eData Pump Architecture 1009\u003c\/p\u003e \u003cp\u003eUsing Data Pump Clients 1012\u003c\/p\u003e \u003cp\u003eUsing the Data Pump Wizard 1033\u003c\/p\u003e \u003cp\u003eUpgrading an 11g R2 Database to 12c\u003c\/p\u003e \u003cp\u003eUsing Full Transportable Export 1037\u003c\/p\u003e \u003cp\u003eLoading Data with SQL*Loader 1039\u003c\/p\u003e \u003cp\u003eSpecifying SQL*Loader Command-Line Parameters 1040\u003c\/p\u003e \u003cp\u003eSpecifying Control File Options 1042\u003c\/p\u003e \u003cp\u003ePopulating External Tables 1046\u003c\/p\u003e \u003cp\u003eLoading External Tables Using Data Pump 1046\u003c\/p\u003e \u003cp\u003eLoading External Tables Using Loader 1048\u003c\/p\u003e \u003cp\u003eIntroducing Grid Infrastructure 1050\u003c\/p\u003e \u003cp\u003eInstalling Oracle Grid Infrastructure 1051\u003c\/p\u003e \u003cp\u003eManaging Oracle ASM Storage 1061\u003c\/p\u003e \u003cp\u003eUsing Oracle Restart 1068\u003c\/p\u003e \u003cp\u003eSummary 1076\u003c\/p\u003e \u003cp\u003eExam Essentials 1077\u003c\/p\u003e \u003cp\u003eReview Questions 1078\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix A Answers to Review Questions 1083\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Introducing Oracle Database 12c RDBMS 1084\u003c\/p\u003e \u003cp\u003eChapter 2: Introducing SQL 1085\u003c\/p\u003e \u003cp\u003eChapter 3: Using Single-Row Functions 1087\u003c\/p\u003e \u003cp\u003eChapter 4: Using Group Functions 1089\u003c\/p\u003e \u003cp\u003eChapter 5: Using Joins and Subqueries 1090\u003c\/p\u003e \u003cp\u003eChapter 6: Manipulating Data 1092\u003c\/p\u003e \u003cp\u003eChapter 7: Creating Tables and Constraints 1094\u003c\/p\u003e \u003cp\u003eChapter 8: Introducing Oracle Database 12c Components and Architecture 1096\u003c\/p\u003e \u003cp\u003eChapter 9: Creating and Operating Oracle Database 12c 1098\u003c\/p\u003e \u003cp\u003eChapter 10: Understanding Storage and Space Management 1100\u003c\/p\u003e \u003cp\u003eChapter 11: Managing Data Concurrency and Undo 1102\u003c\/p\u003e \u003cp\u003eChapter 12: Understanding Oracle Network Architecture 1104\u003c\/p\u003e \u003cp\u003eChapter 13: Implementing Security and Auditing 1106\u003c\/p\u003e \u003cp\u003eChapter 14: Maintaining the Database and Managing Performance 1108\u003c\/p\u003e \u003cp\u003eChapter 15: Using Backup and Recovery 1110\u003c\/p\u003e \u003cp\u003eChapter 16: Controlling Resources and Jobs 1112\u003c\/p\u003e \u003cp\u003eChapter 17: Upgrading to Oracle Database 12c 1114\u003c\/p\u003e \u003cp\u003eChapter 18: Using Grid Infrastructure and Data Movement Tools 1116\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix B About the Additional Study Tools 1119\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdditional Study Tools 1120\u003c\/p\u003e \u003cp\u003eSybex Test Engine 1120\u003c\/p\u003e \u003cp\u003eElectronic Flashcards 1120\u003c\/p\u003e \u003cp\u003eBonus Author Materials 1120\u003c\/p\u003e \u003cp\u003ePDF of Glossary of Terms 1120\u003c\/p\u003e \u003cp\u003eAdobe Reader 1121\u003c\/p\u003e \u003cp\u003eSystem Requirements 1121\u003c\/p\u003e \u003cp\u003eUsing the Study Tools 1121\u003c\/p\u003e \u003cp\u003eTroubleshooting 1121\u003c\/p\u003e \u003cp\u003eCustomer Care 1122\u003c\/p\u003e \u003cp\u003eIndex 1123\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Business applications [\u003ca title=\"See our other books on Business applications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Business%20applications%20%5BUF%5D%22\"\u003eUF\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Sybex","offers":[{"title":"Brand New","offer_id":52417795064088,"sku":"9781118643952","price":39.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781118643952.jpg?v=1784509642","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/oca-oracle-database-12c-administrator-certified-associate-study-guide-exams-1z0-061-and-1z0-062-paperback-softback-9781118643952","provider":"Freshly Printed Books","version":"1.0","type":"link"}