Skills required for Oracle test 1Z0-047

Skills required for Oracle test 1Z0-047

Rating:

Oracle has specified seventy-eight objectives under nineteen topics for Oracle test 1Z0-047 (Oracle 11i Database SQL Expert). Before taking the test, an individual should possess a good command over the following areas:

1. Creating schema objects, and listing and using the SELECT statement with its various functions.
2. Using SQL and iSQL*Plus statements and commands.
3. Using conversion functions.
4. Using the GROUP function with its various available clauses.
5. Using equi and non-equi-joins.
6. Generating Cartesian products from n number of tables.
7. Using various clauses and operators in Oracle.
8. Using sub queries.
9. Creating a table and constraints at the time of table creation.
10. Using multi-table INSERTS.
11. Merging rows and tracking the changes to data over a period of time in a table.
12. Using the data dictionary views to research data on your objects and querying various data dictionary views.
13. Performing FLASHBACK operations.
14. Differentiating system privileges from object privileges and privileges from roles.
15. Granting privileges and roles on a table.
16. Viewing privileges in the data dictionary.
17. Using the ROLLUP operation to produce subtotal values.
18. Using the CUBE operation to produce cross tabulation values.
19. Using the GROUPING function to identify the row values created by ROLLUP or CUBE.
20. Using the GROUPING SETS to produce a single result set.
21. Using a hierarchical query and formatting the hierarchical data.
22. Creating a tree-structured report and excluding branches from the tree structure.
23. Using regular expressions and its functions, including check constraints.
24. Using meta characters and replacing patterns.

Rating: