Oracle 1z0-071 Preparation

Exam Name: Oracle Database SQL

228 Total Questions
Oct 12, 2019 updated
  • Exam Code: 1z0-071
  • Certification Provider: Oracle

Purchase Individually

Practice Test
228 Total Question Oct 12, 2019 Updated
Questions & Answers (PDF)
228 Total Question Oct 12, 2019 Updated
Oracle Database SQL Exam Details
Technology Oracle Advanced PL/SQL Development, SQL Server
Audience SQL Database Engineer
Related Certification(s) Oracle Database Certification


Free 3 month
Product Updates

100% Money Back

100% Real


Oracle 1z0-071 Exam Major Topics

  • Using Structured Query Language (SQL)/ Explain the relationship between a database and SQL
  • Using Data Manipulation Language (DML) and Transaction Control Language (TCL)/ Describe the purpose of DML
  • Build a SELECT statement to retrieve data from an Oracle Database table/ Use the WHERE clause to the SELECT statement to filter query results
  • Describe the different types of joins and their features/ Use joins to retrieve data from multiple tables
  • Using Conversion Functions and Conditional Expressions/ Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply general functions and conditional expressions in a SELECT statement/ Displaying Data from Multiple Tables
  • Use SELECT statements to access data from more than one table using equijoins and nonequijoins/ Join a table to itself by using a self-join
  • View data that generally does not meet a join condition by using outer joins/ Use a set operator to combine multiple queries into a single query
  • Using DDL Statements to Create and Manage Tables/ Describe data types that are available for columns/ Describe how schema objects work
  • Managing Objects with Data Dictionary Views/ Use the data dictionary views to research data on objects/ Query various data dictionary views
  • Create and maintain indexes including invisible indexes and multiple indexes on the same columns/ Drop co
  • lumns and set column UNUSED/ Explain the theoretical and physical aspects of a relational database/ Use DDL to manage tables and their relationships
  • Identify the connection between an ERD and a database using SQL SELECT statements/ Use the ORDER BY clause to sort SQL query results
  • Limit and Sort the rows that are retrieved by a query/ Use ampersand substitution to restrict and sort output at runtime/ Use various types of functions available in SQL
  • Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements/ Reporting Aggregated Data Using the Group Functions
  • Include or exclude grouped rows by using the HAVING clause/ Describe the types of problems subqueries can solve/ Update and delete rows using correlated subqueries
  • Use the EXISTS and NOT EXISTS operators/ Use single-row and multiple-row subqueries/ Create simple and complex views with visible/invisible columns/ Create, maintain and use sequences

Latest Preparation Material by ExamsTrainer

Corporate / Trainer License Program