1Z0-047 Oracle Database SQL Expert

Retrieving Data Using the SQL SELECT Statement [  ] List the capabilities of SQL SELECT statements [  ] Execute a basic SELECT statement [  ] Describe how schema objects work Restricting and Sorting Data [  ] Limit the rows that are retrieved by a query [  ] Sort the rows that are retrieved by a query Using Single-Row Functions to Customize Output [  ] Describe various types of functions that are available in SQL [  ] Use character, number, and date functions in SELECT statements [  ] Describe the use of conversion functions Reporting Aggregated Data Using the Group Functions [  ] Identify the available group functions [  ] Describe the use of group functions [  ] Group data by using the GROUP BY clause [  ] Include or exclude grouped rows by using the HAVING clause Displaying Data from Multiple Tables [  ] Write SELECT statements to access data from more than one table using equijoins and nonequijoins [  ] Join a table to itself by using a self-join [  ] View data that generally does not meet a join condition by using outer joins [  ] Generate a Cartesian product of all rows from two or more tables Using Subqueries to Solve Queries [  ] Define subqueries [  ] Describe the types of problems that subqueries can solve [  ] List the types of subqueries [  ] Write single-row and multiple-row subqueries

Using the Set Operators [  ] Describe set operators [  ] Use a set operator to combine multiple a single query [  ] Control the order of rows returned Manipulating Data [  ] Describe each data manipulation language (DML) statement [  ] Insert rows into a table [  ] Update rows in a table [  ] Delete rows from a table [  ] Control transactions Using DDL Statements to Create and Manage Tables [  ] Categorize the main database objects [  ] Review the table structure [  ] List the data types that are available for columns [  ] Create a simple table [  ] Explain how constraints are created at the time of table creation Creating Other Schema Objects [  ] Create simple and complex views [  ] Retrieve data from views [  ] Create, maintain, and use sequences [  ] Create and maintain indexes [  ] Create private and public synonyms Managing Objects with Data Dictionary Views [  ] Use the data dictionary views to research data on your objects [  ] Query various data dictionary views Controlling User Access [  ] Differentiate system privileges from object privileges [  ] Grant privileges on tables [  ] View privileges in the data dictionary [  ] Grant roles [  ] Distinguish between privileges and roles Managing Schema Objects [  ] Add constraints [  ] Create indexes [  ] Create indexes using the CREATE TABLE statement [  ] Creating function-based indexes [  ] Drop columns and set column UNUSED [  ] Perform. FLASHBACK operations [  ] Create and use external tables

Manipulating Large Data Sets [  ] Manipulate data using subqueries [  ] Describe the features of multitable INSERTs [  ] Use the following types of multitable INSERTs (Unconditional, Conditional and Pivot) [  ] Merge rows in a table [  ] Track the changes to data over a period of time Generating Reports by Grouping Related Data [  ] Use the ROLLUP operation to produce subtotal values [  ] Use the CUBE operation to produce crosstabulation values [  ] Use the GROUPING function to identify the row values created by ROLLUP or CUBE [  ] Use GROUPING SETS to produce a single result set Managing Data in Different Time Zones [  ] Use Various datetime functions Retrieving Data Using Subqueries [  ] Write a multiple-column subquery [  ] Use scalar subqueries in SQL [  ] Solve problems with correlated subqueries [  ] Update and delete rows using correlated subqueries [  ] Use the EXISTS and NOT EXISTS operators [  ] Use the WITH clause Hierarchical Retrieval [  ] Interpret the concept of a hierarchical query [  ] Create a tree-structured report [  ] Format hierarchical data [  ] Exclude branches from the tree structure Regular Expression Support [  ] Using Meta. Characters [  ] Regular Expression Functions [  ] Replacing Patterns [  ] Regular Expressions and Check Constraints

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/165278/viewspace-462985/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/165278/viewspace-462985/