Oracle Database 12c SQL 1Z0-071

Share this page:


Become an Oracle Database SQL Certified Associate and demonstrate understanding of fundamental SQL concepts needed to undertake any database project. Passing the exam illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. Gain a working knowledge of queries , insert, update and delete SQL statements as well as some Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. By passing this exam, a certified individual proves fluency in and a solid understanding of SQL language . data modeling and using SQL to create amd manipulate tables in an Oracle Database.

Qualified candidates have knowledge of general computing concepts, knowledge of command line interfaces and experience working in command line.

Exam Details

Duration:100 minutes
Number of Questions:


Passing Score:63%
View passing score policy
Validated Against:

This exam was validated against 11g Release 2 version and up to 12c Release 1 version

Format:Multiple Choice
Exam Price:Rs 9701 More on exam pricing

Course Content / Exam(s)

Retrieving Data Using the SQL SELECT Statement

  • List the capabilities of SQL SELECT statements.
  • Execute a basic SELECT statement.

Restricting and Sorting Data

  • Limit the rows that are retrieved by a query
  • Sort the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime

Using Single-Row Functions to Customize Output

  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

  • Describe various types of conversion functions that are available in SQLL.
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions.
  • Apply conditional expressions in a SELECT statement.

Reporting Aggregated Data Using the Group Functions

  • Identify the available group functions.
  • Describe the use of group functions.
  • Group data by using the GROUP BY clause.
  • Include or exclude grouped rows by using the HAVING clause.

Displaying Data from Multiple Tables

  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins.
  • Join a table to itself by using a self-join.
  • Generate a Cartesian product of all rows from two or more tables.

Displaying Data from Multiple Tables

  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins.
  • Join a table to itself by using a self-join.
  • Generate a Cartesian product of all rows from two or more tables.

Using Subqueries to Solve Queries

  • Define subqueries
  • Describe the types of problems that the subqueries can solve .
  • List the types of subqueries .
  • Write single-row and multiple-row subqueries.

Using the Set Operators

  • Describe set operators
  • Use a set operator to combine multiple queries into a single query .
  • Control the order of rows returned.

Manipulating Data

  • Describe each data manipulation language (DML) statement.
  • Insert rows into a table .
  • Update rows in a table .
  • Delete rows from a table .
  • Control transactions.

Using DDL Statements to Create and Manage Tables

  • Categorize the main database objects.
  • Review the table structure.
  • List the data types that are available for columns.
  • Create a simple table.
  • Explain how constraints are created at the time of table creation.
  • Describe how schema objects work.

Creating Other Schema Objects

  • Create simple and complex views.
  • Retrieve data from views.
  • Create, maintain, and use sequences.
  • Create and maintain indexes.
  • Create private and public synonyms.

Controlling User Access

  • Differentiate system privileges from object privileges.
  • Grant privileges on tables and on a user.
  • Distinguish between privileges and roles.

Managing Schema Objects

  • Describe how schema objects work.
  • Create simple and complex views with visible/invisible columns.
  • Create, maintain, and use sequences.
  • Create and maintain indexes including invisible indexes and multiple indexes on the same columns.
  • Perform flashback operations.

Managing Objects with Data Dictionary Views

  • Query various data dictionary views.

Manipulating Large Data Sets

  • Describe the features of multitable INSERTs.
  • Merge row in a table.

Retrieving Data By Using Subqueries

  • Multiple-Column Subqueries.
  • Column Comparisons.
  • Pairwise Comparison Subquery.
  • Nonpairwise Comparison Subquery.
  • Scalar Subquery Expressions.
  • Correlated Subqueries.
  • Using the EXISTS & NOT EXISTS Operator.
  • Correlated Update.
  • Correlated Delete.
  • WITH Clause.
  • Recursive WITH Clause.


Ameya Linge

Ameya Linge

Learning Oracle Database Administration here. Experiencing a nice way of teaching from Saurabh Joshi(Oracle guru) Sir. A good feature is that it is more practical oriented rather than theorotical. Definitely recommended for learning Oracle based subjects.
Tushar Kottawar

Tushar Kottawar

For someone who is in dilemma and is asking any of the following questions: 1) "Whether this course is right for me?" 2) "I am a recent graduate. What should I do next?" 3) "I am working professional and I want change my domain. Which domain should I choose that would shape my professional career?" 4) "I am a Non-IT graduate. I want to change my career track to IT. Which course is more beneficial?" You should visit Unisoft Technologies for the RIGHT career guidance and also to get a deep insight about different IT technologies. Unisoft Technologies is a place full of professionally trained counselors and highly experienced faculties. I have been a part of Unisoft Technologies for over a year now. I started my journey with Unisoft as a C++ student and eventually learned Java and Oracle Database. Considering I am from a Non-IT background I was initially not sure which course to choose. I knew only about C, C++ and Java before i visited Unisoft. My counselor at the time was Asha Pandit madam. She introduced me to a whole new world that exists besides Java. No only that she also explained about different types of Certifications and its importance for the students and especially freshers. I learned C++ under the guidance of Shyam Nasre sir and Java under Leena Khawshi madam. Both these faculties are the best in their respective field. They make the subject look easy even for someone who is not from an IT background.! I learned Oracle Database under the guidance of Saurabh Joshi sir. He is the best faculty I have ever known. Highly experienced and with a vast ocean of knowledge he is the best when it comes to teaching Oracle Database. He is my teacher, my guide and my mentor till date. My other mentor in Unisoft is Pratigya madam. She is always the one who will constanlty motivate me and will keep on providing with lots of knowledge anout different technologies. At Unisoft its not just about giving our best, Its about bringing out the best in students. We have branches in Nagpur and Pune. Our excellent counselors include Trupti madam, Ashwini madam, Sonali madam, Anuradha madam, Priyanka madam, Akshay sir, Kirti madam, Shahid sir and Ankita mam. Each and every one of them will guide you CORRECTLY. I would recommend Unisoft to all the students, fresher graduates, job seekers as well as working professionals who are looking to change their domain or are looking to enhance their skillset.
Anuja Rananware

Anuja Rananware

Unisoft Technologies is the best Institute for training and courses. This is the best platform for getting the Global Certification Courses and for learning. Environment is good for practice and study. Faculty is good.My faculty Mr. Tushar sir is well experienced and good at his teaching. He is helpful in nature and always available for our queries..
© 2017 Unisoft Technologies - Pune, Nagpur | Developed By In House Team