OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051

Front Cover
McGraw Hill Professional, Jun 20, 2008 - Computers - 581 pages
4 Reviews

A Fully Integrated Study System for OCA Exam 1Z0-051

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including:

  • SQL SELECT statements
  • Restricting and sorting data
  • Single-row functions
  • Conversion functions and conditional expressions
  • Group functions
  • Displaying data from multiple tables
  • Subqueries
  • Set operators
  • DML and DDL statements
  • Schema objects

On the CD-ROM:

  • One full practice exam that simulates the actual OCA exam
  • Detailed answers and explanations
  • Score report performance assessment tool
  • Complete electronic book
  • Bonus exam available free with online registration

What people are saying - Write a review

We haven't found any reviews in the usual places.


1 Oracle Server Technologies and the Relational Paradigm
2 Data Retrieval Using the SQL SELECT Statement
3 Restricting and Sorting Data
4 SingleRow Functions
5 Using Conversion Functions and Conditional Expressions
6 Reporting Aggregated Data Using the Group Functions
7 Displaying Data from Multiple Tables
8 Using Subqueries to Solve Problems
9 Using the Set Operators
10 Manipulating Data
11 Using DDL Statements to Create and Manage Tables
12 Creating Other Schema Objects

Common terms and phrases

Popular passages

Page 114 - Equal to <> Not equal to < Less than > Greater than <= Less than or equal to...
Page xx - The Certification Summary is a succinct review of the chapter and a restatement of salient points regarding the exam. The Two-Minute Drill at the end of every chapter is a checklist of the main points of the chapter. It can be used for last-minute review. The Self Test offers questions similar to those found on the certification exams.
Page xxi - Complete the Exercises. Did you do the exercises when you read through each chapter? If not, do them! These exercises are designed to cover exam topics, and there's no better way to get to know this material than by practicing.
Page xx - In Every Chapter We've created a set of chapter components that call your attention to important items, reinforce important points, and provide helpful exam-taking hints. Take a look at what you'll find in every chapter: • Every chapter begins with the Certification Objectives — what you need to know in order to pass the section on the exam dealing with the chapter topic. The Objective headings identify the objectives within the chapter, so you'll always know an objective when you see it!
Page xxi - Some Pointers Once you've finished reading this book, set aside some time to do a thorough review. You might want to return to the book several times and make use of all the methods it offers for reviewing the material: 1 . Reread all the Two-Minute Drills, or have someone quiz you.
Page xxi - You might want to make some flash cards out of 3 x 5 index cards that have the Two-Minute Drill material on them. 2. Re-read all the Exam Watch notes. Remember that these notes are written by authors who have taken the exam and passed. They know what you should expect — and what you should be on the lookout for. 3. Review all the S&S sections for quick problem solving.
Page 91 - SELF TEST The following questions will help you measure your understanding of the material presented in this chapter. Read all the choices carefully because there may be more than one correct answer.
Page xxi - The answers to these questions, as well as explanations of the answers, can be found at the end of each chapter. By taking the Self Test after completing each chapter, you'll reinforce what you've learned from that chapter while becoming familiar with the structure of the exam questions. The Lab...
Page 533 - LearnKey." To run MasterExam, use START I PROGRAMS I LEARNKEY. If the auto-run feature did not launch your CD, browse to the CD and click on the Runlnstall icon. MasterExam MasterExam provides you with a simulation of the actual exam. The number of questions, the type of questions, and the time allowed are intended to be an accurate representation of the exam environment. You have the option to take an open-book exam, including hints, references, and answers, a closed-book exam, or the timed MasterExam...
Page xx - They help you master skills that are likely to be an area of focus on the exam. Don't just read through the exercises; they are hands-on practice that you should be comfortable completing. Learning by doing is an effective way to increase your competency with a product. On The Job notes describe the issues that come up most often in real-world settings. They provide a valuable perspective on certification- and productrelated topics. They point out common mistakes and address questions that have arisen...

About the author (2008)

John Watson, OCP, is a senior consultant with BLP management Consultants and taught for Oracle University in South Africa for four years. He is the coauthor of Oracle Database 10g OCP Certification All-in-One Exam Guide.

Roopesh Ramklass, OCP, is a technical specialist with 10 years of experience in a wide variety of IT environments.

Bibliographic information