| トピック | 出題範囲 |
|---|
| トピック 1 | - Managing Indexes Synonyms and Sequences: In this domain, topics include managing Indexes, managing Synonyms, and managing Sequences.
|
| トピック 2 | - Using Conversion Functions and Conditional Expressions: In this domain, the topics covered are how to apply the NVL, NULLIF, and COALESCE functions to data, how to understand the implicit and explicit data type conversion, utilize the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions, and nesting multiple functions.
|
| トピック 3 | - Displaying Data from Multiple Tables: In this domain, topics include how to use Self-joins, use different types of Joins, how to utilize Nonequijoins, and OUTER joins.
|
| トピック 4 | - Granting privileges on tables and distinguishing between giving privileges and roles.
|
| トピック 5 | - Controlling User Access: In this module, the topics include differentiating system privileges from object privileges
|
| トピック 6 | - Managing Indexes Synonyms and Sequences: In this domain, exam-takers are tested for their skill in managing Indexes, Synonyms, and Sequences.
|
| トピック 7 | - Restricting and Sorting Data: This domain covers topics such as applying Rules of precedence for operators in an expression, limiting Rows Returned in a SQL Statement, and utilizing Substitution Variables.
|
| トピック 8 | - Reporting Aggregated Data Using Group Functions: In this section of the exam, it is covered how to restrict Group Results and create Groups of Data.
|
| トピック 9 | - Managing Views: This domain covers how to manage or oversee modules.
|
| トピック 10 | - Managing Tables using DML statements: In this exam domain, topics covered include managing Database transactions, controlling them, perform Insert, Update, and Delete operations. It also covers how to perform multi-table Inserts and Merge statements.
|