Given: Adaptive Server physical storage space is divided into a hierarchy. What is the hierarchy se - C. device, database fragment, allocation unit, extent, page - 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: 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

Answer: C. device, database fragment, allocation unit, extent, page

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

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

Answer:

C. device, database fragment, allocation unit, extent, page 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 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
	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
	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
	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
	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
	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

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