CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • Advertisements Sybase Certification Exams Interview Questions
    COOLINTERVIEW.COM CERTIFICATIONS 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 9000 Interview Questions, with Answers, Click Here.

    Subcategories for Sybase Certification Exams Interview Questions - The following are sub categories for which Interview Questions are available under this category. Please select the appropriate sub-category:

    Adaptive Server Administrator Associate Certification Exam Interview Questions (1)

    Adaptive Server Administrator Professional Certification Exam Interview Questions (0)

    Adaptive Server Enterprise SQL Developer Associate Certification Exam Interview Questions (0)

    Adaptive Server Enterprise SQL Developer Professional Certification Exam Interview Questions (0)

    PowerBuilder Developer Professional Certification Exam Interview Questions (0)

    PowerDesigner Data Modeling Professional Certification Exam Interview Questions (0)

    Replication Server Administrator Professional Certification Exam Interview Questions (0)

    SQL Anywhere Developer Professional Certification Exam Interview Questions (3)

    Sybase IQ Administrator Professional Certification Exam Interview Questions (0)

    1 2 3 4 5 6 7 8 Next

    Sort By :   Latest First  |  Oldest First  |  By Rating

    Question
    Rating
    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
    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
    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
    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
    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
    Q: 80 What is an abstract query plan? A. It is a query plan that gets generated at run time by the optimizer B. It describes the execution plan for a query using a language created for that purpose C. It is a system table D. It is a stored procedure
    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
    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
    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
    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
    A company needs to connect 5000 concurrent sessions to an Adaptive Server Enterprise server. The errorlog at startup of the ASE server shows the following: 00:00000:00000:1998/04/01 08:37:00.01 kernel Network and device connection limit is 1014. The DBA uses sp_configure to set "number of user connections" to 5000. What is the minimum number of engines, configured with sp_configure "max online engines", that must be used for this server to allow the 5000 connections to simultaneously occur? A. 1 engine B. 5 engines C. 6 engines D. 4 engines E. 10 engines
    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
    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
    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
    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
    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
    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
    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
    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 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

    1 2 3 4 5 6 7 8 Next

    A D V E R T I S E M E N T





    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0.014648 Seconds