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
	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
	Where can the last page of a partition be found for an APL table? A. sysindexes B. root page C. OAM page D. allocation page E. control page		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
	Parallel sorting can be used for: (Choose 3) A. Sort Merge joins B. slow bcp C. Reformatting D. Creating indexes E. reorg compact		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
	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
	When you run optdiag command on a allpages-locked table with 1000 pages, what will be value of "Forwarded row count"? A. 1000 B. 500 C. 0 D. 1		View Answer
	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
	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
	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
	Increasing "runnable process search count" will have the effect of: A. enabling more online engines to work together in a cluster B. increasing the amount of CPU time ASE consumes when all users are sleeping C. making ASE less responsive when an I/O intensive workload is present D. increasing the number of user connections that can be scheduled at once E. increasing the aggressiveness of APF		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
	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
	With sp_sysmon one can determine (Choose 3) A. Tables that have had the most logical i/os B. data caches that have been used the most C. buffer pools that have been used the most D. user log caches that have been flushed the most E. stored procedures that have been executed the most F. engines that have been used the most		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
	When configuring the "additional network memory" parameter, the number of buffers required per connection must be taken into consideration. How many buffers does each connection require? A. 1 B. 2 C. 3 D. 4 E. 5		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
	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
	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
	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

Previous 1 2 3 4 5 6 7 8 Next

SEARCH INTERVIEW QUESTIONS: