1. Home
  2. Oracle
  3. 1Z0-071 Exam Syllabus

Oracle 1Z0-071 Exam Syllabus

Start Free 1Z0-071 Exam Practice After Reviewing the Topics

Before starting your 1Z0-071 exam preparation, it is recommended to review the complete Oracle Database SQL exam syllabus and carefully go through the exam objectives listed below. Once you understand the exam structure and objectives, you should practice using our free 1Z0-071 questions. We also provide premium 1Z0-071 practice test, fully updated according to the latest exam objectives, to help you accurately assess your preparedness for the actual exam.

Oracle
Vendor
1Z0-071
Exam Code
326
Total Questions
16
Total Exam Domains

START FREE 1Z0-071 EXAM PRACTICE

NO SIGNUP REQUIRED  •  100% FREE TO START

1Z0-071 EXAM QUESTIONS

Oracle 1Z0-071 Exam Objectives

Section 1: Relational Database concepts
Weight:
-
  • Explaining the theoretical and physical aspects of a relational database
  • Relating clauses in SQL Select Statement to Components of an ERD
  • Explaining the relationship between a database and SQL
Section 2: Retrieving Data using the SQL SELECT Statement
Weight:
-
  • Using Column aliases
  • Using The SQL SELECT statement
  • Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Using Arithmetic expressions and NULL values in the SELECT statement

 
Section 3: Restricting and Sorting Data
Weight:
-
  • Applying Rules of precedence for operators in an expression
  • Limiting Rows Returned in a SQL Statement
  • Using Substitution Variables
  • Using the DEFINE and VERIFY commands
  • Sorting Data
Section 4: Using Single-Row Functions to Customize Output
Weight:
-
  • Manipulating strings with character functions in SQL SELECT and WHERE clauses
  • Performing arithmetic with date data
  • Manipulating numbers with the ROUND, TRUNC and MOD functions
  • Manipulating dates with the date function
Section 5: Using Conversion Functions and Conditional Expressions
Weight:
-
  • Applying the NVL, NULLIF, and COALESCE functions to data
  • Understanding implicit and explicit data type conversion
  • Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nesting multiple functions
Section 6: Reporting Aggregated Data Using Group Functions
Weight:
-
  • estricting Group Results
  • Creating Groups of Data
  • Using Group Functions
Section 7: Displaying Data from Multiple Tables
Weight:
-
  • Using Self-joins
  • Using Various Types of Joins
  • Using Non equijoins
  • Using OUTER joins
  • Understanding and Using Cartesian Products
Section 8: Using Subqueries to Solve Queries
Weight:
-
  • Using Single Row Subqueries
  • Using Multiple Row Subqueries
  • Update and delete rows using correlated subqueries
Section 9: Using SET Operators
Weight:
-
  • Matching the SELECT statements
  • Using the ORDER BY clause in set operations
  • Using The INTERSECT operator
  • Using The MINUS operator
  • Using The UNION and UNION ALL operators
Section 10: Managing Tables using DML statements
Weight:
-
  • Managing Database Transactions
  • Controlling transactions
  • Perform Insert, Update and Delete operations
  • Performing multi table Inserts
  • Performing Merge statements
Section 11: Managing Indexes Synonyms and Sequences
Weight:
-
  • Managing Indexes
  • Managing Synonyms
  • Managing Sequences
Section 12: Use DDL to manage tables and their relationships
Weight:
-
  • Describing and Working with Tables
  • Describing and Working with Columns and Data Types
  • Creating tables
  • Dropping columns and setting column UNUSED
  • Truncating tables
  • Creating and using Temporary Tables
  • Creating and using external tables
  • Managing Constraints
Section 13: Managing Views
Weight:
-
  • Managing Views
Section 14: Controlling User Access
Weight:
-
  • Differentiating system privileges from object privileges
  • Granting privileges on tables
Section 15: Managing Objects with Data Dictionary Views
Weight:
-
  • Using data dictionary views
Section 16: Managing Data in Different Time Zones
Weight:
-
  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
  • Working with INTERVAL data types
Info
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-071