Skip to main content
  • Hoopla logo
  • Browse
  • My Hoopla
  • Log In
Books, videos, and music - all free from your public library!
LoginSign Up

Footer

Hoopla logo, Go to homepage
  • For Patrons
  • For Libraries (opens in new window)
  • For Vendors (opens in new window)
  • Facebook (opens in new window)
  • X (opens in new window)
  • Instagram (opens in new window)
  • YouTube (opens in new window)
  • TikTok (opens in new window)
  • LinkedIn (opens in new window)

Our Company

  • Our Story
  • Get Hoopla for your Library (opens in new window)
  • Get your content on hoopla (opens in new window)
  • Join our team (opens in new window)
  • Accessibility Statement

Our Content

  • Audiobooks
  • Ebooks
  • Movies
  • Television
  • Comics
  • BingePasses
  • Music
  • The Loop Blog

Help

  • Help Center
  • Submit Feedback
  • Facebook (opens in new window)
  • X (opens in new window)
  • Instagram (opens in new window)
  • YouTube (opens in new window)
  • TikTok (opens in new window)
  • LinkedIn (opens in new window)
  • Download on the App Store (opens in new window)
  • Get it on Google Play (opens in new window)
  • Available at Amazon Appstore (opens in new window)
© 2026 Midwest Tape, LLC. All rights reserved. Privacy Policy | Terms of Use
  1. Navigate Home
  3. Ebooks

  4. OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

EBOOK

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

Steve O'HearnSeries: Oracle Press
(0)
sign up
Pages
832
Year
2017
Language
English
Publisher
McGraw Hill LLC

About

A fully updated, integrated self-study system for the Oracle Database SQL Exam

This thoroughly revised Oracle Press guide offers 100% coverage of all objectives on the latest version of the Oracle Database SQL Exam. Ideal both as a study guide and on-the-job reference, OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) features detailed explanations, examples, practice questions, and chapter summaries. "Certification Objectives," "Exam Watch," and "On the Job" sections reinforce salient points throughout. You will gain access to two complete practice exams that match the tone, tenor, and format of the live test.

Get complete coverage every topic on Exam 1Z0-071, including:

• DDL and SQL SELECT statements

• Manipulating, restricting, and sorting data

• Single-row and group functions

• Displaying data from multiple tables

• Subqueries

• Schema objects

• Set operators

• Grouping related data

• Report creation

• Data dictionary views

• Large data sets

• Hierarchical retrieval

• Regular expression support

• User access control

The electronic includes:

• Two full practice exams

• Detailed answers and explanations

Related Subjects

  • Database Administration & Management
  • Computers
  • Adult Nonfiction
  • General
  • Certification Guides
  • SQL
  • Languages
  • Data Analytics
  • Data Science
  • Databases
  • Business & Productivity Software

Extended Details

  • SeriesOracle Press

    Artists

    Steve O'HearnAuthor