A company needs to connect 5000 concurrent sessions to an Adaptive Server Enterprise server. The er - B. 5 engines - 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: A company needs to connect 5000 concurrent sessions to an Adaptive
Server Enterprise server. The errorlog at startup of the ASE server shows the following:
00:00000:00000:1998/04/01 08:37:00.01 kernel Network and device connection limit is 1014.
The DBA uses sp_configure to set "number of user connections" to 5000. What is the minimum number
of engines, configured with sp_configure "max online engines", that must be used for this server to allow
the 5000 connections to simultaneously occur?
A. 1 engine
B. 5 engines
C. 6 engines
D. 4 engines
E. 10 engines

Answer: B. 5 engines

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

Question: A company needs to connect 5000 concurrent sessions to an Adaptive
Server Enterprise server. The errorlog at startup of the ASE server shows the following:
00:00000:00000:1998/04/01 08:37:00.01 kernel Network and device connection limit is 1014.
The DBA uses sp_configure to set "number of user connections" to 5000. What is the minimum number
of engines, configured with sp_configure "max online engines", that must be used for this server to allow
the 5000 connections to simultaneously occur?
A. 1 engine
B. 5 engines
C. 6 engines
D. 4 engines
E. 10 engines

Answer:

B. 5 engines 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
	Given: Adaptive Server physical storage space is divided into a hierarchy. What is the hierarchy sequence, from largest to smallest units of storage? A. allocation unit, extent, page, database fragment, device B. page, extent, database fragment, device, allocation unit C. device, database fragment, allocation unit, extent, page D. extent, allocation unit, page, device, database fragment	View Answer
	What is the degree of parallelism used in a nested-loop join? A. the product of the worker processes that access individual tables in the join B. the sum of the worker processes that access individual tables in the join C. a nested-loop join is always performed using a serial scan D. two (1 coordinating process and 1 worker process)	View Answer
	What is the maximum row size for DOL tables? A. 1024 bytes of data. B. 1958 bytes of data. C. 1962 bytes of data. D. 2000 bytes of data.	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
	Given the following statement: create clustered index idx1 on titles(title_id) on new_segment Where: The titles table has 3 partitions The target segment new_segment spans 10 devices The max parallel degree parameter is 25 The session-level parallel_degree parameter is set to 2 How will the index be created? A. With a parallel sort with 2 producers and 1 consumer B. The statement will fail. C. With a serial sort. D. With a parallel sort with 2 producers and 2 consumers	View Answer
	An application has been implemented in the production environment; and there has been a slowdown. To investigate that problem, you are looking at the procedure cache management section of the sp_sysmon output. The sp_sysmon output has reported a high percentage of 'percentage reads from disk'. What will be your action based on the above fact? A. No action is necessary based on this fact. B. The application is dynamically generating stored procedures and the server tuning will not help. C. This indicates that the procedure cache is too small and you will increase the procedure cache size. D. You will bind syscomments and sysobjects table to its own cache which will reduce the high percentage of 'procedures reads from disk'.	View Answer
	Which conditions must be true to create a nonclustered index in parallel? (Choose 3) A. the server must be configured for parallel access B. the table must be partitioned C. the database option select into/bulkcopy/pllsort must set to true D. the data must reside on a user-defined segment E. the number of pages in the table must be at least eight times the configured number of sort buffers	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. Returning to a single engine configuration	View Answer
	Which of the following operations require "quiesce database"? A. altering the database to a new size B. performing non-Sybase unmirroring and backup operations. C. truncating the transaction log D. dumping the database using Sybase Backup Server.	A. altering the database to a new s - Sybase Certification Exams Interview Questions & Answers"> View Answer
	If a DBA detects many page splits after data has been sequentially inserted by an application, what is the best option to minimize the number of future page splits? A. deactivate the ascinserts option on the table B. set the max_row_per_page to a low value C. set the fillfactor to a low value at server level D. activate the ascinserts option on the table E. set the fillfactor to a low value at table level	View Answer
	Increasing the number of pre-allocated extents to 16 is likely to help the performance of which of the following operations? A. index creation B. bcp in C. select into D. alter table lock datarows E. dbcc checkstorage	View Answer
	Given the following cursor code fragment, declare title_cursor cursor for select price from title for update go declare@price money open title_cursor fetch title_cursor into @price What locks are held on the row or data page with each fetch? A. Update locks B. Exclusive locks C. Shared locks D. No locks are held	View Answer
	The following are the server level lock promotion configuration parameters: page lock promotion HWM 200 page lock promotion LWM 100 page lock promotion PCT 60 row lock promotion HWM 1800 row lock promotion LWM 1200 row lock promotion PCT 70 Table A is a datarows locked table. It has 200 data pages and every page has 10 data rows. A serial query has acquired 1400 data row locks. What kind of lock promotion will be attempted? A. No lock promotion B. Promotion to 140 page locks C. Promotion to 140 page locks, then to a table lock D. Promotion to a table lock	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
	The titles table has 50,000 rows and a nonclustered index on the price column. Which of the following queries use less logical I/Os? A. select "Min" = min(price), "Max" = max(price) from titles B. select "Min" = (select min(price) from titles), "Max" = (select max(price) from titles) C. They will both use the same number of I/Os	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 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
	What are some ways to reduce last data page lock contention for inserts? (Choose 3) A. alter the table to use the Datarows locking scheme B. alter the table to use the Datapages locking scheme C. partition the table D. create a clustered index on a random key E. increase the server configuration for the number of locks F. increase the server configuration for the deadlock checking period	View Answer
	When a row is deleted on a table with datarows locking: A. Rows on the page are moved up so the empty space is at the end of the page. B. The space occupied by the deleted row is not reclaimed immediately. C. The space occupied by the deleted row is filled with zeros. D. The last row on the page is moved into the space created by the deleted row.	View Answer
	Which two actions can cause locking on system tables in tempdb? (Choose 2.) A. create table in tempdb B. select into a #temptable C. worktables created for reformatting D. selecting from a large table in tempdb	View Answer
	The "abstract plan language" is: A. A language used to tell the optimizer how to process a query. B. The internal command language used by sp_sysmon. C. A new type of command language for creating very complicated queries. D. The language used internally by the server for planning the most efficient use of memory.	A. A language used to tell the optimizer how to process a query. - Sybase Certification Exams Interview Questions & Answers"> 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