Questions And Answers PDF
Sybase 510-025 Adaptive Server Enterprise 15.0 Administrator Associate Exam
Version: DEMO
http://www.TestWarrior.com/510-025-practice-exam.html
FOR 510-025 Candidates: We offer Two Products: 1st - We have Practice Tests Software with Actual Exam Questions 2nd - Questions and Answers in PDF Format. Try a Free DEMO of these Exam Products via below Link:
http://www.TestWarrior.com/510-025-practice-exam.html
TestWarrior.com
1
Questions And Answers PDF
Question: 1. Which commands can be used to specify the number of histogram steps in systatstcsc (Choose 2) A. create index B. optdiag C. update statstcs D. reorg E. sp_modifystats
Answer: AC Question: 2. What are the partton strategies that allow you to add parttons using alter tablec (Choose 2) A. hash B. list C. range D. round robin
Answer: BC Question: 3. Cursors can now be declared as which of the followingc (Choose 4) A. scrollable B. forward_only C. backward_only D. non-scrollable E. insensitie F. semi-sensitie
Answer: ADEF Question: 4. Which alter table clause will change an APL table to allow row leiel lockingc A. lock datarows B. lock datapages C. lock allpages D. with fllfactor = 1
Answer: A
TestWarrior.com
2
Questions And Answers PDF
Question: 5. Which of the following are true about using the load database commandc(Choose 3) A. the database must be at least as large as the size of the database dump B. the database must haie been created with the for load opton C. the database must be exactly the same size as the database dump D. the database must not be in use E. the database need not exist because load database will create the database F.the database must not be marked as suspect
Answer: ADF Question: 6. Giien that the following set of commands are executed in a 2k serier: sp_cacheconfg mycache, 100M,go sp_poolconfg mycache, 50M, 4Kgo sp_poolconfg mycache, 10M, 16K, 4Kgo Which of the following are TRUEc (Choose 2) A. mycache is 40M B. 4K bufer pool is 50M C. 4k bufer pool is 40M D. 2K bufer pool is 50M E. no 2K bufer pool
Answer: CD Question: 7. Which system database is used to store distributed transacton management datac A. sybsystemprocs B. model C. sybsystemdb D. sybsecurity
Answer: C Question: 8. Which of the following databases is used to store Job Scheduler informatonc A. sybmigratedb B. sybmgmtdb C. sybsecurity D. sybsystemdb
TestWarrior.com
3
Questions And Answers PDF
Answer: B Question: 9. Which of the following system databases will be built during an ASE installatonc (Choose 4) A. master B. model C. sybsyntax D. sybsecurity E. sybsystemdb F.sybsystemprocs
Answer: ABEF Question: 10. Which of the following utlity programs are capable of reierse engineering table defnitonsc (Choose 2) A. bcp B. ddlgen C. optdiag D. sribuild E. Sybase Central
Answer: BE Question: 11. During the installaton, which of the following databases are created on the master deiicec (Choose 2) A. dbccdb B. model C. sybsecurity D. sybsystemprocs E. tempdb
Answer: BE
TestWarrior.com
4
Questions And Answers PDF
Thank You for Trying Our Product Visit Our Site to Purchase the Full Set of Actual 510-025 Exam Questions With Answers.
http://www.TestWarrior.com/510-025-practice-exam.html We Also Provide Practice Exam Software That Simulates Real Exam Environment And Has Many Self-Assessment Features. Download Free Product Demo From:
Download Free Product Demo from: http://www.TestWarrior.com/510-025-practice-exam.html
Check Out Our Customer Testimonials
TestWarrior.com
5