Given the following statement: create clustered index idx1 on titles(title_id) on new_segment Wher - B. The statement will fail. - 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: 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

Answer: B. The statement will fail.

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

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

Answer:

B. The statement will fail. 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
	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
	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
	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

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