【文件属性】:
文件名称: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