Sybase Developer Assessment

  • $10.00


Sybase is a popular relational database management system used by a wide variety of businesses. Typically, a Sybase developer is less concerned with the creation and maintenance of the database (e.g. building the database or backups), as this is the domain of the Database Administrator, and more interested in the actual manipulation and retrieval of the data in the database. Often times this will be via a third party tool or programming language, but many developers will work exclusively with the database. The focus of this exam is on the ability of the developer to manipulate data stored within the database, their familiarity with the Sybase environment and their knowledge of the tools that are provided with Sybase. This assessment is designed to validate the knowledge of a Sybase Developer rather than a Sybase Administrator.

Assessments for Sybase 11, Sybase 12 and Sybase DBA are also available.

Number of questions 66
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Database Terms and Concepts
Performance and Troubleshooting
Stored Procedures, Triggers, and Cursors
System Stored Procedures
System Tables, System Databases, and Database Utilities
Tables, Views and Indexes
Transact SQL
Tasks tested Accessing Data
Adding New Columns To An Existing Table
Control Of Flow Language
Correct Usage Of An Identity Column
Creating New Triggers
Deleting Records
Determining When To Use Stored Procedures
Determining When To Use Triggers
Enforcing Uniqueness
Expressions
Fine Tuning Queries
Flow Of Control
Joining Tables
Managing Transactions
Nesting Of Triggers
Returning Values From Within A Stored Procedure
Reviewing The Database Environment To Maximize Query Performance
Setting Default Values
Transact SQL Functions - Aggregate Functions
Transact SQL Functions - Convert Function
Transact SQL Functions - String Functions
Transaction Management
Using BCP
Using Cursors
Using DEFNCOPY
Using Global Variables
Using Indexes Correctly To Maximize Performance
Using Indexes Effectively
Using Sub Queries To Retrieve Data
Using System Objects To Obtain Information About Other Database Objects.
Using System Objects To Obtain Information About The Database Environment.
Using System Stored Procedures To Correct Error Situations
Using System Stored Procedures To Diagnose Performance Problems
Using System Stored Procedures To Diagnose Problems
Using System Stored Procedures To Obtain Information About Database Objects
Using The GROUP BY Clause To Restrict Data Returned
Using The INSERT Statement To Manipulate Data
Using The ORDER BY Clause To Sort Data
Using The SELECT Statement To Retrieve Data
Using The System Databases
Using The UPDATE Statement To Manipulate Data
Using The WHERE Clause To Restrict Data Returned
Using Views To Manage Data
Wildcards
Working With Existing Triggers
Writing Stored Procedures
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)