Adobe Certification

　
　
Exam : Sybase 510-015
Title : Ase 12.0 Server Administration Professional


1. Given: number of worker processes = 10, max parallel degree = 5, max scan parallel degree = 4. Table A has the following characteristics: Datarows locking, No indexes, a column named price, 5000 rows, 4 partitions. A user executes the following query: Select * from A where price < $10. Which of the following conditions would cause the query to run in serial instead of parallel? (Choose 2)
A. there are not enough worker processes available at run time
B. the database option select into/bulkcopy/pllsort is not set to true
C. the partition skew is 2.3
D. the database is set for single user mode
E. max parallel degree does not match the number of partitions
Answer: AC

2. What is the purpose of dsync flag?
A. to synchronize primary and mirrored devices
B. to synchronize primary and secondary databases
C. to control whether writes to operating system files are buffered or not
D. to control Backup Server's access to a dump device
Answer: C

3. The ACME company has an 8 CPU SMP system running Adaptive Server Enterprise (ASE). The ASE server has been allocated 1.5 GB of 2.0 GB of memory available. The ASE server has been allocated 2 engines. There are 1,000 concurrent users of the ASE server.
The sp_sysmon report shows the spinlock contention rate averages 70-80% for the default data cache.
Which steps can be taken to correct this performance problem?
A. Add a 16KB buffer pool to the server.
B. Increase the size of the tempdb database.
C. Add two engines to the ASE server.
D. Add named caches to and bind the appropriate objects to the named caches.
E. Add more locks to the server.
Answer: D

4. Given:
The employees table has an index created as follows:
create index emp_index1
on employees(last_name, first_name desc)
Which of the following queries would not require a sort? (Choose 2)
A. select * from employees order by last_name, first_name
B. select * from employees order by last_name ASC, first_name DESC
C. select * from employees order by first_name DESC, last_name ASC
D. select * from employees order by last_name DESC, first_name ASC
Answer: BD

5. Which of the following statements describes readpast locking? (Choose 2)
A. It can be specified at the session, transaction, and table level.
B. It allows insert, update, and delete commands to read past any incompatible lock.
C. It allows readers to not block writers.
D. It allows select and readtext queries to silently skip all rows or pages locked with incompatible locks.
Answer: BD

hotexam has assembled to take you through 120 Q&As to your 510-015 Exam preparation. In the 510-015 exam resources, you will cover every field and category in 510-015 helping to ready you for your successful Juniper Certification.

Quality and Value for the 510-015 Exam

hotexam Practice Exams for Sybase, Inc 510-015 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 510-015 Exam

If you prepare for the exam using our hotexam testing engine, we guarantee your success in the first attempt. If you do not pass the Sybase,Inc Certification 510-015 exam (ase 12.0 server administration professional) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Sybase, Inc 510-015 Downloadable, Printable Exams (in PDF format)

Our Exam 510-015 Preparation Material provides you everything you will need to take your 510-015 Exam. The 510-015 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

510-015 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs)

Our Sybase, Inc Sybase,Inc Certification 510-015 Exam will provide you with exam questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 510-015 Exam:100% Guarantee to Pass Your Sybase,Inc Certification exam and get your Sybase,Inc Certification Certification.