Código: 1Z0-061
Código: 1Z0-061
| Prova | Oracle Database 12c: SQL Fundamentals |
| Preço | US$ 125.00 |
| Duração | 120 minutos |
| Número de questões/Formato | 70/Múltipla escolha |
| Nota de aprovação | 65% |
| Treinamento oficial recomendado | Oracle Database: Introduction to SQL Oracle Database: SQL Workshop I Oracle Database: SQL and PL/SQL Fundamentals |
Importante: esta prova pode ser feita ONLINE
Tópicos do exame
Tópicos do exame
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