Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

Sybase 12.5 Administration

Description:

Our Sybase 12.5 Administration test measures your knowledge of administering Sybase 12.5. Designed for experienced administrators, this test covers the following topics: ASE Server Management, Backups and Recovery, Database and Object Access Mgmt, Database Consistency Checking, Database Management, Database Objects Management, Performance and Tuning, Server and Client Configuration, and Server Resources Access.

This test is associated with a Job Role. Please visit the Job Role Center for more details.

$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline


ASE Server Management
ASE and Backup Server
Auditing
Error Log and ASE Processing Monitoring
Locks
Suspending and Resuming Database Updates
Backups and Recovery
Backup Strategies
Dump, Load, and Online Commands
High Availability
System and User Databases Recovery
Transaction Log
Database and Object Access Mgmt
Database Users, Groups, Permissions, Aliases
Locking Schemes
Row-level Access Control (RLAC)
Database Consistency Checking
Allocation Errors
Databases and Tables
dbccdb Database
Page and Object Allocation Map (OAM)
Database Management
Creating, Expanding, and Dropping Databases
Database Devices
Database Options
Device, db, Segment Freespace and Thresholds
Segments and Tempdb
Tables and Indexes Capacity Planning
Tempdb and Tempdb Sizing
Transaction Log Separation
Database Objects Management
Data Loading with External Files (bcp)
DOL Tables with Optdiag and Reorg
Performance Indexes
Table Partitioning
Performance and Tuning
Network Performance
Query Optimizer
sp_sysmon
Statistics
Server and Client Configuration
Character Set, Sort Order, and Language Selection
Client Configuration
Configuration Options
Dynamically Allocating Memory
Multiple Engines
Named Caches and Partitions, Memory Bufferpools
User Connection Priorities
Server Resources Access
Division of System Roles
Remote Servers Access
Server Logins