OpenExamsFREE PRACTICE — ANY EXAM

MySQL 8.0 Database Developer — Information & Free Practice

US · Examination information

100 free questions · Answer explanations · No signup required

Start free practice →

MySQL 8.0 Database Developer

Provider
Oracle University
Format
Proctored Online; Multiple Choice
Exam questions
Total questions: 65.
Time limit
90 Minutes
Passing score
62%
Examination outline
  • Connectors and APIs
    • Choose between connectors for a given application
    • Demonstrate connector use, management and configuration
    • Retrieve data from the database by using a connector
    • Handle special values
    • Secure credentials and connections
  • Data-driven Applications
    • Use prepared statements
    • Set SQL Modes to change MySQL behavior
    • Handle and interpret errors and warnings
    • Display query results
    • Aggregate and summarize data
    • Advanced Report Generation
  • MySQL Schema Objects and Data
    • Design, create, and alter views
    • Store and process string data
    • Store and process numeric data
    • Store and process temporal data
    • Store and process spatial data
  • Transactions
    • Control transactions in SQL
    • Control transactions in applications
    • Resolve consistency problems with isolation levels
    • Understand locking mechanisms within MySQL
  • Query Optimization
    • Use indexes for optimization
    • Analyze queries for optimization
    • Rewrite queries for optimization
  • MySQL Stored Programs
    • Create and execute stored routines
    • Explain the programming constructs used in stored routines
    • Create and execute triggers
    • Schedule database operations
  • JSON and Document Store
    • Create and store JSON documents
    • Process data in JSON documents
    • Explain application development with NoSQL and XDevAPI
    • Create and access a document store
    • Use MySQL Shell to access document stores
Examination sources

Related license preparation

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