Elements and Performance Criteria

The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.

Components may include:
memory structure
relational database management system (RDBMS) software
stored procedures
table structure.
Database may include:
MS Access
MySQL
Oracle
structured query language (SQL) server.
Tools may include:
MySQL Workbench
Oracle Enterprise Manager Database Control
phpMyAdmin
SQL Server Management Studio.
Data-management tasks may include:
implement data compressions
import and export data
maintain indexes
manage collations
manage data partitions.
Permissions may include:
implied
object
statement.
Roles may include:
application
database:
fixed
public
defined
server, such as fixed-server roles.
Backups may include:
compressed
differential
file
full database
online and offline database
transaction log.
Recovery may include:
bulk-logged
full
simple.
Optimisation may include:
cache mechanism
data compression
indexing.

The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.

Overview of assessment

Critical aspects for assessment and evidence required to demonstrate competency in this unit
Evidence of the ability to:
install and configure database software
manage database files, integrity, users and security
create backup and restore databases
monitor database performance.
Context of and specific resources for assessment
Assessment must ensure access to:
database-management system software
database instance
tools in administering database
specific requirements, including client and functionality requirements
policy and naming standard
appropriate learning and assessment support when required
modified equipment for people with special needs.
Method of assessment
A range of assessment methods should be used to assess practical skills and knowledge. The following examples are appropriate for this unit:
direct observation of candidate performing:
the installation, configuration and troubleshooting of a database management system software
database tuning for performance using appropriate techniques and tools
database backup creation and restore using the backup file
data-management tasks, such as importing and exporting data, and instance creation
database security tasks, such as creating users, and assigning roles and permissions to database users
verbal or written questioning to determine candidate’s knowledge of database tuning and database security
review of candidate’s database documentation.
Guidance information for assessment
Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, where appropriate.
Assessment processes and techniques must be culturally appropriate, and suitable to the communication skill level, language, literacy and numeracy capacity of the candidate and the work being performed.
Indigenous people and other people from a non-English speaking background may need additional support.
In cases where practical assessment is used it should be combined with targeted questioning to assess required knowledge.