ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

MS SQL Server 7 Administration Test

Our MS SQL Server 7 Administration test measures your knowledge of administering Structured Query Language Server 7 databases. Designed for experienced administrators, this test covers the following topics: Architecture, Automating Tasks, Backup and Restore, Databases, Indexes, Installation, Locking, Multiple Server Environment, Performance, Security, and Transact-SQL.



Scope of the Online MS SQL Server 7 Administration Test

Architecture
Automated Tasks (Alerts)
Automated Tasks (Jobs)
Automated Tasks (Operators)
Concepts
Design Concepts
Services
System Databases
Backup and Restore
Backup
Concepts
Restore
Databases
Concepts (Tables/Triggers/Stored Procedures)
Definition
Managing
Indexes
Concepts
Design
Types
Installation
Implementing
Planning
Storage Structures
Upgrading
Locking
Concepts
Isolation Levels
Lock Types
Multiple Server Environment
Agents
BCP Concepts
External Data
Linked Servers
Replication Models and Methods
Troubleshooting
Performance
Concepts
Contention
Monitoring
Tools
Tuning
Security
Permissions
Security Administration
Users and Roles
Transact-SQL
Concepts
Extensions
Queries
Temp Tables

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, Windows System Administrator

Keywords

sql server 7 administration test, clickatest sql server 7 administration test, sql server 7 administration skill assessment test, information technology, computers, IT industry