Oracle 1Z0-061

Free Questions in OTE format

About Oracle 1Z0-061 dump

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