LEADER 05487nam 2200685Ia 450 001 9910459480003321 005 20200520144314.0 010 $a1-118-05942-5 010 $a1-282-55025-X 010 $a9786612550256 010 $a0-470-48834-4 035 $a(CKB)2670000000014490 035 $a(EBL)510226 035 $a(OCoLC)609861546 035 $a(SSID)ssj0000363819 035 $a(PQKBManifestationID)11267754 035 $a(PQKBTitleCode)TC0000363819 035 $a(PQKBWorkID)10393973 035 $a(PQKB)10273750 035 $a(MiAaPQ)EBC510226 035 $a(CaSebORM)9780470395127 035 $a(Au-PeEL)EBL510226 035 $a(CaPaEBR)ebr10381125 035 $a(CaONFJC)MIL255025 035 $a(EXLCZ)992670000000014490 100 $a20081202d2009 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOCA$b[electronic resource] $eOracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) /$fBiju Thomas 205 $a1st ed. 210 $aIndianapolis, Ind. $cWiley Pub.$d2009 215 $a1 online resource (1158 p.) 225 1 $aSerious skills 300 $aIncludes index. 311 $a0-470-39512-5 327 $aOCA OracleŽ Database 11g Administrator Certified Associate Study Guide; Acknowledgments; About the Author; Contents at a Glance; Contents; Introduction; SQL Fundamentals I Assessment Test; Answers to SQL Fundamentals I Assessment Test; Administration I Assessment Test; Answers to Administration I Assessment Test; Part I: Oracle Database 11g: SQL Fundamentals I; Chapter 1: Introducing SQL; SQL Fundamentals; Writing Simple Queries; Accepting Values at Runtime; Summary; Exam Essentials; Untitled; Review Questions; Answers to Review Questions; Chapter 2: Using Single-Row Functions 327 $aSingle-Row Function FundamentalsUsing Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 3: Using Group Functions; Group-Function Fundamentals; Utilizing Aggregate Functions; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 4: Using Joins and Subqueries; Writing Multiple-Table Queries; Using Set Operators; Subqueries; Summary; Exam Essentials; Review Questions 327 $aAnswers to Review QuestionsChapter 5: Manipulating Data; Using DML Statements; Understanding Transaction Control; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 6: Creating Tables and Constraints; Database Objects Overview; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 7: Creating Schema Objects; Creating and Modifying Views; Creating and Managing Sequences; Creating and Managing Synonyms; Creating and Managing Indexes; Summary; Exam Essentials 327 $aReview QuestionsAnswers to Review Questions; Part II: Oracle Database 11g: Administration I; Chapter 8: Introducing Oracle Database 11g Components and Architecture; Oracle Database Fundamentals; Oracle 11g Architecture; Installing Oracle 11g; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 9: Creating an Oracle 11g Database; Using DBCA to Create Oracle 11g Databases; Working with Oracle 11g Metadata; Managing Initialization-Parameter Files; Starting Up and Shutting Down an Oracle Instance; Monitoring the Database Alert Log; Summary; Exam Essentials 327 $aReview QuestionsAnswers to Review Questions; Chapter 10: Allocating Database Storage and Creating Schema Objects; Tablespaces and Data Files Overview; Managing Tablespaces; Managing Data Files; Working with Schema Objects; Summary; Exam Essentials; Review Questions; Answers to Review Questions; Chapter 11: Understanding Network Architecture; Introducing Network Configurations; An Overview of Oracle Net Features; Configuring Oracle Net on the Server; Configuring Oracle Net for the Client; An Overview of Oracle Shared Server; Oracle Shared Server Infrastructure; Summary; Exam Essentials 327 $aReview Questions 330 $aCandidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification-this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you'll learn how to create and maintain an Oracle database, perform database backups and recov 410 0$aSerious skills. 606 $aElectronic data processing personnel$xCertification 606 $aDatabase management$xExaminations$vStudy guides 608 $aElectronic books. 615 0$aElectronic data processing personnel$xCertification. 615 0$aDatabase management$xExaminations 676 $a005.75/75 700 $aThomas$b Biju$0866959 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910459480003321 996 $aOCA$92238271 997 $aUNINA