1Z0-061: Oracle Database 12c - SQL Fundamentals


Exam Number: 1Z0-061

Exam Title: Oracle Database 12c - SQL Fundamentals


Associated Certification Paths



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 $125
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 Practice 1Z0-061 Online Practice Exam
Recommended Training Oracle Database: Introduction to SQL
Oracle Database: SQL Workshop I
Oracle Database: SQL and PL/SQL Fundamentals

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: