OCA Oracle database 11g administrator certified associate study guide (1Z0-051 and 1Z0-052)
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...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, Ind. :
Wiley Pub
2009.
|
| Edición: | 1st ed |
| Colección: | Serious skills.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628205806719 |
Tabla de Contenidos:
- 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
