文件名称：OCP 051 考试认证
文件大小：811KB
文件格式：PDF
更新时间：2017-07-16 16:00:56
OCP 051
Apply general functions and conditional expressions in a SELECT statement Control the order of rows returned Create a simple table Create simple and complex views Create, maintain, and use sequences Describe how schema objects work Describe various types of conversion functions that are available in SQL Describe various types of functions available in SQL Execute a basic SELECT statement Group data by using the GROUP BY clause Include or exclude grouped rows by using the HAVING clause List the types of subqueries Sort the rows that are retrieved by a query Update rows in a table Use a set operator to combine multiple queries into a single query Use character, number, and date functions in SELECT statements Write SELECT statements to access data from more than one table using equijoins and nonequijoins Write single-row and multiple-row subqueries