June 18, 2020 0 By admin

OCA Oracle® Database 11g Administrator Certified Associate: Study Guide. 2 reviews. by Biju Thomas. Publisher: Sybex. Release Date: April Books By Biju Thomas Similar Authors To Biju Thomas . OCA: Oracle Database 11g Administrator Certified Associate Study Guide: Exams 1Z and. Thank you for choosing OCA: Oracle Database 11g Administrator Certified Biju Thomas is an Oracle , Oracle8, Oracle8i, Oracle9i, Oracle 10g, and Oracle.

Author: Zuran Malahn
Country: Portugal
Language: English (Spanish)
Genre: Career
Published (Last): 11 August 2018
Pages: 328
PDF File Size: 16.76 Mb
ePub File Size: 17.79 Mb
ISBN: 111-2-41910-619-9
Downloads: 26215
Price: Free* [*Free Regsitration Required]
Uploader: Zululrajas

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z and 1Z 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.

Stay blju with the world’s most comprehensive technology and business learning platform. With Safari, you learn the way ibju learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

OCA Oracle® Database 11g Administrator Certified Associate: Study Guide

Start Free Trial No credit card required. Study Guide 2 reviews. View table of contents. Book Description Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z and 1Z to achieve their certification—this guide prepares you for taking both those exams. SQL Fundamentals I 1. Entering SQL Statements 1. Editing the SQL Buffer 1. Using Script Files 1. Saving Query Results to a File 1. Adding Comments to a Script File 1. Operators and Literals 1.


Writing Simple Queries 1. Column Alias Names 1. Logical Operator Truth Tables 1. Accepting Values at Runtime 1. Using Substitution Variables 1. Saving a Variable for a Session 1. Using Positional Notation for Variables 1. Answers to Review Questions 2. Using Single-Row Functions 2. Single-Row Function Fundamentals 2. Using Single-Row Character Functions 2.

Character Function Overview 2. Character Function Descriptions 2. Using Single-Row Numeric Functions 2. Numeric Function Overview 2. Numeric Function Descriptions 2. Using Thojas Date Functions 2.

Using Single-Row Conversion Functions 2. Using Other Single-Row Functions 2. Answers to Review Questions 3. Hhomas Group Functions 3. Utilizing Aggregate Functions 3. Nesting Group Functions 3.

Answers to Review Questions 4. Using Joins and Subqueries 4. Writing Multiple-Table Queries 4. Simple Inner Joins 4. Complex Inner Joins 4. Using Table Aliases 4. Left Outer Joins 4. Right Outer Joins 4. Full Outer Joins 4. Other Multiple-Table Queries 4. Using Set Operators 4. Putting It All Together 4.

Subquery Returns No Rows 4. Answers to Review Questions 5. Using DML Statements 5. Inserting Rows into a Table 5. Inserting Rows from a Subquery 5. Inserting Rows into Multiple Tables 5. Updating Rows in a Table 5. Updating Rows Using a Subquery 5. Deleting Rows from a Table 5. Truncating a Table 5. Understanding Transaction Control 5. Savepoints and Partial 111g 5. Consistency and Transactions 5.


Answers to Review Questions 6. Creating Tables and Thommas 6. Database Objects Overview 6. Date and Time Datatypes 6. Row ID Datatypes 6. Naming Tables and Columns 6. Specifying Default Values for Columns 6. Creating a Table from Another Table 6. Making Tables Read-Only 6. Primary Key Constraints 6.

Foreign Key Constraints 6. Enabling and Disabling Constraints 6. Deferring Constraint Checks 6. Answers to Review Questions 7.

Creating Schema Objects 7. Creating and Modifying Views 7. Using Defined Column Names 7. Creating Views with Errors 7.

Creating Read-Only Views 7. Creating Constraints on Views 7. Changing a View’s Definition 7. Recompiling a View 7. Dropping a View 7. Using Views in Queries 7. Inserting, Updating, and Deleting Data through Views 7. Using Join Views 7.

Biju’s Oracle DBA Page

Using Inline Views 7. Performing Top-n Analysis 7. Creating and Managing Sequences 7. Creating and Dropping Sequences 7. Missing Sequence Values 7. Maximum and Minimum Values 7. Creating and Managing Synonyms 7. Creating and Dropping Synonyms 7. Resolving Object References 7.