Our offices will be closed Thursday, November 22nd, and Friday, November 23rd, in observance of the Thanksgiving holiday. Limited Technical Support will be available via email at kps.techsupport@kaplan.com during business hours. We look forward to serving you when we return Monday, November 26th.

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

For more information about the 1Z0-071 exam, visit the Oracle site.

*These exam objectives can change at any time.

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)

  • A single set of focused exam-like questions
  • Custom quiz settings to drill down into specific topics
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Online access only
  • Upgrade to the 180-Day Exam Preparation for only $40

180-Day Exam Preparation (Online + Download)

  • Multiple unique sets of exam-like questions for additional exam experiences
  • Custom quiz settings to drill down into specific topics
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Performance Tracker to see how your performance stacks up to others
  • Full set of key concepts flashcards to memorize critical information
  • Online access and downloadable and printable quizzes for offline study
  • Study Calendar to optimize your exam study time
  • Student Discussion Board to share study tips
  • InstructorLink™ to contact our IT experts
  • Pass Guarantee to ensure your success

Build Your Package:

Kaplan IT Training Certification Package Grid Image