What is the most important criterion when ASE chooses a parallel query plan? A. total amount of w - C. response time - 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: What is the most important criterion when ASE chooses a parallel query
plan?
A. total amount of work done
B. number of locks
C. response time
D. number of logical I/Os performed

Answer: C. response time

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

Question: What is the most important criterion when ASE chooses a parallel query
plan?
A. total amount of work done
B. number of locks
C. response time
D. number of logical I/Os performed

Answer:

C. response time 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
	What type of access method is used when you delete from a partitioned table with a useful clustered index? A. hash based table scan B. partitioned index scan C. serial index scan D. serial table scan	View Answer
	Which are the two ways for boosting the performance of parallel sort during index creation? (Choose 2.) A. "trunc log on chkpt" database option set to true in the target database B. configuring a pool of 16K buffers in the cache used by the sort C. create index...with consumers = N (when index is written to a segment on a RAID device) D. set scan_parallel_degree N (where N = number of target partitions) E. keep tempdb on one contiguous device	View Answer
	Under what conditions can a clustered index be created using the with sorted_data option? (Choose 3) A. when dropping and recreating the clustered index on a table that uses the Allpages locking scheme B. when dropping and recreating the clustered index on a table with a clustered index cluster ratio below 1 C. after using bcp to load data into an unpartitioned empty Allpages table that has no indexes, if the data is already sorted in order of the key D. after using bcp to load data into an unpartitioned empty Data-only locking scheme table that has no indexes, if the data is already sorted in order of the key E. after creating a nonclustered index on the same key that the clustered index will be created on	View Answer
	What type of access method can be used for an unpartitioned APL table with a useful clustered index? A. hash based table scan B. serial table scan C. serial index scan D. clustered index partition scan	View Answer
	When configuring the "additional network memory" parameter, the number of buffers required per connection must be taken into consideration. How many buffers does each connection require? A. 1 B. 2 C. 3 D. 4 E. 5	number of buffers required per co - Sybase Certification Exams Interview Questions & Answers"> 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
	Assuming that all other user tasks are running with the default execution class, assigning execution class EC3 to a long-running CPU intensive application will have which of the following effects: A. improve the responsiveness of the long-running task, possibly shortening its elapsed time. B. cause the long running task to consume all available CPU time, starving other tasks C. increase the rate at which deadlocks occur. D. substantially decrease the frequency of scheduling the long running task, slowing it down. E. increase the amount of unspent idle time available for future demand.	View Answer
	Where are table/index level statistics stored? A. sysstatistics B. systabstats C. On the leaf level of the index D. The GAM page E. The distribution page	View Answer
	Which of the following statements are true of table statistics: (Choose 2) A. Creating statistics on unindexed columns can improve the performance of some queries. B. Truncating a table deletes the column-level statistics in sysstatistics. C. Dropping an index will drop statistics on its column(s). D. Histograms are kept on a per-column basis	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
	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.	View Answer
	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.	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

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