InterSystems ObjectScript Specialist

SECTION/SKILLS

ABILITIES

1. Identifies use cases for persistent and registered object classes
2. Creates and saves a persistent object
3. Deletes objects
4. Interprets storage definitions
5. Implements multiple inheritance
6. Documents classes

1. Sets max length for string properties
2. Uses stream properties for large data sets
3. Creates properties that calculate values dynamically or are auto-updated (e.g., a timestamp for last updated)
4. Creates and validates class member parameters and attributes
5. Selects appropriate index type based on data distribution
6. Uses unique index methods
7. Recalls how foreign keys enforce referential integrity

1. Differentiates between instance and class methods
2. Uses class parameters inside methods
3. Specifies method arguments and return type
4. Passes objects to methods
5. Passes variables by reference
6. Passes multidimensional variables by reference
7. Uses and overrides inherited methods
8. Determines when to use ##super for calling superclass methods

1. Creates dynamic objects/arrays (JSON) 
2. Uses stream objects of the appropriate type

1. Manages transactions
2. Manages rollbacks
3. Describes how LOCKs enforce concurrency
4. Describes lock escalation threshold and effect on row locks versus table locks
5. Differentiates between pessimistic and optimistic concurrency controls
6. Uses transactions and applies concurrency controls in SQL scripts

1. Locates and accesses applicationglobals
2. Uses logging to track application data
3. Adds and tracks metrics for performance monitoring

1. Ensures appropriate variable and global use to avoid security leaks
2. Checks roles for permission control
3. Prevents SQL injection attacks
4. Implements embedded SQL permission checks

1. Differentiates between PPGs, variables, temporary globals, andglobals
   

1. Identifies ObjectScript as a weakly typed language and contrasts its usage with strongly typed languages
2. Uses system macros and include files
3. Describes how object structures are projected to SQL tables
4. Differentiates between Embedded and Dynamic SQL
5. Differentiates between runtime and select modes, and enforces the correct mode
6. Uses SQL variables such as ROWID and SQLCODE

1. Manages $C(0) in SQL and ObjectScript

1. Adds indexes to existing properties
2. Describes the impact of changing the name and datatype of a property with existing data
3. Describes consequences of purging cached queries after schema changes

1. Uses TUNE TABLE to optimize performance
2. Interprets basic query plans
3. Tests code correctness and performance in non-functional tests

1. Describes how subscripts are sorted within an array
2. Traverses subset of a subscript using $ORDER
3. Traverse multi-level variables using $ORDER
4. Checks the existence of array nodes with $DATA

1. Uses $LIST to insert/update/delete elements in a list
2. Retrieves and iterates through elements in a list using $LISTGET and $LISTNEXT
3. Converts between lists and strings