Oracle 1Z0-061 Certification Exam Syllabus

Oracle 1Z0-061 Certification Details:

Exam Name Oracle Database 12c - SQL Fundamentals
Exam Code 1Z0-061
Exam Product Version Oracle Database 12c
Exam Price USD $245 (Pricing may vary by country or by localized currency)
Duration 120 minutes
Number of Questions 75
Passing Score 65%
Validated Against This exam has been validated against Oracle Database 12.1.0.1.0.
Format Multiple Choice
Recommended Training
Schedule Exam Pearson VUE - Oracle
Recommended Practice 1Z0-061 Class Onsite or Online Live Instruction

Oracle 1Z0-061 Certification Topics:

Introduction
- Describe the features of Oracle Database 12c
- Describe the salient features of Oracle Cloud 12c
- Explain the theoretical and physical aspects of a relational database
- Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)
Retrieving Data using the SQL SELECT Statement
- Explain 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 SQL
- 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 Using Joins
- 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
- View data that generally does not meet a join condition by using OUTER joins
- 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
- Describe 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
Managing Tables using DML statements
- Truncate data
- Insert rows into a table
- Update rows in a table
- Delete rows from a table
- Control transactions
Introduction to Data Definition Language
- Categorize the main database objects
- Explain the table structure
- Describe 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
 

The Oracle 1Z0-061 Certification Program certifies candidates on skills and knowledge related to Oracle Database products and technologies. The Oracle Database 12c Administrator Certified Associate is granted based on a combination of passing exams, training and performance-based assignments, depending on the level of certification. Oracle 1Z0-061 certification is tangible benchmark of experience and expertise that help you stand out in a crowd among employers. To ensure success, Oracle recommends combining education courses, practice exam and hands-on experience to prepare for your Oracle Database 12c - SQL Fundamentals certification exam as questions will test your ability to apply the knowledge you have gained in hands-on practice or professional experience.