Oracle 1Z0-882

Free Questions in OTE format

About Oracle 1Z0-882 dump

MySQL Architecture

• Use MySQL client programs to interface with the MySQL Server interactively and in batch
  
• Describe SQL Modes and their impact on behavior of MySQL
  
• Identify characteristics which have session scope
  

General MySQL Syntax

• Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words
  
• Identify MySQL data type properties and appropriate usage
  
• Recognize and use common functions and expressions for all MySQL data types
  
• Identify and use comment syntax
  
• Describe and utilize prepared statements
  
• Describe transactions and transaction isolation levels and the impact they have on database behavior
  

Creation and Design of MySQL Schema Objects

• Design and create normalized databases
  
• Create and modify tables using appropriate data types and indexing
  
• Describe and create table constraints enforcing data integrity
  
• Creating and modifying views
  
• dentify and use various methods to obtain metadata for MySQL database objects
  

Creation, Design and Use of MySQL Stored Programs

• Describe and use triggers
  
• Create and execute stored procedures
  
• Create and use stored functions
  
• Implement error handling within stored procedures
  

Querying for Data

• Execute a basic SELECT statement
  
• Limit rows returned by a SELECT statement
  
• Limit columns returned by a SELECT statement
  
• Apply sorting to SELECT statement results
  
• Execute SELECT statements which aggregate and group data
  

Modifying Data

• Describe and execute INSERT statements
  
• Describe and execute REPLACE statements
  
• Describe and execute UPDATE statements
  
• Describe and execute TRUNCATE statements
  
• Describe and execute LOAD DATA statements
  
• Describe and execute DELETE statements
  

Joins, subqueries and UNION

• Identify, describe and use JOINs in MySQL commands
  
• Describe and utilize subqueries in MySQL commands
  
• Perform operations using UNION clause
  

MySQL Application Development

• Identify key characteristics, features and options for PHP, Java and .NET development using MySQL standard drivers
  
• Write a basic Java application that uses MySQL
  
• Write a basic PHP application that uses MySQL
  
• Write a basic .NET application that uses MySQL
  
• Interpret MySQL error messages
  
• Collect available diagnostic information
  
• Describe and use NoSQL and memcached API
  

Basic Optimizations

• Identify statements requiring optimization
  
• Recognize and create optimal indexes for query optimization
  
• Recognize and fix sub-optimal SQL commands
  
• Identify appropriate optimization strategies for InnoDB usage
  
• Optimize performance through data normalization