OpenExamsFREE PRACTICE — ANY EXAM

Oracle Database SQL — Information & Free Practice

US · Examination information

100 free questions · Answer explanations · No signup required

Start free practice →

Oracle Database SQL

Provider
Oracle University
Format
Proctored Online; Multiple Choice
Exam questions
Total questions: 63.
Time limit
120 Minutes
Passing score
63%
Examination outline
  • 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
  • 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
Examination sources

Related license preparation

This examination may be required or accepted as an alternative, depending on the license and application pathway.