An 8-engine Adaptive Server is undergoing a high rate of Logical I/Os and spinlock contention in th - B. Create two named caches of 5 MB each and then recycle the Adaptive Server to activate them. D. Bind the two tables to their own newly-created and active named cache. - 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: An 8-engine Adaptive Server is undergoing a high rate of Logical I/Os and
spinlock contention in the default data cache. The DBA has used Sybase ASE Monitor and has found that
two 4MB tables are table-scanning within the application. This is causing 50% of the server's Logical
I/Os. The code within the application cannot be changed.
The task for the DBA is to increase throughput of the Adaptive Server and lower the amount of spinlock
contention without changing indexes, tables or the application.
Which two are valid operations which should be done to meet this objective? (Choose 2.)
A. Create two named caches of 2 MB each and then recycle the Adaptive Server to activate them.
B. Create two named caches of 5 MB each and then recycle the Adaptive Server to activate them.
C. Create two 5MB 16KB Page Pools within the default data cache. Bind the two small tables to these page
pools.
D. Bind the two tables to their own newly-created and active named cache.
E. Compress the tables which join to the two small tables so that they are chosen as outer tables. This will
eliminate the need to table scan the small tables.

Answer: B. Create two named caches of 5 MB each and then recycle the Adaptive Server to activate them.
D. Bind the two tables to their own newly-created and active named cache.

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

Question: An 8-engine Adaptive Server is undergoing a high rate of Logical I/Os and
spinlock contention in the default data cache. The DBA has used Sybase ASE Monitor and has found that
two 4MB tables are table-scanning within the application. This is causing 50% of the server's Logical
I/Os. The code within the application cannot be changed.
The task for the DBA is to increase throughput of the Adaptive Server and lower the amount of spinlock
contention without changing indexes, tables or the application.
Which two are valid operations which should be done to meet this objective? (Choose 2.)
A. Create two named caches of 2 MB each and then recycle the Adaptive Server to activate them.
B. Create two named caches of 5 MB each and then recycle the Adaptive Server to activate them.
C. Create two 5MB 16KB Page Pools within the default data cache. Bind the two small tables to these page
pools.
D. Bind the two tables to their own newly-created and active named cache.
E. Compress the tables which join to the two small tables so that they are chosen as outer tables. This will
eliminate the need to table scan the small tables.

Answer:

