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

1 2 3 4 5 6 7 8 Next

Sort By : Latest First | Oldest First | By Rating

	Question	Rating	View Answer
	ystabstats does not contain information on: A. Number of data pages for a table B. Average length of data rows and leaf rows C. Stopping points for the reorg command D. Column histograms		View Answer
	Which of the following steps is NOT always necessary for performing a tuning benchmark? A. record a baseline measurement B. change one variable, holding all others constant C. make a new measurement D. restart Adaptive Server		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
	Transaction Isolation Level 2 is directly supported in the following lock scheme(s): A. Allpages B. Allpages, Datapages C. Allpages, Datapages, Datarows D. Datapages, Datarows		View Answer
	What effect does the use of the command "set sort_merge on" have on the Server? A. It changes the server level setting to allow the use of merge joins. B. It overrides the server level setting to allow the use of merge joins in the current session. C. It overrides the server level setting to allow the use of merge joins by all currently connected users. D. It allows the use of merge joins in the current session only if the server level is set to "enabled".		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
	When an engine looks for a task to run, what is the order in which it searches the priority run queues? A. It is user defined B. high, medium and low C. low, medium and high D. longest queue to shortest queue		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
	Given: number of worker processes = 10, max parallel degree = 5, max scan parallel degree = 4. A table has 3 partitions. The first partition has 70 pages, the second partition has 70 pages the third partition has 10 pages. Which of the following statements are true about the table? (Choose 2) A. the partition skew is less than 2.0 B. the partition skew is greater than 2.0 C. queries against the table cannot be optimized for partition-based parallel access because max parallel degree is greater than the number of partitions D. queries against the table can be optimized for partition-based parallel access because the average number of pages per partition is greater than 20 E. queries against the table cannot be optimized for partition-based parallel access because each partition does not have at least 20 pages		View Answer
	Which of the following applications can benefit from data-only locking? A. The table is a partitioned heap table that has a high rate of inserts B. Applications need to maintain an extremely high transaction rate even though contention is low C. Applications require clustered access to the data rows due to range queries or order by clauses D. A nonclustered index is required and all the inserts occur at the end of the index		View Answer
	Which of the following stored procedures is used to display the current sessions scheduling and engine affinity properties A. sp_showcontrolinfo B. sp_displaylogin C. sp_who D. sp_showpsexe		View Answer
	Which one of the following queries would not benefit from parallel sorting? A. Queries that use distinct B. Queries that perform merge-joins requiring sorts. C. Queries that use the reformatting strategy. D. Queries that use union all.		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
	Scheduling priority is a direct attribute of which of the following: A. Engine Group B. Execution Class C. Application D. Stored procedure E. Database		View Answer
	Given that all other user tasks are running with the default execution class, assigning execution class EC1 to a long-running I/O 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. permit other tasks to saturate the available CPU resources, causing a bottleneck.		View Answer
	Which of the following is true about the configuration option "max scan parallel degree"? A. By default hash based scans will not occur B. It must be greater than or equal to "max parallel degree" C. It is a static parameter D. It sets the maximum number of worker processes for any query E. "set scan parallel degree n" may be used to temporarily use more worker processes than "max scan parallel degree"		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 of the following can NOT have an assigned execution class A. database B. A stored procedure C. An application D. A login		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
	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

1 2 3 4 5 6 7 8 Next

SEARCH INTERVIEW QUESTIONS: