Test Exam 1Z0-071 – Oracle Database SQL

Descrição





Descrição:

Test Exam Simulator – 1Z0-071 – Oracle Database SQL

Review exam topics

Relational Database concepts

  • Explaining the theoretical and physical aspects of a relational database

  • Relating clauses in SQL Select Statement to Components of an ERD

  • Explaining the relationship between a database and SQL

Retrieving Data using the SQL SELECT Statement

  • Using Column aliases

  • Using The SQL SELECT statement

  • Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

  • Using Arithmetic expressions and NULL values in the SELECT statement

Restricting and Sorting Data

  • Applying Rules of precedence for operators in an expression

  • Limiting Rows Returned in a SQL Statement

  • Using Substitution Variables

  • Using the DEFINE and VERIFY commands

  • Sorting Data

Using Single-Row Functions to Customize Output

  • Manipulating strings with character functions in SQL SELECT and WHERE clauses

  • Performing arithmetic with date data

  • Manipulating numbers with the ROUND, TRUNC and MOD functions

  • Manipulating dates with the date function

Using Conversion Functions and Conditional Expressions

  • Applying the NVL, NULLIF, and COALESCE functions to data

  • Understanding implicit and explicit data type conversion

  • Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

  • Nesting multiple functions

Reporting Aggregated Data Using Group Functions

  • Restricting Group Results

  • Creating Groups of Data

  • Using Group Functions

Displaying Data from Multiple Tables

  • Using Self-joins

  • Using Various Types of Joins

  • Using Non equijoins

  • Using OUTER joins

  • Understanding and Using Cartesian Products

Using Subqueries to Solve Queries

  • Using Single Row Subqueries

  • Using Multiple Row Subqueries

  • Update and delete rows using correlated subqueries

Using SET Operators

  • Matching the SELECT statements

  • Using the ORDER BY clause in set operations

  • Using The INTERSECT operator

  • Using The MINUS operator

  • Using The UNION and UNION ALL operators

Managing Tables using DML statements

  • Managing Database Transactions

  • Controlling transactions

  • Perform Insert, Update and Delete operations

  • Performing multi table Inserts

  • Performing Merge statements

Managing Indexes Synonyms and Sequences

  • Managing Indexes

  • Managing Synonyms

  • Managing Sequences

Use DDL to manage tables and their relationships

  • Describing and Working with Tables

  • Describing and Working with Columns and Data Types

  • Creating tables

  • Dropping columns and setting column UNUSED

  • Truncating tables

  • Creating and using Temporary Tables

  • Creating and using external tables

  • Managing Constraints

Managing Views

  • Managing Views

Controlling User Access

  • Differentiating system privileges from object privileges

  • Granting privileges on tables

  • Distinguishing between granting privileges and roles

Managing Objects with Data Dictionary Views

  • Using data dictionary views

Managing Data in Different Time Zones

  • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP

  • Working with INTERVAL data types





Avaliações

Ainda não existem avaliações.

Seja o primeiro a avaliar “Test Exam 1Z0-071 – Oracle Database SQL”

O seu endereço de email não será publicado. Campos obrigatórios marcados com *