OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051A 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:
On the CD-ROM:
|
Contents
| 1 | |
| 51 | |
3 Restricting and Sorting Data | 103 |
4 SingleRow Functions | 169 |
5 Using Conversion Functions and Conditional Expressions | 227 |
6 Reporting Aggregated Data Using the Group Functions | 273 |
7 Displaying Data from Multiple Tables | 309 |
8 Using Subqueries to Solve Problems | 357 |
9 Using the Set Operators | 381 |
10 Manipulating Data | 403 |
11 Using DDL Statements to Create and Manage Tables | 449 |
12 Creating Other Schema Objects | 487 |
Appendix | 533 |
Glossary | 537 |
Index | 555 |
Common terms and phrases
aliased ampersand substitution best answer bitmap index Cartesian product CERTIFICATION OBJECTIVE character data character literal character string Choose the best column values command COMMISSION_PCT compound query connect conversion functions converted data type default defined DELETE DEPARTMENT_ID values DEPARTMENT_NAME DEPARTMENTS table dual Query DUAL table EMPLOYEE_ID EMPLOYEES table error evaluated exam example executed expr expression Figure FIRST_NAME following query foreign key format mask GROUP BY clause group functions HIRE_DATE HR schema inner join insert join condition keyword natural join null values number of rows optional Oracle Application Server Oracle Corporation Oracle database Oracle Enterprise Manager Oracle server ORDER BY clause outer join parameter PL/SQL primary key REGION_ID REGION_NAME result set retrieved ROLLBACK rows returned SALARY value SELECT clause select last_name SELECT statement sequence session sort specified SQL Developer SQL statement SQL*Plus stored subquery substitution variable synonym syntax SYSDATE target tables transaction TRUNCATE unique update
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...