Sybase 12 Assessment

$16.00

Sybase 12 Assessment

$16.00
description

Sybase is a family of SQL development tools from Sybase, Inc., that includes SQL Server, SQL Toolset (design, development and control) and Client/Services Interfaces (distributed database architecture). The Sybase 12 test is designed to assess developer proficiency with Sybase syntax and programming tools. Tests for Sybase 11, Sybase DBA and Sybase Developer are also available.

 

Number of questions 50
Competencies tested Transact SQL
Backup and Recovery
Database Administration
Indexing
Performance Tuning
Database Design
Security
Tasks tested Using System Procedures
Outer Joining
Using Cursors
Using Functions
Using Built-In Function
Transaction Control
Using Aggregate Functions
Datatype Usage
Control-of-Flow
Using External System Procedures
Pattern Matching
Input Parameters
Striping Backups
Clearing the Transaction Log
Using Triggers
Using Local Variables
Administration
Table Design
Sizing Named Caches
Distributed Computing
Space Allocation
Table Partitioning
Database Options
tempdb Allocation
Disk Device Creation
Memory Management
Using Batches
Using Temporary Tables
Page Allocation Problems
Index Creation
Index Tuning
Network Tuning
Nested Iteration
Tuning tempdb
Memory Utilization
Key Assignment
Data Normalization
Managing Roles
Granting Access