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
	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
	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
	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.		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 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
	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
	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
	systabstats 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
	Engine affinity restricts a task to run on: A. only one engine. B. an engine when it is made online using dbcc online (engine) C. an engine or a group of engines D. none of the above		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. Creating a second buffer pool in a heavily used named cache E. Returning to a single engine configuration		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
	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 Serv		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
	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
	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.		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
	How does the optimizer choose the optimal degree of parallelism for partition based scans? A. It will use the maximum number of available worker processes B. It will use the maximum allowed worker processes based on "max parallel degree" C. It will use the maximum allowed worker processes based on "max scan parallel degree" D. It will use at most one worker process for every partition in the table. E. It will use no more than 3 worker processes.		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
	An 8-engine Adaptive Server is undergoing a high rate of Logical I/Os and spinlock contention in the default data cache. The DBA has used Sybase ASE Monitor and has found that two 4MB tables are table-scanning within the application. This is causing 50% of the server's Logical I/Os. The code within the application cannot be changed. The task for the DBA is to increase throughput of the Adaptive Server and lower the amount of spinlock contention without changing indexes, tables or the application. Which two are valid operations which should be done to meet this objective? (Choose 2.) A. Create two named caches of 2 MB each and then recycle the Adaptive Server to activate them. B. Create two named caches of 5 MB each and then recycle the Adaptive Server to activate them. C. Create two 5MB 16KB Page Pools within the default data cache. Bind the two small tables to these page pools. D. Bind the two tables to their own newly-created and active named cache. E. Compress the tables which join to the two small tables so that they are chosen as outer tables. This will eliminate the need to table scan the small tables.		View Answer

1 2 3 4 5 6 7 8 Next

SEARCH INTERVIEW QUESTIONS: