Page 287 - aREA ix eXHIBITS

RANGE OF VARIABLES:

VARIABLE RANGE
1. Data restriction and • Write queries with a WHERE clause to limit the output
Sorting retrieved
• Use the comparison operators and logical operators
• Identify the rules of precedence for comparison and
logical operators
• Usage of character string literals in the WHERE clause
• Write queries with an ORDER BY clause
• Sort output in descending and ascending order
2. Conversion Functions • Describe implicit and explicit data type conversion
and Conditional • Describe TO_CHAR, TO_NUMBER, and TO_DATE
Expressions conversion functions
• Nesting multiple functions
• Apply the NVL, NULLIF, and COALESCE functions to
data
• Use conditional IF THEN ELSE logic
3. DDL Statements to • Categorize Database Objects
Create and Manage • Create Tables using the CREATE TABLE Statement
Tables • Identify the data types
• Describe Constraints
• Create a table using a subquery
• How to alter a table?
• Drop a table
4. Schema Objects • Add, Modify, and Drop a Column
• Add, Drop, and Defer a Constraint
• Enable and Disable a Constraint
• Create and Remove Indexes
• Create a Function-Based Index
• Perform Flashback Operations
• Create an External Table by Using ORACLE_LOADER
and by Using ORACLE_DATAPUMP
• Query External Tables

5. Objects with Data • USER_OBJECTS and ALL_OBJECTS Views
Dictionary Views • View Table and Column Information
• Query the dictionary views for constraint information
• Query the dictionary views for view, sequence, index and
synonym information
• Add a comment to a table
• Query the dictionary views for comment information

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