We're so confident of our products that we provide no hassle product exchange.
Sybase 510-025 Exam Overview:
| Certification Vendor: | Sybase (now SAP/Broadcom) |
|---|---|
| Exam Name: | Adaptive Server Enterprise 15.0 Administrator Associate Exam |
| Exam Number: | 510-025 |
| Exam Price: | Approx. USD $150–$200 |
| Exam Duration: | 90 minutes |
| Passing Score: | 70% |
| Related Certifications: | Sybase Certified Adaptive Server Administrator Professional |
| Available Languages: | English |
| Real Exam Qty: | 60 |
| Certificate Validity Period: | No fixed expiration (legacy certification) |
| Exam Format: | Multiple Choice |
| Recommended Training: | Sybase ASE 15.0 Administration Training |
| Exam Registration: | Prometric Registration |
| Sample Questions: | Sybase 510-025 Sample Questions |
| Exam Way: | Proctored onsite at Prometric test centers |
| Pre Condition: | Recommended: Hands-on experience with ASE 15.0 and basic database administration knowledge |
| Official Syllabus URL: | http://www.sybase.co.uk/support/education/professionalcertification/adaptiveserverenterprise/adminassociate150 |
Sybase 510-025 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Performance & Monitoring | 15% | - Locking, concurrency, and contention - Query optimization and statistics |
| ASE Architecture & Installation | 15% | - Server components and system databases - Installation and configuration |
| Backup & Recovery | 15% | - Transaction log management and recovery - Dump and load operations |
| Storage & Devices | 15% | - Tablespaces and partitioning - Database devices, segments, and space allocation |
| Maintenance & Troubleshooting | 13% | - Common administrative tasks - Reorg, update statistics, and index management |
| Security & Access Control | 12% | - Password policies and authentication - Logins, users, roles, and permissions |
| Memory & Cache Management | 15% | - Data cache and buffer pools - Procedure cache and dynamic configuration |
Sybase Adaptive Server Enterprise 15.0 Administrator Associate Sample Questions:
Question #1
What will be the result if the 'disk init' command is run to create a database device and no"vdevno" is specified?
- A. The command will function properly because the server no longer uses 'vdevno'
- B. The command will create the device with avdevno assigned by the server
- C. The command will fail without any adverse affects to the server
- D. The command will fail but the operating system file will be created
Correct Answer: B 🗳️
Question #2
Which step listed below is NOT performed to enable a licensable feature in ASE 15.0?
- A. execsp_configure to register license certificate
- B. run the license management utility
- C. shut down ASE
- D. execsp_configure to turn on new feature
Correct Answer: A 🗳️
Question #3
When rebuilding the master database without backups the disk refit command restores whichsystem tables? (Choose 2)
- A. sysconfiguresX
- B. sysdevices
- C. sysdatabases
- D. sysreferences
- E. sysusages
Correct Answer: C,E 🗳️
Question #4
Which of the following statements are NOT true about database dumps? (Choose 2)
- A. backs up the transaction log
- B. truncates the transaction log
- C. performs a checkpoint
- D. cannot be run while anyone is in the database
- E. may dump unallocated pages
Correct Answer: B,D 🗳️
Question #5
_______ represents the average amount of repeated data in a column.
- A. Histogram weight
- B. RangeselectivityX
- C. Total density
- D. Cluster ratio
Correct Answer: C 🗳️
By Christine
