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
	The following are the server level lock promotion configuration parameters: page lock promotion HWM 200 page lock promotion LWM 100 page lock promotion PCT 60 row lock promotion HWM 1800 row lock promotion LWM 1200 row lock promotion PCT 70 Table A is a datarows locked table. It has 200 data pages and every page has 10 data rows. A serial query has acquired 1400 data row locks. What kind of lock promotion will be attempted? A. No lock promotion B. Promotion to 140 page locks C. Promotion to 140 page locks, then to a table lock D. Promotion to a table lock		View Answer
	Under what conditions can a clustered index be created using the with sorted_data option? (Choose 3) A. when dropping and recreating the clustered index on a table that uses the Allpages locking scheme B. when dropping and recreating the clustered index on a table with a clustered index cluster ratio below 1 C. after using bcp to load data into an unpartitioned empty Allpages table that has no indexes, if the data is already sorted in order of the key D. after using bcp to load data into an unpartitioned empty Data-only locking scheme table that has no indexes, if the data is already sorted in order of the key E. after creating a nonclustered index on the same key that the clustered index will be created on		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
	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 are valid batches? (Choose 2) A. create table tab1 (a int) execute ("select * from tab1") go B. execute ("create table tab1 (a int) ") select * from tab1 go C. execute ("create table tab1 (a int) ") execute ("select * from tab1") go		View Answer
	If an index with a matching SARG is available on a small DOL table the optimizer will do which of the following? A. Uses a table scan. B. Uses the index if the number of pages in the table is less than or equal to the "concurrency_opt_threshold" configuration. C. Uses the index if the number of pages in the table is more than the "concurrency_opt_threshold" configuration. D. Uses the index if the table has "concurrency_opt_threshold" set to 0.		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
	Consider the following scenario: An update has to be performed to the price column in the titles table. Two are considered, a SQL update statement versus a cursor-based approach updating the price row-by-row. What might be an advantage of cursors in this scenario? A. Faster than set-oriented processing B. May increase concurrency by committing each row as a transaction C. Reduces the number of log records D. Enables users to access the table using the cursor's security privileges.		View Answer
	What is the maximum number of key columns allowed in an index? A.16 B. 31 C. 32 D. 63		View Answer
	What is the most important criterion when ASE chooses a parallel query plan? A. total amount of work done B. number of locks C. response time D. number of logical I/Os performed		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
	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
	How do you reclaim space from a fragmented allpages heap table? A. run reorg command B. dump and load the database C. create and drop a clustered index D. truncate the least used pages		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
	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
	Spinlock contention is high in a named cache. A small database is bound to the named cache. This database fits into the named cache entirely. Cache misses do not occur within this named cache. This named cache is 20 MB in size and uses the strict-policy of buffer replacement. Which two will lower spinlock contention for the named cache? (Choose 2.) A. Set the buffer replacement policy for the specific named cache to "relaxed". B. Increase the number of online engines for this Adaptive Server Enterprise. Larger numbers of engines can spread spinlock contention out across more engines. C. Use the Adaptive Server Enterprise parallel features to process the queries in parallel for this database and lower spinlock contention on the serial process. D. Create a second named cache and bind some objects from the database to a second named cache.		View Answer
	What is the maximum number of tables allowed in a join query? A. 50 User tables and 14 work tables B. 32 User tables and 14 work tables C. 30 User tables and 12 work tables D. 16 User tables and 12 work tables		View Answer
	The following query is executed frequently against the database. select ta.title_id, a.au_lname from titleauthor ta, authors a where ta.au_id = a.au_id Which database denormalization technique could be used to improve the performance of this query? A. Add the redundant column au_id to the titleauthors table. B. Add the redundant column au_lname to the titleauthors table. C. Move the title_id column to the authors table. D. Move the au_lname column to the titleauthors table. E. Change the associative table titleauthor to use the natural key for both the title and the author.		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 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

Previous 1 2 3 4 5 6 7 8 Next

SEARCH INTERVIEW QUESTIONS: