Oracle 1z0-071 考試大綱：

主題	簡介
主題 1	Granting privileges on tables and distinguishing between giving privileges and roles.
主題 2	Managing Data in Different Time Zones: In this domain, topics include working with CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP, and working with INTERVAL data types.
主題 3	Using SET Operators: In this domain, the topics covered match the SELECT statements, utilizing the ORDER BY clause in set operations, the INTERSECT operator, and the MINUS operator.
主題 4	Controlling User Access: In this module, the topics include differentiating system privileges from object privileges
主題 5	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.
主題 6	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.
主題 7	Managing Views: This domain covers how to manage or oversee modules.
主題 8	Managing Objects with Data Dictionary Views: This domain covers utilizing data dictionary views.
主題 9	Relational Database concepts: In this domain, the topics covered include explaining the theoretical and physical aspects of a relational database and relating clauses in SQL Select Statement to Components of an ERD.
主題 10	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.
主題 11	Managing Indexes Synonyms and Sequences: In this domain, topics include managing Indexes, managing Synonyms, and managing Sequences.