The ACME company has an 8 CPU SMP system running Adaptive Server Enterprise (ASE). The ASE server h - D. Add named caches to and bind the appropriate objects to the named caches. - Sybase Certification Exams Interview Questions and Answers

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

CERTIFICATION EXAMS

SYBASE CERTIFICATION EXAMS

DETAILS

Question: 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. Add named caches to and bind the appropriate objects to the named caches.

Category	Sybase Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 7678 users
Added on	7/29/2015
Views	71030
Rate it!

Question: 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. Add named caches to and bind the appropriate objects to the named caches. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	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.	View Answer
	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	View Answer
	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	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Sybase Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode