ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

Sybase 12.5 Administration Test

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.



Scope of the Online Sybase 12.5 Administration Test

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

Duration

40 minutes.

Assessment Method of Questions

Multiple choice questions

Each question has between 2 and 8 options out of which 1 or more may be correct.

More links

Related Professions

Database Administrator

Keywords

sybase 12.5 administration assessment test, clickatest sybase 12.5 administration assessment test, sybase 12.5 administration test, information technology, computers, IT industry