You are tuning an ASE which is at "steady state". If you suspect, based on current usage, that too - D. sp_monitorconfig - 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: 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

Answer: D. sp_monitorconfig

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

Question: 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

Answer:

D. sp_monitorconfig 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 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
	Which of the following steps is NOT always necessary for performing a tuning benchmark? A. record a baseline measurement B. change one variable, holding all others constant C. make a new measurement D. restart Adaptive Serv	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
	A decision support (DSS) application is communicating with the ASE server. The server configuration has been tuned to support the needs of the DSS application and the following configuration parameters have been set: default network packet size = 8192 maximum network packet size = 8192 additional network memory = 75776 The DSS application is connecting to the server using the value of "default network packet size" parameter as its requested packet size. A new online transaction processing (OLTP) application is added to the server. A typical insert or update statement from the OLTP application is less than 200 bytes. Without impacting the performance of the existing DSS application, which two changes should be made to improve the network performance of the OLTP application? (Choose 2.) A. Decrease the size of the "default network packet size" parameter to 512. B. Decrease the size of the "max network packet size" parameter to 4096. C. Increase the value of the "additional network memory" parameter to 151552 (or 2 * 75776). D. Modify the DSS client to connect to the server using the value of the "max network packet size" parameter as its requested packet size. E. Modify the DSS client to connect to the server using the value of the "additional network memory" parameter as its requested packet size.	View Answer
	A query and any views in a query can reference how many user tables? A. 12 B. 16 C. 32 D. 50 E. 192	View Answer
	The following query is executed frequently against the database. select ta.title_id, a.au_lname from titleauthor ta, authors a where ta.au_id = a.au_id Which database denormalization technique could be used to improve the performance of this query? A. Add the redundant column au_id to the titleauthors table. B. Add the redundant column au_lname to the titleauthors table. C. Move the title_id column to the authors table. D. Move the au_lname column to the titleauthors table. E. Change the associative table titleauthor to use the natural key for both the title and the author.	View Answer
	Which of the following are true of the Datarows Locking Scheme? (Choose 2) A. Index pages are locked. B. No transaction locks are held on index pages. C. Server uses page locks and row locks, but not table locks. D. Server uses table locks and row locks, but not page locks.	View Answer
	Transaction Isolation Level 2 is directly supported in the following lock scheme(s): A. Allpages B. Allpages, Datapages C. Allpages, Datapages, Datarows D. Datapages, Datarows	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
	If the command "lock table titles in share mode wait 2" is issued and the lock can not be acquired within the time period, A. the batch is aborted B. the transaction is rolled back C. an informational message is generated D. the command waits indefinitely	lock can not be acquire - Sybase Certification Exams Interview Questions & Answers"> View Answer
	Which statement is not true about cache partitioning? A. Default data cache can be partitioned B. A named cache with a 16K buffer pool can be partitioned C. Cache partitioning requires a server reboot D. A 2MB named cache can be divided into 8 cache partitions E. Named caches using the relaxed LRU cache replacement strategy can be partitioned	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