Description
Expected 1Z0-909 Exam Topics, as suggested by Oracle :
- Module 1: Demonstrate connector use, management and configuration/ Secure credentials and connections
- Module 2: Explain application development with NoSQL and XDevAPI/ Handle and interpret errors and warnings
- Module 3: Explain the programming constructs used in stored routines/ Choose between connectors for a given application
- Module 4: Resolve consistency problems with isolation levels/ Set SQL Modes to change MySQL behavior
- Module 5: Use MySQL Shell to access document stores/ Retrieve data from the database by using a connector
- Module 6: Understand locking mechanisms within MySQL/ Control transactions in applications
- Module 7: Create and execute stored routines/ MySQL Schema Objects and Data
- Module 8: Rewrite queries for optimization/ Store and process string data
- Module 9: Analyze queries for optimization/ Aggregate and summarize data/ Data-driven Applications
- Module 10: Create and access a document store/ JSON and Document Store/ Store and process numeric data
- Module 11: Store and process spatial data/ Design, create, and alter views
- Module 12: Schedule database operations/ Store and process temporal data
ariana –
Passing the MySQL 8.0 exam was a great feeling, and the practice questions from examtopics pro were a huge help. There was a tricky question about the differences between implicit and explicit transactions. I wasn’t entirely sure, but I still passed.