Exam Number: 1Z0-061
Exam Title: Oracle Database 12c - SQL Fundamentals
Associated Certification Paths
Oracle 1Z0-061 Certification Details:
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
|
Oracle 1Z0-061 - Oracle Database 12c: SQL Fundamentals Exam Preparation: