| トピック | 出題範囲 |
|---|
| トピック 1 | - Managing Objects with Data Dictionary Views: This domain covers utilizing data dictionary views.
|
| トピック 2 | - Managing Indexes Synonyms and Sequences: In this domain, exam-takers are tested for their skill in managing Indexes, Synonyms, and Sequences.
|
| トピック 3 | - sing Single-Row Functions to Customize Output: This particular domain of the exam covers topics such as manipulating strings with character functions in SQL SELECT and WHERE clauses, performing arithmetic with date data, and manipulating numbers with the ROUND, TRUNC, and MOD functions. It also covers manipulating dates with the date function.
|
| トピック 4 | - Managing Indexes Synonyms and Sequences: In this domain, topics include managing Indexes, managing Synonyms, and managing Sequences.
|
| トピック 5 | - Retrieving Data using the SQL SELECT Statement: This domain comprises topics such as using Column aliases, the SQL SELECT statement, utilizing the concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword.
|
| トピック 6 | - Controlling User Access: In this module, the topics include differentiating system privileges from object privileges
|
| トピック 7 | - Using Subqueries to Solve Queries: In this module, topics include using Single Row Subqueries, Multiple Row Subqueries, and how to delete and update rows.
|
| トピック 8 | - Managing Views: This domain covers how to manage or oversee modules.
|
| トピック 9 | - 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.
|
| トピック 10 | - 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.
|
| トピック 11 | - 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.
|