Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar

Search for    in all of
view all search results right arrow

Support > Education Services > Certification & Assessment > Adaptive Server Enterprise > SQL Dev Professional (15.0)

Education_cert_logo_2008.jpg Adaptive Server Enterprise 15.0 SQL Developer Professional Certification

Why get certified? Assess, Acquire and Achieve...



Certification Exam Title: Sybase Certified Adaptive Server Developer Professional Exam (Version 15.0)
Passing Grade: 70%
Number of Multiple Choice Questions: 60
Exam Number: 510-026
Exam Duration: 90 Minutes

Education orange_arrow.gif Visit our Online Certification Practice Exams




Education orange_arrow.gif QUESTION: How can I register for the exam?

ANSWER: Please visit the SAP Certification website for details about SAP Education's certification programs, benefits and offerings.

Education orange_arrow.gif QUESTION: How do I prepare for this exams?

ANSWER: It is recommended you work with Adaptive Server Enterprise 15.0* for at least 6 months before taking the exam. If you have taken a corresponding course, it is suggested you review all of the content, especially topics that you have yet to master.

*This exam is based on the Adaptive Server Enterprise 15.0 GA version. Any functionality that is new or changed in later releases are not included in this exam.

We also recommend preparing by:

Spending a minimum of 40 hours thoroughly covering all topics listed in the exam study guide

Taking the following recommended courses:

  • Powering Up with ASE 15.0 (EDB366)
  • Fast Track to Adaptive Server Enterprise (EDB116)
  • Performance and Tuning: Adaptive Server Enterprise Query Optimizer (EDB634)
  • Mastering Transact-SQL Programming: Advanced Tips & Techniques (EDB559)
  • Logical Database Design (SYB144)
  • Physical Database Design (EDB110)

Education orange_arrow.gif QUESTION: What is the format of this exam?

ANSWER: Each candidate will have one hour and thirty minutes to complete the exam which consists of 60 multiple-choice questions. The passing grade is 70% (42 questions answered correctly).

Education orange_arrow.gif QUESTION: What are some suggestions for when I take this exam?

ANSWER: Space your time accordingly and do not spend too much time on each question. When answering a question, you'll have the opportunity to mark an answer "for review". Keep this in mind, as it will allow you to revisit your marked questions later, before finally submitting your exam.



Section 1 - What's New in ASE 15 (9 questions - 15%)

  • Describe local/global indexes on partitioned tables
  • Identify aspects of insensitive/semi-sensitive scrollable cursors
  • Describe metrics capture
  • Identify and define new commands for getting optimizer information
  • Describe ASE 15.0 optimization goals and their impact on query plans
  • Describe the various join types (hash joins, merge joins, NLJ, N-ary NLJ)

Section 2 - ASE Performance and Tuning Basics (2 questions - 4%)

  • Define tradeoffs of performance & tuning - with an emphasis on code
  • Identify steps involved in executing a query
  • List what query plan information can be viewed
Section 3 - Logical and Physical Design (2 questions - 4%)
  • Define Entities, Relationships (subtype-supertype) & Attribute cardinality
  • List denormalization techniques
  • Assess a relational data model
  • List advantages of normalization
  • Create Associative Tables
  • Identify qualities for Primary Key
  • Represent relationships as Foreign keys
  • Determine column data type and null/not null status, default values, rules & constraints
  • Determine decisions to change primary key
  • Enforce domain integrity
  • Measure the cost of data access via clustered and non-clustered index
  • Define derived tables, intra-row derived columns and inter-row derived columns
  • Understand First, Second and Third Normal Form
Section 4 - ANSI SQL – DDL (5 questions – 8 %)
  • Describe how to create tables, views, indexes, etc.
  • Define system and user-defined datatypes
  • Define column properties such as null and identity
  • Define temporary tables
  • Describe ASE data types
  • Describe different partitioning strategies
  • Understand the use of create table and create index commands
  • Understand partitioning options with alter table

Section 5 - ANSI SQL - DML (5 questions – 8 %)

  • Describe the data manipulation commands: select, insert, update, and delete, and the use of cursors
  • Identify important clauses of DML statements, such as where, having, order by, etc.
  • Identify the performance and tuning aspects of DML statements, such as direct and deferred updates, etc.
  • Understand computed columns
  • Identify techniques to promote the most efficient update method

Section 6 - Query Access Methods (5 questions – 8 %)

  • Define table scans versus clustered and nonclustered index scans
  • Define range queries, point queries, and covered queries
  • Explain how ASE accesses data in selects, inserts, deletes, and updates
  • Identify factors affecting page usage
  • Define I/O for a select using a non-clustered index
  • Define performance benefits of using indexes
  • Identify possibilities of how 'select' finds data
  • Define bulk copy and BCP commands
  • Define logging & minimally-logged operations

Section 7 - Query Optimization (9 questions – 15 %)

  • Define the 'Or Strategy' and showplan, plus options
  • Identify optimization 'set' command tools
  • Use of Abstract Plans
  • Determine if the optimizer selected serial or parallel access
  • Define Procedure Cache & explain how stored procedures are processed
  • Identify factors for setting Prefetch at the Query-Level
  • Identify Query Degradation
  • Identify tasks for which internal working tables are created in tempdb or in memory
  • Design queries to take maximum advantage of optimizer features
  • Describe how the optimizer analyzes search arguments (SARG)
  • Identify guidelines to minimize join related performance problems
  • Identify factors of Subquery Optimization

Section 8 - Stored Procedures and Triggers (4 questions – 6 %)

  • Write and tune stored procedures and triggers
  • Identify steps to ensure only optimal query plans in cache
  • Describe the passing of parameters
  • Define query plans and the procedure cache
  • Define triggers and their usage
  • Contrast use of variables versus parameters in stored procedures

Section 9 - Transact-SQL Statements (5 questions – 8 %)

  • Use of Sybase-specific Transact-SQL commands, such as functions, programming commands such as if and while, local and global variables
  • Describe 'scrollable cursors'
  • Identify guidelines for SARGs
  • Define Table pivoting

Section 10 - Data Integrity and Constraints (2 questions – 4 %)

  • Identify and define both the ANSI-standard constraints, such as check constraints and primary key constraints
  • Describe traditional Sybase data integrity mechanisms such as rules and defaults

Section 11 - Transaction Management and Locking (5 questions – 8 %)

  • Describe the behavior of transactions and the behavior of locks
  • Define transaction management commands
  • Describe transaction logging, lock blocking, diagnosis and resolution of deadlocks
  • Describe the effect of transaction isolation levels
  • Define methods for reducing lock contention
  • Classify features of variable assignment
  • Describe how ASE resolves a deadlock

Section 12 - Joins, Subqueries, and Unions (4 questions – 6 %)

  • Define the different types of joins
  • Describe the union and union all command
  • Describe subqueries
  • Describe join costing and subquery optimization

Section 13 - Optimizer Statistics (3 questions – 6 %)

  • Describe table-level and distribution statistics
  • Define the different types of statistics, such as cluster ratios, density values, and histograms
  • Describe simulated statistics


Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics
© Copyright 2014, Sybase Inc. - v 7.6