ANSWER: In the USA or Canada, please call Prometric to register by phone 800-792-EXAM or online at: Sybase Certification Exams at Prometric. If you are from a country other than the US or Canada, follow your normal registration procedures through your local exam center or your Prometric Regional Service Center. To find out about registration procedures for your region (select 'Sybase' from the 'Client/Program' drop-down box.)
QUESTION: How do I prepare for this exams?
ANSWER: It is recommended you work with Adaptive Server Anywhere (ASA)* 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 Anywhere 8.0 GA version, which is the first main release of ASA. Any functionality that is new or changed in later 8.0 releases (such as the ASA 8.0.1 interim release and later) are not included in this exam.
C) Practice 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:
IAS182: Adaptive Server Anywhere Fundamentals (2 Days) EDB481: Upgrading to SQL Anywhere Studio 8.0 (3 Days) Review ASA 8.0 Documentation including the " What's New in SQL Anywhere Studio" online guide.
QUESTION: What is the format of the exam?
ANSWER: Each candidate will have one hour and fifteen minutes to complete the exam which consists of 56 multiple-choice questions. The passing grade is 71% (40 questions answered correctly).
QUESTION: Are there any suggestions on how to study for 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.
STUDY GUIDELINES
Sybase Certified Approved Study Guidelines are an excellent way to stay up-to-date on Sybase products and technologies and effectively prepare for Sybase exams. All approved study guidelines are based on the exam's objectives and designed to help you meet them.
Connecting to the Database
Understand the most common connection parameters
Connect to network servers across common networks
Connect to a specific database in a multiple database environment
Specify a connection that automatically starts a database
Specify a connection that automatically starts the personal server and a database
Specify server and database names
Specify common network parameters Common troubleshooting
Creating and Using Databases
Identify and explain the purpose of database files including the main database file (.db), transaction log, temporary files and database spaces.
Discuss any limitations on size, name, etc.
Describe how to create and delete a database
Examine the most common creation options
Explain where system tables are stored and what kind of information they contain
Database Objects
Review basic database design principles
Create, alter, and drop tables, primary keys, foreign keys, and views
Use column defaults
Create database mechanisms that enforce entity and referential integrity
Manipulating Data
Perform basic data manipulation through Sybase Central
Review basic SQL statements
Review the concept of joins
Use DBISQL
Transaction Processing
Define the meaning of a transaction
Explain when transactions begin and end in ASA
Identify the main issues with concurrency and consistency
Describe ASA locking
Describe ASA blocking
Describe isolation levels, the locks they imply and the issues they resolve
Backup and Recovery
Describe the types of failure an ASA database can experience
Describe how ASA recovers from system failures
Describe the data loss associated with media failure
Describe how to protect from specific file loss (database, transaction log, mirror log)
Security
Define the areas where ASA provides security
Create and revoke users and groups
Identify the types of permissions supported by ASA
Use GRANT and REVOKE to assign permissions
Secure the database file using encryption
Secure client/server communications using encryption
Describe the tools available to audit activity
Describe how to control the actions a server can perform
Common Administration Tools
Unload database - and how to reload and rebuild
Upgrade database
Translate log file
Change log file settings
Stop server
DBISQL
Unload/load table
Automating Tasks with Schedules and Events
Describe the difference between a schedule and an event
Create a schedule to perform a routine task such as a backup
Describe the types of events that can be responded to
Create an event that provides notification when some condition has occurred (for example, low disk space)
Describe the limitations of schedules and events
Programming Interfaces
Describe the programming interfaces for ASA
Describe when each interface can be used
Describe specific behavior changes in ASA for each interface
Performance and Tuning
Identify and discuss hardware and software factors affecting database performance
Describe how keys and indexes affect database performance
Describe the trade-offs involved in using indexes and derived data
Describe the impact of stored procedures and triggers on database performance
Describe how the query optimizer works
Identify the type of information given in a query plan
Stored Procedures and Triggers
Describe the capabilities of triggers and procedures
Explain the basic programming constructs available
Explain how to create, run and debug triggers and procedures
Accessing Remote Data
Describe how to create and use proxy tables
Discuss what proxy tables can and cannot do
Deployment Issues
Explain the major issues in deploying an ASA database server, client and database
Describe the major components that can be deployed.
Sybase Adaptive Server Anywhere Developer (Version 8.0)
