OCA [[electronic resource] ] : Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052) / / Biju Thomas

• Record Nr.: UNINA9910459480003321
• Autore: Thomas Biju
• Pubbl/distr/stampa: Indianapolis, Ind., : Wiley Pub., 2009
• ISBN: 1-118-05942-5; 1-282-55025-X; 9786612550256; 0-470-48834-4
• Edizione: [1st ed.]
• Descrizione fisica: 1 online resource (1158 p.)
• Collana: Serious skills
• Disciplina: 005.75/75
• Soggetti: Electronic data processing personnel - Certification; Database management - Examinations; Electronic books.
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.
• Nota di contenuto: OCA 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; Single-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; Answers 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; Review 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; Review 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; Review Questions
• Sommario/riassunto: Candidates 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