Advertisements	Sybase Certification Exams Interview Questions
COOLINTERVIEW.COM CERTIFICATION EXAMS INTERVIEW QUESTIONS SYBASE CERTIFICATION EXAMS INTERVIEW QUESTIONS QUESTIONS LISTING
	Sybase Certification Exams Interview Questions & Answers Below we have listed all the Sybase Certification Exams Interview Questions and answers. Feel free to comment on any Sybase Certification Exams Interview Questions or answer by the comment feature available on the page. To buy an eBook containing 30,000 Interview Questions, with Answers, Click Here. View All Sybase Certification Exams Interview Questions & Answers - Exam Mode / Learning Mode
Sybase Certification Exams Interview Questions & Answers
Sybase is a computer software company that develops and sells database management system (DBMS) and middleware products. The company was founded in 1984, and the headquarters offices are in Emeryville, CA. Sybase was the first enterprise DBMS for the Linux operating system. Sybase is an enterprise software and services company that produces software to manage and analyze information in relational databases. Sybase is a standalone subsidiary of SAP.

Subcategories for Sybase Certification Exams Interview Questions & Answers :-

Following are sub categories for which Interview Questions & Answers are available under Sybase Certification Exams Interview Questions & Answers. Please select the appropriate sub-category:-

Adaptive Server Administrator Associate Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Adaptive Server Administrator Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Adaptive Server Enterprise SQL Developer Associate Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Adaptive Server Enterprise SQL Developer Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

PowerBuilder Developer Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

PowerDesigner Data Modeling Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Replication Server Administrator Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

SQL Anywhere Developer Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Sybase IQ Administrator Professional Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode

Previous 1 2 3 4 5 6 7 8 Next

Sort By : Latest First | Oldest First | By Rating

	Question	Rating	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
	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
	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
	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
	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
	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
	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 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
	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
	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
	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
	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 sp_sysmon output 'Large I/Os denied' reports the number of times large I/O could not be performed. The ASE cannot perform large I/O because of which three reasons? (Choose 3) A. The disk I/O controller does not allow large I/O. B. The page in a buffer already resides in another pool. C. There are no buffers available in the requested pool to perform large I/O. D. The table is not placed in its own segment and hence, large I/O can not be performed. E. The first extent of an allocation unit is always read into a 2k pool. Hence, for a table scan, at least one large I/O will be denied.		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.		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
	Which statement is not true about cache partitioning? A. Default data cache can be partitioned B. A named cache with a 16K buffer pool can be partitioned C. Cache partitioning requires a server reboot D. A 2MB named cache can be divided into 8 cache partitions E. Named caches using the relaxed LRU cache replacement strategy can be partitioned		View Answer
	What type of access method is used for a covered query? A. parallel index scan B. serial index scan C. hash based index scan D. hash based table scan		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
	Which ASE commands or utilities can be used to examine partition skew? (Choose 2) A. sp_helpdb B. sp_helpartition C. sp_help D. optdiag E. reorg		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

Previous 1 2 3 4 5 6 7 8 Next

SEARCH INTERVIEW QUESTIONS: