1Z0-071Oracle Database SQL (OCA)

Candidates for the Oracle Database SQL certification exam are interested in demonstrating and understanding fundamental SQL concepts needed to undertake any database project. Oracle suggests candidates have knowledge of general computing concepts, knowledge of command line interfaces, and experience working in command line.

This exam measures the following skills:

  • Oracle and Structured Query Language (SQL)
  • Restricting and sorting data
  • Using single-row functions to customize output
  • Using conversion functions and conditional expressions
  • Reporting aggregated data using the group functions
  • Displaying data from multiple tables
  • Using sub-queries to solve queries
  • Using the set operators
  • Using DDL statements to create and manage tables
  • Managing objects with data dictionary views
  • Controlling user access
  • Managing schema objects

1Z0-071 Oracle Database SQL (OCA) Certification Study Package

Kaplan IT Training Certification Packages are based on Kaplan's proven learning strategy of Prepare, Practice, Perform® and are customizable to fit your preferred study method. Study at your own pace, whenever you want, and wherever you are most comfortable. Choose between our 30-Day Assessment and 180-Day Exam Preparation. Practice with exam-like questions. 

30-Day Assessment (Online only)

  • Focused exam-like questions
  • Custom quiz settings
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience

 180-Day Exam Preparation (Online + Download)

  • Full bank of exam-like questions
  • Custom quiz settings
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Performance Tracker
  • Key concepts flashcards
  • Download or print quizzes and flashcards for offline study
  • Contact our experts with InstructorLink™

Build Your Package: