What are some ways to reduce last data page lock contention for inserts? (Choose 3) A. alter the - A. alter the table to use the Datarows locking scheme C. partition the table D. create a clustered index on a random key - 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 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

Answer: A. alter the table to use the Datarows locking scheme
C. partition the table
D. create a clustered index on a random key

Category	Sybase Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 8339 users
Added on	8/2/2015
Views	68786
Rate it!

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

Answer:

A. alter the table to use the Datarows locking scheme
C. partition the table
D. create a clustered index on a random key 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
	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
	All of the following execution class associations exist in the ASE when user FRED, running application ctisql, logs in. Which one will be applied to FREDs session? A. sp_bindexeclass ctisql, AP, NULL, EC1 B. sp_bindexeclass ctisql, AP, FRED, EC2 C. sp_bindexeclass FRED, LG, NULL, EC1 D. sp_bindexeclass FRED, LG, ctisql, EC2 E. It depends on the order of the creation of the bindings	View Answer
	What is the purpose of dsync flag? A. to synchronize primary and mirrored devices B. to synchronize primary and secondary databases C. to control whether writes to operating system files are buffered or not D. to control Backup Server's access to a dump device	View Answer
	The ACME company has an 8 CPU SMP system running Adaptive Server Enterprise (ASE). The ASE server has been allocated 1.5 GB of 2.0 GB of memory available. The ASE server has been allocated 2 engines. There are 1,000 concurrent users of the ASE server. The sp_sysmon report shows the spinlock contention rate averages 70-80% for the default data cache. Which steps can be taken to correct this performance problem? A. Add a 16KB buffer pool to the server. B. Increase the size of the tempdb database. C. Add two engines to the ASE server. D. Add named caches to and bind the appropriate objects to the named caches. E. Add more locks to the server.	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
	Q: 2 Given: number of worker processes = 10, max parallel degree = 5, max scan parallel degree = 4. Table A has the following characteristics: Datarows locking, No indexes, a column named price, 5000 rows, 4 partitions. A user executes the following query: Select * from A where price < $10. Which of the following conditions would cause the query to run in serial instead of parallel? (Choose 2) A. there are not enough worker processes available at run time B. the database option select into/bulkcopy/pllsort is not set to true C. the partition skew is 2.3 D. the database is set for single user mode E. max parallel degree does not match the number of partitions	View Answer
	The employees table has an index created as follows: create index emp_index1 on employees(last_name, first_name desc) Which of the following queries would not require a sort? (Choose 2) A. select * from employees order by last_name, first_name B. select * from employees order by last_name ASC, first_name DESC C. select * from employees order by first_name DESC, last_name ASC D. select * from employees order by last_name DESC, first_name ASC	View Answer
	If sp_sysmon output consistently shows a high number of Voluntary Yields, which configuration parameter could be modified to improve performance? A. user log cache size B. time slice C. identity grab size D. stack size E. cpu accounting flush interval	View Answer
	Given a user of application ctisql is assigned EC2. When she uses a stored procedure bound to EC1, her scheduling priority is: A. high B. medium C. low D. unable to be determined	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
	Adaptive Server sets a demand lock to indicate that a transaction is next in queue to lock a table or page. Which statement best describes demand locking behavior in serial or parallel execution? A. When queries are running in serial, demand locking treats all the shared locks from a family of worker processes as if they were a single task. B. When queries are running in parallel, demand locking treats all the shared locks from a family of worker processes as if they were a single task. C. When queries are running in parallel, demand locking treats all the shared locks from a family of worker processes as if they were a different task. D. When queries are running in serial there is no need for demand locking.	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
	Q: 115 Which of the following create table can prevent or minimize row forwarding in DOL tables? A. fillfactor B. max_rows_per_page C. exp_row_size D. reservepagegap	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
	The best way to keep a clustered APL table compact when inserting data that is naturally ordered in the same sequence as the index key is to: A. enable MRU buffer replacement on the table B. reduce the identity_gap of the table C. force use of a "safe" nonclustered index D. increase the reservedpagegap for the table E. enable ascinserts on the table	View Answer
	Spinlock contention is high in a named cache. A small database is bound to the named cache. This database fits into the named cache entirely. Cache misses do not occur within this named cache. This named cache is 20 MB in size and uses the strict-policy of buffer replacement. Which two will lower spinlock contention for the named cache? (Choose 2.) A. Set the buffer replacement policy for the specific named cache to "relaxed". B. Increase the number of online engines for this Adaptive Server Enterprise. Larger numbers of engines can spread spinlock contention out across more engines. C. Use the Adaptive Server Enterprise parallel features to process the queries in parallel for this database and lower spinlock contention on the serial process. D. Create a second named cache and bind some objects from the database to a second named cache.	View Answer
	Given FREDs login is assigned EC2. When he uses a stored procedure bound to EC3 his scheduling priority is: A. high B. medium C. low D. unable to be determined	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
	Where can the last page of a partition be found for an APL table? A. sysindexes B. root page C. OAM page D. allocation page E. control page	View Answer
	What is the maximum number of tables allowed in a join query? A. 50 User tables and 14 work tables B. 32 User tables and 14 work tables C. 30 User tables and 12 work tables D. 16 User tables and 12 work tables	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