How does the optimizer choose the optimal degree of parallelism for partition based scans? A. It - D. It will use at most one worker process for every partition in the table. - 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: How does the optimizer choose the optimal degree of parallelism for
partition based scans?
A. It will use the maximum number of available worker processes
B. It will use the maximum allowed worker processes based on "max parallel degree"
C. It will use the maximum allowed worker processes based on "max scan parallel degree"
D. It will use at most one worker process for every partition in the table.
E. It will use no more than 3 worker processes.

Answer: D. It will use at most one worker process for every partition in the table.

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

Question: How does the optimizer choose the optimal degree of parallelism for
partition based scans?
A. It will use the maximum number of available worker processes
B. It will use the maximum allowed worker processes based on "max parallel degree"
C. It will use the maximum allowed worker processes based on "max scan parallel degree"
D. It will use at most one worker process for every partition in the table.
E. It will use no more than 3 worker processes.

Answer:

D. It will use at most one worker process for every partition in the table. 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
	Increasing "housekeeper free write percent" is likely to improve which of the following aspects of server performance (Choose 3) A. increase the frequency of "free checkpoints" B. increase the responsiveness of deadlock checking C. frees space consumed by logically deleted rows D. decrease the number of buffers "found in wash" E. compensate for I/O overloads induced by overly aggressive APF.	the following aspects o - Sybase Certification Exams Interview Questions & Answers"> View Answer
	Given: A table named books: title char(100), title_id char(15), type char(15), price money not null The books table has an index created as follows: create index price_index1 on books(price desc) Which of the following queries would be covered and not require access to the data pages? (Choose 5) A. select count(*) from books B. select sum(price) from books C. select type, sum(price) from books group by type D. select price from books E. select price from books order by price ASC F. select price from books order by price DESC	View Answer
	Engine affinity restricts a task to run on: A. only one engine. B. an engine when it is made online using dbcc online (engine) C. an engine or a group of engines D. none of the above	View Answer
	How do you reclaim space from a fragmented allpages heap table? A. run reorg command B. dump and load the database C. create and drop a clustered index D. truncate the least used pages	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
	Parallel sorting can be used for: (Choose 3) A. Sort Merge joins B. slow bcp C. Reformatting D. Creating indexes E. reorg compact	View Answer
	If an index with a matching SARG is available on a small DOL table the optimizer will do which of the following? A. Uses a table scan. B. Uses the index if the number of pages in the table is less than or equal to the "concurrency_opt_threshold" configuration. C. Uses the index if the number of pages in the table is more than the "concurrency_opt_threshold" configuration. D. Uses the index if the table has "concurrency_opt_threshold" set to 0.	View Answer
	Which of the following are valid batches? (Choose 2) A. create table tab1 (a int) execute ("select * from tab1") go B. execute ("create table tab1 (a int) ") select * from tab1 go C. execute ("create table tab1 (a int) ") execute ("select * from tab1") go	View Answer
	The reorg command may be used to: (Choose 2) A. Compact a table that uses datarows locking. B. Reclaim unused space in a table that uses allpages locking. C. Reclaim unused space in an index that uses datapages locking. D. Rebuild a table that uses allpages locking.	View Answer
	Which two are advantages of use max_rows_per_page to reduce the row density? (Choose 2.) A. It may decrease the disk space used. B. It may decrease the contention. C. It may decrease the number of page splits. D. It may decrease the number of page I/Os. E. It may help to decrease row movement of frequently updated varchar columns.	View Answer
	With sp_sysmon one can determine (Choose 3) A. Tables that have had the most logical i/os B. data caches that have been used the most C. buffer pools that have been used the most D. user log caches that have been flushed the most E. stored procedures that have been executed the most F. engines that have been used the most	View Answer
	Q: 80 What is an abstract query plan? A. It is a query plan that gets generated at run time by the optimizer B. It describes the execution plan for a query using a language created for that purpose C. It is a system table D. It is a stored procedure	View Answer
	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.	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

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