B. Create two named caches of 5 MB each and then recycle the Adaptive Server to activate them.
D. Bind the two tables to their own newly-created and active named cache. 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 is NOT true of the DOL Data Page Format? A. The page header for DOL pages is larger than for APL pages. B. There are no data page chains (nextpg/prevpg pointers are not maintained). C. Free space is dynamically maintained as one contiguous chunk D. The same page format is used for both Datarows and Datapages locked tables.	View Answer
	Increasing "runnable process search count" will have the effect of: A. enabling more online engines to work together in a cluster B. increasing the amount of CPU time ASE consumes when all users are sleeping C. making ASE less responsive when an I/O intensive workload is present D. increasing the number of user connections that can be scheduled at once E. increasing the aggressiveness of APF	A. enabling more online engin - Sybase Certification Exams Interview Questions & Answers"> View Answer
	An application uses stored procedures to perform updates, inserts and deletes for an OLTP application. Some update stored procedures optimize with a join order of table_A -> table_B. Other stored procedures optimize with a join order of table_B -> table_A. Which solution needs to be added within the stored procedures to guarantee that deadlocks are reduced or eliminated by always making the join order table_A -> table_B? A. Non-correlated subqueries to force outside-in processing B. SET FORCEPLAN ON C. (index tableorder 1) - an index hint applied to table_A D. SET SHOWPLAN ON E. Define join-ordered Views on the affected tables	View Answer
	All of the following tactics may reduce contention for cache spinlocks in an ASE configured to support multiple online engines, except A. Increasing the spinlock ratio B. Creating additional named caches and binding frequently used tables to them C. Creating partitions in heavily used caches D. Creating a second buffer pool in a heavily used named cache E. Returning to a single engine configuration	View Answer
	Which stored procedure can the DBA use to change a login's priority on-the-fly? A. sp_setpsexe B. sp_bindexeclass C. sp_unbindexeclass D. sp_addengine E. sp_modifylogin Which stored procedure can the DBA use to change a login's priority on-the-fly? A. sp_setpsexe B. sp_bindexeclass C. sp_unbindexeclass D. sp_addengine E. sp_modifylogin	View Answer
	Which of the following applications can benefit from data-only locking? A. The table is a partitioned heap table that has a high rate of inserts B. Applications need to maintain an extremely high transaction rate even though contention is low C. Applications require clustered access to the data rows due to range queries or order by clauses D. A nonclustered index is required and all the inserts occur at the end of the index	View Answer
	Which of the following statements best describes a DOL table with a cluster ratio of 0.97: A. The table is poorly structured and should be fixed by a reorg rebuild B. Dense table packing will increase the probability of data page splits C. Large I/O strategies will be particularly effective on this table D. The clustered index is almost as big as the table itself. E. Row forwarding is extremely unlikely due to large allocation gaps.	View Answer
	How many predefined execution classes are there in ASE? A. 4 B. 3 C. 2 D. 1	View Answer
	Q: 69 What are the three attributes of an execution class? A. login name, host, and client B. client, stored procedure, and time slice C. base priority, time slice and engine group D. session id, worker process, and engine group	View Answer
	You are tuning an ASE which is at "steady state". If you suspect, based on current usage, that too much memory is allocated to open object structures in your server, which of the following procedures should you use to most directly confirm or refute your hypothesis? A. sp_helpconfig B. sp_countmetadata C. sp_object_stats D. sp_monitorconfig E. sp_configure	current usage, that to - Sybase Certification Exams Interview Questions & Answers"> View Answer
	Which of the following cache or IO tuning methods can reduce the spinlock contention on a single "hot" table that is already bound to a named cache? A. Create 16K buffer pool in the named cache B. Change the cache replacement strategy of the named cache to relaxed LRU C. Partition the named cache D. Increase the named cache size	View Answer
	The following query is executed frequently against the database. select a.au_fname, a.au_lname, ad.street, ad.city, ad.state, ad.zip from authors a, author_address ad where a.au_id = ad.au_id What database denormalization technique could be used to improve the performance of this query? A. Move the au_lname and au_fname columns to the author_address table. B. Collapse the author_address and authors table into a single table. C. Move the street, city, state, and zip columns to the authors table. D. Create a view called mailing_address to eliminate the two table join from the query. E. Add the redundant column au_id to the author_address table.	View Answer
	Consider the following scenario: An update has to be performed to the price column in the titles table. Two are considered, a SQL update statement versus a cursor-based approach updating the price row-by-row. What might be an advantage of cursors in this scenario? A. Faster than set-oriented processing B. May increase concurrency by committing each row as a transaction C. Reduces the number of log records D. Enables users to access the table using the cursor's security privileges.	View Answer
	What effect does the use of the command "set sort_merge on" have on the Server? A. It changes the server level setting to allow the use of merge joins. B. It overrides the server level setting to allow the use of merge joins in the current session. C. It overrides the server level setting to allow the use of merge joins by all currently connected users. D. It allows the use of merge joins in the current session only if the server level is set to "enabled".	Server? A. It changes - Sybase Certification Exams Interview Questions & Answers"> View Answer
	The sp_sysmon output 'Large I/Os denied' reports the number of times large I/O could not be performed. The ASE cannot perform large I/O because of which three reasons? (Choose 3) A. The disk I/O controller does not allow large I/O. B. The page in a buffer already resides in another pool. C. There are no buffers available in the requested pool to perform large I/O. D. The table is not placed in its own segment and hence, large I/O can not be performed. E. The first extent of an allocation unit is always read into a 2k pool. Hence, for a table scan, at least one large I/O will be denied.	View Answer
	What is the maximum number of key columns allowed in an index? A.16 B. 31 C. 32 D. 63	View Answer
	When you run optdiag command on a allpages-locked table with 1000 pages, what will be value of "Forwarded row count"? A. 1000 B. 500 C. 0 D. 1	View Answer
	What type of access method is used for a covered query? A. parallel index scan B. serial index scan C. hash based index scan D. hash based table scan	View Answer
	When does the optimizer consider a hash based table scan on an APL table? A. if it is a heap table B. if it is has a clustered index C. If it is a table with a clustered index and a non clustered index D. If it is a partitioned table with a clustered index	View Answer
	systabstats does not contain information on: A. Number of data pages for a table B. Average length of data rows and leaf rows C. Stopping points for the reorg command D. Column histograms	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