Page 285 - aREA ix eXHIBITS

3. Display Data From 3.1 SELECT statements to access data from more than one table
Multiple Tables are written in accordance with PL/SQL framework
Using Joins 3.2 Tables Using SQL:1999 Syntax are joined in accordance with
PL/SQL framework
3.3 Data that does not meet a join condition by using outer joins are
viewed in accordance with PL/SQL framework
3.5 Cross Joins are created in accordance with PL/SQL framework
4. Manipulate Data 4.1 New Rows to a Table are added in accordance with PL/SQL
framework
4.2 Data in a Table are changed in accordance with PL/SQL
framework
4.3 DELETE and TRUNCATE Statements are used in accordance
with PL/SQL framework
4.4 COMMIT and ROLLBACK statements are saved in accordance
with PL/SQL framework
4.5 Read Consistency is implemented in accordance with PL/SQL
framework
4.6 FOR UPDATE Clause is described in accordance with PL/SQL
framework
4.7 DDL Statements to Create and Manage Tables are used in
accordance with PL/SQL framework
5. Control User 5.1 System and Object Privileges are identified in accordance with
Access PL/SQL framework
5.2 Users are created in accordance with PL/SQL framework
5.3 System Privileges are granted in accordance with PL/SQL
framework
5.4 Privileges to a Role are created and granted in accordance with
PL/SQL framework
5.5 Object Privileges are granted in accordance with PL/SQL
framework
5.6 Privileges are passed in accordance with PL/SQL framework
5.7 Object Privileges are revoked in accordance with PL/SQL
framework
5.8 Schema Objects are managed in accordance with PL/SQL
framework
5.9 Objects with Data Dictionary Views are managed in
accordance with PL/SQL framework
6. Manipulate Large 6.1 Subqueries to Manipulate Data are used in accordance with
Data Sets PL/SQL framework
6.3 Data Using a Subquery as Source are retrieved in accordance
with PL/SQL framework
6.4 Data Using a Subquery as a Target are inserted in accordance
with PL/SQL framework
6.5 The WITH CHECK OPTION Keyword on DML Statements are
used in accordance with PL/SQL framework
6.6 The types of Multitable INSERT Statements are listed in
accordance with PL/SQL framework
6.7 Multitable INSERT Statements are identified in accordance with
PL/SQL framework

_________________________________________________________________________________ 30
TR – Programming (Oracle Database) NC III Promulgated – December 2013